OT: Help Desk software recomendation

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - decompiling VFP 5.0 I understand there's a program called Refox that will do this, i'm wondering if there is anyone out there who'd be willing to do this for less than the $400 cost of their program? I've lost everything (computers and backups) in a fire, but can get customer .exe files. If anyone can help please let me know,thanks. -- jamesrav ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: OT: Help Desk software recomendation Tag: 222260
  - 2
    - Network slows down SELECT-SQL I am having a DBF named MJOB.dbf with 20000 records. The table has indexes on the following fields:- JOBNO JOBDATE JOBSERIES I have also indexed on Deleted() as set deleted in on. However, the following select-sql takes around 6-8 seconds when executed from a workstation. ***Code*** Select max(JOBNO) from MJOB ; where SERIES='A' and Between(JOBDATE,mFDate,mTdate) ; into array mARray Return mArray I tried out several things and later the following proved to be more quicker. (It takes less than 1 sec) **Code** Select JOBNO from MJOB ; where MJOB.SERIES='A' and Between(MJOB.JOBDATE,mFDate,mTdate) ; order by 1 ; into cursor c1 Select C1 Go Bottom Return C1.Code Is MAX() function not optimized by RUSHMORE or is there any other mistake in my 1st code. Kindly guide. Rajeev Tag: OT: Help Desk software recomendation Tag: 222258
  - 3
    - DWG viewer activeX Does someon know where i can download a dwg viewer activeX for foxpro Thanks Tag: OT: Help Desk software recomendation Tag: 222256
  - 4
    - OLEDragdrop question hi, I've got an application which uses the MS listview activex control. I want to be able to drag an item from that listview control and drop it onto the windows desktop and have it create a textfile with the name of the listview item I just dragged. Does anybody have any code that demonstrates how to do this? Thanks Tristan Tag: OT: Help Desk software recomendation Tag: 222253
  - 5
    - SQL group by error the following command works fine in VFP 6, but won't work with VFP 9. I get a "1807: SQL: group by clause is missing or invalid". What is wrong with it?! (something silly I've missed I bet) select Creditor.CreditorCd, Creditor.AddrRecID, ; GetDisc(Creditor.PromptTerm) as Discount, ; CredTran.CrTranID, TranDate, PayBy, Reference, CredTran.Amount, ; CredTran.Outstandng, TotAuthAmt, PromptTerm, CredTran.Paid, CredTran.TaxAmount, ; 00000.00 as DisAmount, 000000000.00 as AmtToPay, ; 00000000.00 as Pay, "Chq" as cPayType, ; count(1) as LineCount ; from CredTran inner join Creditor ; on CredTran.AddrRecID = Creditor.AddrRecID ; inner join TranLine ; on TranLine.CrTranID = CredTran.CrTranID ; where PayBy <= pdPayToDate .and. CredTran.Outstandng > 0 ; and TotAuthAmt > 0 and TotAuthAmt <> CredTran.Paid ; and OK2Alloc({}, CredTran.Outstandng, .T., CredTran.TranType, CredTran.Status, .T.) ; group by CredTran.CrTranID ; order by PayBy ; into table (lcFileName) Grant Tag: OT: Help Desk software recomendation Tag: 222251
  - 6
    - Grid column sorting Hi all, I have a table "A" with a field booknumber that points to booknumber in another table "Books", the relationship is one to many. if I have the table "A" in a grid and point the ControlSource of the booknumber to the bookname in "Books", how can I sort the grid by the bookname and not the booknumber when I click on the column header. this is the code I use in the Click event of the column header oGrd = Thisform.pageframe1.page2.grdtableA oGrd.SetAll("Picture","","Header") SET ORDER to booknumber ascending GO top oGrd.refresh I want to be able to sort the grid using the bookname from the books table. I know I can do that by using a view, but any other ideas? Thanks HME -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: OT: Help Desk software recomendation Tag: 222250
  - 7
    - In order to calculate the check number Hello there! I would like to ask for you help. In order to calculate the check number, I have to determine the division of a 21 digits number by 97 and for that I use the MOD () command. The problem is that Fox only uses 15 digits for numeric values, and I would need to get the result more then only 15 digits. The command is mod(2500003842908003100,97) Do you know how I can solve this problem? Thanks in advance, Pedro PS - sorry for the bad English Tag: OT: Help Desk software recomendation Tag: 222245
  - 8
    - Changing a report after the exe is made Is there a way to make changes to a report in the manner below after the executable is made? I'd like to parse the report according to the user's selections. Thanks ***********code - not mine LOCAL ARRAY laForms[1], laLinesToWipe[1], laSettings[1] LOCAL lnCurForm, lnFormCount, llNeedsCompiling, lcOldDir, lnNamesOnLine, ; lcOldFont, lnNumSettings, lcTargSetting, lnLoop, lcNewExpr *----------------------------- Program Code Begin ------------------------- - #define MAX_LINE_NAMES 4 #define NAME_WIDTH 28 lcOldDir = ALLTRIM(SET("DEFAULT")+ALLTRIM(CURDIR())) IF !EMPTY(tcWhere) AND TYPE("tcWhere") = 'C' set default to (tcWhere) ENDIF CLEAR CLOSE TABLES ALL IF MessageBox("About to clear printer info from all reports in"+CHR(13)+CHR(13)+ ; ALLTRIM(CURDIR())+CHR(13)+CHR(13)+ ; "Go for it?",36,"Mass Report Update!") != 6 WAIT "Aborted." WINDOW TIMEOUT 1 set default to (lcOldDir) RETURN .F. ENDIF lcOldFont = _SCREEN.FontName _SCREEN.FontName = "Courier New" lnNamesOnLine = 0 * * Identify lines in FRX expr field to wipe out: * DIMENSION laLinesToWipe[3] laLinesToWipe[1] = "DRIVER=" laLinesToWipe[2] = "DEVICE=" laLinesToWipe[3] = "OUTPUT=" * * For each FRX file in the current directory: * lnFormCount = ADIR(laForms,"*.FRX") ASORT(laForms,1) FOR lnCurForm = 1 TO lnFormCount llNeedToCompile = .F. * * Open the form as a table: * USE (laForms[lnCurForm,1]) IN 77 SELECT 77 * * The first record has the printer info: * LOCATE IF !EMPTY(tag) OR !EMPTY(tag2) llNeedToCompile = .T. ENDIF * * Clear the tag fields: * REPLACE tag WITH "", ; tag2 WITH "" * * Remove the printer info from the expr field: * lnNumSettings = ALINES(laSettings,expr,.T.) lnLoop = 1 DO WHILE lnLoop <= lnNumSettings lnInc = 1 FOR EACH lcTargSetting IN laLinesToWipe IF lcTargSetting $ laSettings[lnLoop] llNeedToComile = .T. ADEL(laSettings,lnLoop) lnNumSettings = lnNumSettings - 1 lnInc = 0 ENDIF ENDFOR lnLoop = lnLoop + lnInc ENDDO lcNewExpr = "" FOR lnLoop = 1 TO lnNumSettings lcNewExpr = lcNewExpr+ALLTRIM(laSettings[lnLoop])+CHR(13)+CHR(10) ENDFOR REPLACE expr WITH lcNewExpr *MessageBox("Before: "+chr(13)+expr+chr(13)+chr(13)+"After: "+chr(13)+lcNewExpr) IF lnNamesOnLine < MAX_LINE_NAMES ?? PADR(ALLTRIM(laForms[lnCurForm,1])+IIF(llNeedToCompile,'*',''),NAME_WIDTH) ELSE ? PADR(ALLTRIM(laForms[lnCurForm,1])+IIF(llNeedToCompile,'*',''),NAME_WIDTH) lnNamesOnLine = 0 ENDIF lnNamesOnLine = lnNamesOnLine + 1 SELECT 77 USE * * Compile the FRX: * IF llNeedToCompile COMPILE REPORT (laForms[lnCurForm,1]) ENDIF ENDFOR set default to (lcOldDir) Marcel Jalbert seemed to utter in news:22Wi7.289588$v5.29128506@news1.rdc1.ct.home.com: - Hide quoted text - - Show quoted text - > I been working around a problem for years where a FoxPro report form > fails to print to the selected printer or to the Windows default > printer. Anyway to make a long story short, when I compose a report > form for a printer that exists on the Desktop or Server the application > always prints to that printer. I'm use VFP 6.0 sp4 and have seen this > problem on Windows 95 and NT desktops and VFP 5.0. By compose I mean; > Modify the Report, go to "Page Setup" select a printer, click OK and > save the report form. There appears to be some hard coding in the > report form that identifies the printer name the report form was > designed for. If this printer name exists this hard coding seems to > override the destination printer settings your application would > normally print to. There are a couple of ways I get around this > problem. > 1) Temporarily change the name of the printer you want to compose the > report form for, select the printer while editing the report from and > save it. Recompile your code and rename the printer back to it usually > name. You can't rename a printer with Windows NT. > 2) Variations on the same theme that works with Windows NT would be to > temporarily install a printer on the PC that the application will never > printer to. Compose the report form for that printer, save it, > recompile and delete the installed printer. > 3) Have multiple copies of your report forms. Each composed for the > printers you want the reports to go to. (Not a desirable solution) > Has anyone else seen this problem? Is it on a FoxPro bug list? Am I > doing somethink I shouldn't or is there a better work around? > Thanks! > Marcel -- Tag: OT: Help Desk software recomendation Tag: 222241
  - 9
    - Non-Modal windows problem - VFP 9 I am trying to instantiate several Non-Modal copies of a form in VFP from the currently running form. I have set all of the properties correctly as far as I know but, the forms end up being modal. I can move the top one around and click on objects but cannot access the one created before it without closing the last one it. I have queried the windowtype in the modeless window and it is set to 0. Any thoughts on what I am doing wrong here??? Jim Tag: OT: Help Desk software recomendation Tag: 222240
  - 10
    - Duplicate records I have imported a textfile to a table. In this file there is now records which has the same information. How is it possible to remove the duplicate records? I have tried with different index ,delete, remove,alter, update and queries but the duplicates is still there. Many thanks in advance Reidar Tag: OT: Help Desk software recomendation Tag: 222233
  - 11
    - RAID 1 OR RAID 5 - YOUR OPINION Our core processing software is written in Visual FoxPro. We have experienced some performance issues with this software - slow inquiry and slow processing speeds. We have received conflicting information from a couple of different sources regarding the type of RAID used on our server. I am asking for opinions, knowledge, etc. on whether RAID 1 OR RAID 5 works better when running a VF program. Any info would be greatly appreciated. Tag: OT: Help Desk software recomendation Tag: 222232
  - 12
    - Combo/Incremental Search/Space I have a combobox with style set to Dropdown List and Incremental Search = .t. Incremental searching works fine until I hit the space bar as part of mt search expression. For example, I want to search for "fred smith". I start typing the characters and the incremental search works fine until I get to the space character. Hitting the space drops down the list. How can I force the space character to be part of the searched-for expression and prevent it from driopping down the list? Brian Tag: OT: Help Desk software recomendation Tag: 222228
  - 13
    - Copy to Xls Command This is a multi-part message in MIME format. ------=_NextPart_000_0039_01C651DC.7517B220 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable From Vfp 9.0 issuing the command copy to excelfile type xls creates an excel file. All fields convert correctly except date column = which becomes "text" type in excel. How can I create an excel file with = the correct date format. ------=_NextPart_000_0039_01C651DC.7517B220 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DTahoma size=3D2>From Vfp 9.0 issuing the = command</FONT></DIV> <DIV><FONT face=3DTahoma size=3D2></FONT> </DIV> <DIV><FONT face=3DTahoma size=3D2><STRONG>copy to excelfile type=20 xls</STRONG></FONT></DIV> <DIV><FONT face=3DTahoma size=3D2></FONT> </DIV> <DIV><FONT face=3DTahoma size=3D2>creates an excel file. All fields = convert=20 correctly except date column which becomes "text" type in excel. How can = I=20 create an excel file with the correct date format.</FONT></DIV> <DIV><FONT face=3DTahoma size=3D2></FONT> </DIV> <DIV><FONT face=3DTahoma size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0039_01C651DC.7517B220-- Tag: OT: Help Desk software recomendation Tag: 222222
  - 14
    - So Weird function execution problem - Trying to get the owner of a file. Functions included. Hi, I have written a program that scans a directory - local or network - and for each file gets the owner name and the domain name and updates a table list. I have noticed that something weird happens during the function execution (function included). The function sometimes does not return the owner and domain. Therefore I set up a mechanism of a couple of retries and maintain a counter of retries. Now the weird things. 1. Sometimes for example for the folder c:\, I may have 200 retries, some other times more than 1000 and some other times 50. 2. Furthermore, because I don't keep trying for ever, some files do not return their owner. When I interactively later request the owner I am able to get it, so there isn't a file specific prolem. 3. The most weird. During the program tests, I had noticed that each time, different files appear in the table list without their owner/domain. What exactly is going on? Is there a timeout problem? Demetrios, Greece -------------------------------- * GetFileOwner - Get the owner of an NTFS file * * VBCode in: http://www.devx.com/vb2themax/Tip/19292 * Runs over Windows NT or 2000, and works only with files in NTFS partitions * * Requires the GetFileOwner_APIs.prg * * Usage: * ------ * GetFileOwner_APIs() * Store "" to Domain, Owner * GetFileOwner(fileName, @Domain, @Owner) * * Example: * -------- * GetFileOwner("C:\Windows\hh.exe", @Domain, @Owner) * ? Domain, Owner LParameters szfilename, Domain, Owner #Define OWNER_SECURITY_INFORMATION 1 Local m.sizeSD, m.pOwner, m.ownerName, m.domain_name, m.name_len Local m.domain_len, m.nLength, m.deUse, m.sdBuf m.sizeSD=0 && Buffer size to store Owner's SID m.pOwner=0 && Pointer to the Owner's SID m.ownerName="" && Name of the file owner m.domain_name="" && Name of the first domain for the owner m.name_len=0 && Required length for the owner name m.domain_len=0 && Required length for the domain name m.nLength=0 && Length of the Windows Directory m.deUse=0 && Pointer to a SID_NAME_USE enumerated type && indicating the type of the account m.sdBuf=" " && Buffer for Security Descriptor bSuccess=GetFileSecurity(m.szfilename, OWNER_SECURITY_INFORMATION, 0, 0, @m.sizeSD) * Create a buffer of the required size and call GetFileSecurity again m.sdBuf=Space(sizeSD) * Fill the buffer with the security descriptor of the object specified by the * filename parameter. The calling process must have the right to view the specified * aspects of the object's security status. bSuccess=GetFileSecurity(m.szfilename, OWNER_SECURITY_INFORMATION, @m.sdBuf, m.sizeSD, @m.sizeSD) * Obtain the owner's SID from the Security Descriptor, exit if error bSuccess=GetSecurityDescriptorOwner(@m.sdBuf, @m.pOwner, 0) * Retrieve the name of the account and the name of the first domain on * which this SID is found. Passes in the Owner's SID obtained previously. * Call LookupAccountSid twice, the * first time to obtain the required size of the owner and domain names. bSuccess=LookupAccountSid(NULL, m.pOwner, @m.ownerName, @m.name_len, @m.domain_name, @m.domain_len, @m.deUse) * Allocate the required space in the name and domain_name string variables. * Allocate 1 byte less to avoid the appended NULL character. if m.name_len>1 ownerName=Space(m.name_len - 1) domain_name=Space(m.domain_len -1 ) * Call LookupAccountSid again to actually fill in the name of the owner * and the first domain. bSuccess=LookupAccountSid(NULL, m.pOwner, @m.ownerName, @m.name_len, @m.domain_name, @m.domain_len, @m.deUse) Endif Domain=m.domain_name Owner=m.ownerName Return Owner * GetFileOwner_APIs * Required from GetFileOwner DECLARE INTEGER GetFileSecurity IN advapi32; STRING lpFileName,; INTEGER RequestedInformation,; STRING @pSecurityDescriptor,; INTEGER nLength,; INTEGER @lpnLengthNeeded DECLARE INTEGER GetSecurityDescriptorOwner IN advapi32; STRING @pSecurityDescriptor,; INTEGER @pOwner,; INTEGER @lpbOwnerDefaulted DECLARE INTEGER LookupAccountSid IN advapi32; STRING @lpSystemName,; INTEGER lpSid,; STRING @lpName,; INTEGER @cchName,; STRING @lpRefdDomain,; INTEGER @cchRefdDomain,; INTEGER @peUse Tag: OT: Help Desk software recomendation Tag: 222221
  - 15
    - Running FPW 2.6 code in VFP 9 - Buttons are white I have an application written in FPW 2.6 that runs in 2.6 and VFP. I'm used to running it in VFP 7.0. I just set up VFP 9.0 on the machine and I've got the application running but the buttons on the FPW 2.6 screens are colored white. The backgrounds on the screens are grey or blue. Is there a way I can have the buttons the same color as the background? Thanks. Dan Tag: OT: Help Desk software recomendation Tag: 222210
  - 16
    - any fix to redraw problem yet? I still have this problem (VFP9 SP1, but it's been around for a while), where labels and controls with labels like option buttons and checkboxes, redraw themselves with a tiny < 1 pixel offset, when other controls on a form are refreshed. The net result is that those controls, after a few refreshes, become very icky looking, sort of bold-faced, only uglier. I can get rid of it by setting visible = .t. to those controls, but having to do this hack is getting really annoying. Has this at least been acknowledged to be a problem? Any better workarounds than mine? Tag: OT: Help Desk software recomendation Tag: 222209
  - 17
    - newbie Change Parent Class Location I have a VFP9.0 that was converted from VFP6.0. One of the parent class was on E:\.......\_base.vcx I need to change it to C:\......\_base.vcx Suggestions? TIA Steve Tag: OT: Help Desk software recomendation Tag: 222207
  - 18
    - attachments in cdo I copied code: LOCAL loCDOMSG AS CDO.MESSAGE loCDOMSG = NEWOBJECT( 'cdo.message' ) WITH loCDOMSG .Subject = 'Test CDOSYS Message' .TO = 'Joe@somecompany.com' .FROM = 'joe@somecompany.com' .TextBody = 'This is the body' .Configuration.FIELDS.ITEM([http://schemas.microsoft.com/cdo/configuration/s endusing]) = 2 .Configuration.FIELDS.ITEM([http://schemas.microsoft.com/cdo/configuration/s mtpserver]) = [SMTPHOST] .Configuration.FIELDS.ITEM([http://schemas.microsoft.com/cdo/configuration/s mtpserverport]) = 25 .FIELDS([urn:schemas:httpmail:importance]) = 2 .FIELDS([urn:schemas:mailheader:priority]) = 1 .Configuration.FIELDS.UPDATE .FIELDS.UPDATE .SEND ENDWITH loCDOMSG = NULL WAIT WINDOW [Mail Sent.] TIMEOUT 1 ?But how to attach a file thanks Tag: OT: Help Desk software recomendation Tag: 222206
  - 19
    - File() Function - VP9 If I'm searching for "c:\filepath\myfile.ext" by calling FILE("c:\filepath\myfile.ext") and "myfile.ext" is part of the "Other Files" section in the project, then the FILE() function returns true even though "myfile.ext" does not exist inside of "c:\filepath". This happends ONLY when the program is compiled as an exe. The file function works correctly when run from within the VFP IDE. The VFP Help file states: "If you do not include a path with the file name, Visual FoxPro searches in the default directory for the file. If it cannot find the file in the default directory, Visual FoxPro searches along the Visual FoxPro path, which is established with SET PATH." c:\filepath\ is included when i call the FILE() function and IS NOT part of the PATH set by SET PATH. Thanks! Tag: OT: Help Desk software recomendation Tag: 222205
  - 20
    - dynamicreadonly I have a grid. Is there a way to simulate the property "DynamicReadOnly" ? Mike Farnesi San Diego Tag: OT: Help Desk software recomendation Tag: 222201
  - 21
    - Is exclusive open of table faster If you open a table exclusively does that make processing faster? Anybody have any experience or documentation on this?? Tag: OT: Help Desk software recomendation Tag: 222193
  - 22
    - class not registered.. Hi..guys. I meet a problem in my customer side ..when calling the mscomm32.ocx ..its out a error 'Class not registered' in workstation Window XP SP2. is it the window xp setting problem? I used foxpro 6.0. regards, Orange Tag: OT: Help Desk software recomendation Tag: 222188
  - 23
    - Report Problem Hi All When I Run report with reportlistener Preview (reportpreview.app) From Button In Window TestForm Created in Top Form MainForm ShowWindow = 1 when report Finish All off properties Of The TestForm and data which I created in load form from sql database and Connections lost This Happen when Run From Exe File Only any Id I use Vfp9 Sp1 Thanks Tag: OT: Help Desk software recomendation Tag: 222187
  - 24
    - KB/913807 ; KB/913161 ; KB/913571 ; KB/905756 I Can't install this update. I receive this event : Produit : Microsoft Office Professional Edition 2003 - La mise Ã jour 'Security Update for Outlook 2003: Junk E-mail Filter (KB913161): OUTLFLTR' n'a pas pu Ãªtre installÃ©e. Code d'erreur 1603. Windows Installer peut crÃ©er des journaux pour faciliter la rÃ©solution des Ã©ventuelles erreurs d'installation des packages logiciels. Utilisez le lien suivant pour afficher des instructions concernant l'activation des journaux : http://go.microsoft.com/fwlink/?LinkId=23127 0000: 7b 39 30 31 31 30 34 30 {9011040 0008: 43 2d 36 30 30 30 2d 31 C-6000-1 0010: 31 44 33 2d 38 43 46 45 1D3-8CFE 0018: 2d 30 31 35 30 30 34 38 -0150048 0020: 33 38 33 43 39 7d 20 7b 383C9} { 0028: 37 35 33 42 42 33 39 46 753BB39F 0030: 2d 32 41 38 44 2d 34 39 -2A8D-49 0038: 45 41 2d 38 38 31 31 2d EA-8811- 0040: 32 45 33 34 44 41 39 34 2E34DA94 0048: 46 36 39 43 7d 20 31 36 F69C} 16 0050: 30 33 03 Tag: OT: Help Desk software recomendation Tag: 222185
  - 25
    - White b/g isn't white?! Hi, I'm trying to make the backcolor of my form pure white. But I can't get it to show that. The backcolor of the form and the page is 255,255,255 and the page's color source is 0 (Object's Color Properties). Yet the form is clearly not white. I'm a little color blind so I can't say for sure what the color is but it looks to me as slightly grayish with a bit of pink. The page tabs are white and it's quite obvious that the page itself is not. What am I missing? This is VFP9 Thanks, Frank Tag: OT: Help Desk software recomendation Tag: 222182
- Next
  - 1
    - VFP8 performance on low memory machines I have an app that we have recently upgraded from VFP6 to VFP8. On machines with a lot of memory the performance is very good, but on machines with less memory the performance has degraded significantly. The apps are being run locally. I have had a look at sys(3050) but I am not sure whether it is the right approach to take. Any suggestions? Tag: OT: Help Desk software recomendation Tag: 222162
  - 2
    - Another query design question... Hi, Using VFP 9.0 to remotely query a SQL database and I'm stuck once again... yeah I know, what else is new? :-) This time I'm trying to make a sort of lookup table(view) from two related tables: Table name: billing_code Fields: sys_id (pk) billing_code_set_ver_sys_id billing_code description create_timestamp modify_timestamp create_user modify_user Table name: billing_code_charge_code Fields: sys_id (pk) billing_code_sys_id chg_codes_code create_timestamp modify_timestamp create_user modify_user These tables are related on the billing_code.sys_id to billing_code_sys_id, for every billing_code record there's many billing_code_charge_code records. What I want is a table that returns chg_codes_code, billing_code and description. Sounds simple doesn't it? Here's the catch... The billing_code table is on the many side of a one to many relationship with another table, billing_code_set_version. This means that there are multiple records in billing_code with the same billing_code and description. So far I haven't figured out how to get my query with just one record for every chg_codes_code, billing_code and billing_code.description. The closest I've gotten is this: select distinct chg_codes_code, billing_code, description from billing_code_charge_code right join billing_code on billing_code.sys_id = billing_code_charge_code.billing_code_sys_id where left(chg_codes_code, 1) in ('D', 'F', 'E') order by chg_codes_code In many cases this returns duplicate chg_codes_code values. The main difference I see in the records is that for one the description is in all upper case and the description for the other record uses normal case. Any suggestions? I've been trying all sorts of combinations but so far no luck. Thanks in advance, Linn Tag: OT: Help Desk software recomendation Tag: 222156
  - 3
    - Blues on protecting executables After seeing Refox protection is breakable with the new tools, I'm looking a new way to protect an application in VFP7 SP1 Using Molebox my exe file don't work. I don't know what I'm doing wrong. Had someone used this tool.? I'm aware on Derefox, I think this is the name, although I think is a good tool, I consider a problem to have to include more resource files (VFP6). Thanks. Alejandro Fernandez Tag: OT: Help Desk software recomendation Tag: 222155
  - 4
    - Report Writer VFP 9 BUG Hi, I have a table with 200 records, contains 7 fields, one of them is a memo field. I designed a very simple report with 5 fields on one line in the details band & on the 2nd line in the detail band I putted the memo field with width of the page A4. In the print when of the memo field, I inserted a variable & if this variable is TRUE then the memo field will appear in the report else it won't. When launching the report with the variable set to FALSE, a list of the 200 records appear. When the variable is set to TRUE, the report show a blank page with a number of pages in the TITLE BAR of the report starting from 28500 pages & counting quickly, I waited about 30 seconds & the number is counting with more than 3 millions pages & the VFP is hanging so I closed it from the task manager. I retry the same action, & I obtained the same result. Any Help Tag: OT: Help Desk software recomendation Tag: 222148
  - 5
    - How to write click event Hi all, In my program, when my program is running, enduser can press a button to create another "command button". And now I have a problem of create a "command button" with coding in that "Click event method" at the same time in the above situation. -- Thanks ! Tag: OT: Help Desk software recomendation Tag: 222142
  - 6
    - How can I know the class calling the procedure Dear All How can I know the class calling the procedure ? For Example Define class parent_class as session Procedure some_method set proc to procedure_file do call_me() Return Endefine Procedure file.prg : Procedure call_me how do I know the "parent_class" calling me ? <---- Anyone enligthen me ? Return Tag: OT: Help Desk software recomendation Tag: 222140
  - 7
    - Running a distributed .exe from an installation on a network serve I have a client that is having trouble running my program from an installation on a server from a workstation. I know that it is being used that way on some other sites so I am thinking it is a rights issue. Are there any limitations, such as printing reports from the server, that a client accessing it from a short-cut is going to experience? Cory Bonallo Retail Services Developer Tag: OT: Help Desk software recomendation Tag: 222136
  - 8
    - Determining SMTP server I want to provide the application option to send email from Fox via SMTP instead of MAPI method. Does anyone know how to retreive the default SMTP server name from Fox or Windows API? ----------------------------------------------------------------- Paul Lee ........ Abri Technologies ........ http://www.abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: OT: Help Desk software recomendation Tag: 222134
  - 9
    - download foxpro 2.6 distrubtion kit here here you can dl Foxpro 2.6 dist... kit tanks alot for all visitors email me for any unfounded link to mbksoft@gmail.com http://vetusware.com/output/id73-FPXPRODK.260.rar Tag: OT: Help Desk software recomendation Tag: 222131
  - 10
    - Debugging Fox COM object in IIS Hi all! My website uses a FoxPro COM object to perform some database operations. The Fox DLL is single-threaded. At times, the function calls within my website to the Fox COM object will stop responding and the website will hang. The last time this happened, I attached Microsoft's WinDBG to the website process to debug it. What I observed was what appeared to be an infinite loop of first chance access violations. The violation occurrs in "vfp8r.dll" and with symbols, one can see the function in which the crash occurs is "KBCopy2". Apparently some error handler is catching this violation because it never becomes second chance but the function is getting repeatedly called (infinitely it seems) and therefore locking up my COM object. Does anyone have any ideas about how I debug this further and find out exactly what is going on? Thank you! Matthew Tag: OT: Help Desk software recomendation Tag: 222126
  - 11
    - problem dragging file to explorer I posted in a xp newsgroup, but did not get an answer. I have a Visual Foxpro Application that reads a text file and stores the data in a table. The text file is created using a PDT (Portable Data Terminal). I use the software that came with the PDT to drag the text file from a PDT window (from within the PDT software) to a folder called c:\mobile. It works great on my test computers (both are Windows XP Home Edition....arghhh don't ask why!). Anyway on my client computer, which is a Windows XP Professional, I cannot drag the file. I can only drag it to the Recylce Bin. I think I have checked properly any rights for the c:\mobile folder and they are set to "read, write, etc....all rights are check". However, windows will not allow me to drag the file. What setting am I missing? I opened and saved a wordpad document in the C:\mobile folder so I do have rights. Thanks, John. Tag: OT: Help Desk software recomendation Tag: 222123
  - 12
    - Persistent VFP COM Server with GUI Hi, I'm trying to start a VFP application through automation. So I created OLEPUBLIC class. This class displays application's main form in Init code. Application is compiled as out-of-process EXE. In VB code I create instance of my COM Server: set oApp = createobject("Myapp.App") oApp.DoSomething() The main form appears and the application is working. But when VB code finishes and oApp variable is cleared, my VFP application is also closed! Q: How to preserve vfp automation server in case of releasing referencing variable in client code? Look at MS Excel. If I run following code written in VB: set oEx = createobject("Excel.Application") oEx.Workbooks.Add oEx.Visible = true After releasing oEx variable from memory, Excel is still visible and working! How do that in VFP? Thanks in advance, Janusz Czudek WORD Software www.wordsoft.com.pl Tag: OT: Help Desk software recomendation Tag: 222122
  - 13
    - Lost settings in IDE When I open VFP, all settings are lost. Whatever I do it in VFP now, everything will be disappeared after I reopen VFP. Any ideas? TIA. Tag: OT: Help Desk software recomendation Tag: 222113
  - 14
    - Null values in a textbox Hi, I made a screen with more than 40 textbox, I have only 3 fields which accept Null values. When the user type by mistake ctrl+zero on a field other the 3 fields, an error occurs & the application is closed. I tried to write code in the ERROR handling program such as: do case case error_num = 1581 Messagebox(dvgdfg) return 0 but still the application is closed. any help, Thank you Tag: OT: Help Desk software recomendation Tag: 222110
  - 15
    - SET TALK command (VFP6) The VFP command window can be used as a calculator. If I issue: CLEAR SET TALK ON USE sometable SET FILTER TO somefilter SUM FOR somecondition the system will show a count of the records it processed, and the sum of the numeric fields in the table. The results will be shown on the SCREEN, and the display will persist (and I can print it with PrtSc). It may look like this: 99999 records summed valuation 123456789.00 If, however, SET STATUS BAR ON, the sum will be displayed on the screen, but the count will be displayed in the graphical status bar. Moreover, the count will be displayed only for about 3 seconds, and then the status bar will be refreshed, wiping out the count. I find that the only reliable way to get the display I want is to SET STATUS BAR OFF SET TALK ON thus foregoing the benefit of the status bar.Also, I don't find the clauses like "SET TALK WINDOW somewindow" to work very well. Any comments? Tag: OT: Help Desk software recomendation Tag: 222108
  - 16
    - Modal browse windows I am attempting to open 3 browse windows from a VFP9 form. The intent is to be able to move the browse windows around so they can be arranged on the desktop. My problem is that they all open correctly but I only have access to the last one. They are acting like they are modal. The only way I can access other windows is to close the top one. Are we dealing with a foundation read issue here?? Is there any way to make this work. the command is browse noedit window <window name> nowait Tag: OT: Help Desk software recomendation Tag: 222103
  - 17
    - Deleted box does not show?? I'm using VFP 8.0 and have a view in my database. When I use and browse the view, it does not show the deleted status of the underlying table. Why? I can set deleted on and the deleted records DO NOT show in the view. However, I want them to show, but have the black square in the grid. What is a workaround? Thanks, John. Tag: OT: Help Desk software recomendation Tag: 222099
  - 18
    - Regional settings and dot on numeric keyboard I have a text field with inputmask set to "9999999.99" which is used to store info about money. Everything is OK when user have keyboard set to English, but when keyboard is set to PL (polish programmers) button '.' on numeric keyboard become comma. If user with PL keyboard press '.' key on numeric keyboard like he wants to write cents it does not move to cents digit.... How to override this behavior ? I was trying change it in Keypress event, but it doesn't work: LPARAMETERS nKeyCode, nShiftAltCtrl IF nkeycode=44 && IF polish keyboard change ',' to '.' nKeyCode=46 RETURN 46 ELSE ENDIF Thanks, Adam Tag: OT: Help Desk software recomendation Tag: 222097
  - 19
    - SQL Help please!! i am trying the following with errors. Select Agency, Dept,; Sum EmpDate <= checkhdr.procdate, 1, 0 As currentmonTH,; Sum EmpDate => checkhdr.procdate, 1, 0 As nextMonth; From newmem; what is the best way to get this data in SQL? thank you Tag: OT: Help Desk software recomendation Tag: 222093
  - 20
    - How do I run this from a click even ? I run this from the RUN dialog box: C:\AVD\PERU\pptview.exe /L "playlist.txt" How would I get this to run from a command_buttons click event? Your Friend From Afar ~ Respectfully, Jonathan Morningstar ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: OT: Help Desk software recomendation Tag: 222082
  - 21
    - VFP 8.0 Remote View Bug with MySQL 5.0 production Hi Gang, I appreciate any you can give me on this one. I run VFP 8.0 SP1 and use remote views via the MySQL ODBC driver 3.511-11-2win to work with large MySQL Tables. I recently upgraded from MySQL 5.0a Beta to the MySQL 5.09 Production release version and I noticed two related but big problems: 1. Any remote view of a MySQL table which contains numeric or decimal fields will be automatically characterized as character fields when you attempt to build a remote view in VFP 8. It will get integers and datetime types right. (You can even see it in the DBSETPROP command if you view the SQL in the view builder). If you attempt to change the SQL manually in the view builder and run the query, Fox will tell you that you have a data type mismatch. Makes it a bit difficult with numbers. 2. If you attempt to just pull the data with the Fox SQLEXEC(handle,'select * from my_table,'sql_result'), the resulting Fox cursor will also convert numeric and decimals to the character datatype, even if you have used a CREATE CURSOR command to define the fields to match the MySQL table exactly, numbers and decimals come out as character fields. I re-installed the older version of MySQL 5.0a Beta and the problem went away. The problem seems to involve any table MySQL defines as a version "10." Legacy version "9" MySQL tables (don't modify them in MySQL or they become 10's) will continue to work normally. Has anyone else experienced this issue? Have you found a work-around or a version upgrade or fix that I am missing? Thanks a bunch! David L. Jacobson Tag: OT: Help Desk software recomendation Tag: 222079
  - 22
    - Date Time Picker auto dropdown Hi, I want my form to open with the calendar part of the MS Date and Time Picker control visible. I tried adding KEYBOARD '{ALT+DNARROW}' to several events (GotFocus, Refresh, UIEnable, etc.) but without any luck. Also, I'd prefer that the text box portion not be visible at all. Is there any way to do this? Is there another control I could use instead? Thanks, Frank Tag: OT: Help Desk software recomendation Tag: 222076
  - 23
    - Variable editing Is there a way in FoxPro to open a string variable in an editing window, like you can do with memo fields? I want to be able to assign a string to a variable then edit it using something like modify memo or modify command. I guess I could put it in a memo field, but it seems like you ought to be able to open a full-screen editing session with a string variable without having to copy it to a memo field. Any suggestions? Kevin Clark Seton Home Study School Tag: OT: Help Desk software recomendation Tag: 222075
  - 24
    - Child grid woes Hi, I have a parent grid and a child grid on a pageframe page. The child grid is set up with Linkmaster, RelationalExpr, ChildOrder, etc properties which work fine. The problem I have is that if I move to say the third record in the child grid, issuing a page refresh will reset the pointer to the first record. Is there any way to stop this happening, or a good way to send the pointer back to the correct record on a refresh (the child records have a unique id I could use). I'm using VFP9. Any help much appreciated. Neil Tag: OT: Help Desk software recomendation Tag: 222074
  - 25
    - Change scope? CHANGE is almost identical to BROWSE in what it can do. I just noticed however that CHANGE has a <scope> which is rather odd for a browse like command. Even more odd is how it works.. If I issue CHANGE NEXT 3 on a table with some records then I can actually change up to 3 records either "up" or "down" from my current position. As soon as I cross the 3rd record boundary the window closes. This is the case if I move "up, up" or "down, down" or even "down, up" etc. If I use the Record->Goto menu option then in fact I can go to any record I like any number of times and edit data provided I don't cross the record boundaries and the window will stay open. What is the meaning of <scope> in the context of CHANGE? Gene, is this good enough for your list of nasty questions? -- regards Andrew Howell Tag: OT: Help Desk software recomendation Tag: 222072

Have received much help here for my VFP app but now I need help keeping the
support end organized. Can anyone recommend a good help-desk ticketing
software program? Don't want to re-invent the wheel here. Looking for
something web-based, Google search returned too many results. I'd like to
know if anyone here can make a recommendation.

TYIA

- Ben

Top

Re: Help Desk software recomendation by Dan

Dan
Wed Mar 29 08:55:43 CST 2006

I use the free version of SysAid.

http://www.ilient.com/

"JWBlue" <nospam@nospam.com> wrote in message
news:y6xWf.37332$ty4.4199@tornado.rdc-kc.rr.com...
> Have received much help here for my VFP app but now I need help keeping
the
> support end organized. Can anyone recommend a good help-desk ticketing
> software program? Don't want to re-invent the wheel here. Looking for
> something web-based, Google search returned too many results. I'd like to
> know if anyone here can make a recommendation.
>
> TYIA
>
> - Ben
>
>

Top

RE: OT: Help Desk software recomendation by BrianHiatt

BrianHiatt
Wed Mar 29 13:40:03 CST 2006

This one is excellent. Very high functionality and I think free for limited
use.
http://manageengine.adventnet.com/products/support-center/index.html?ad-main

Brian Hiatt
Collectorpro Software Group
www.collectorpro.com

"JWBlue" wrote:

> Have received much help here for my VFP app but now I need help keeping the
> support end organized. Can anyone recommend a good help-desk ticketing
> software program? Don't want to re-invent the wheel here. Looking for
> something web-based, Google search returned too many results. I'd like to
> know if anyone here can make a recommendation.
>
> TYIA
>
> - Ben
>
>
>

Top