Answer Questions

• HumbleServant How to check if an Array exists?

  Select * from myTable where isnull(myTable.keyField) = .f. into array myArray if alen(myArray) > 0 ** Loop through array and Do processing end if In a situation where records selected by the query are 0 then the array is not created and thus the next statement gives an error. How can I check if myArray exists before doing any further processing Thanks for the indepth explanation CetinBasoz. I see your po ...Show All

• colin please Screen fields don't seem to be working...

  As a quick question, If I have a screen that is part of a visual class (*.vcx) file and a program (*.prg) associated with it. Besides recompiling the program file and saving the visual class file, is there anything else that needs to be updated in the visual class file as well or something What is happening is for example, I have a checkbox in one of the screens, and a program that toggles it off if it is on at some point, but the applicat ...Show All

• Madhu Nair My form runs great inside of VFP, but has errors running from the exe...

  I have a form that uses a combo box for the user to select from. Their selection then is used as a basis for searching a table via a SELECT statement. The results of the SELECT statement are then written to a different table, where they are available for export as an xls file. It is searching an automotive customer info list by car make... This works flawlessly within VFP, but from the compiled exe I get complaints that Object 'wholesale_form ...Show All

• jack the ripper which is safer to use table or view?

  Opening a native table is very vulnirable to sudden power failure. So which is safer of the two; Using directly the table or make a view of that certain table before using it A view would theoreticlly be safer as it is a SQL query to the data. But why are you having this problem In 20 years of working with DBFs I only had this happen to me once, many years ago. There is only one reason not to have an Uninterrupible Power S ...Show All

• Shay Van Creveld Reports VFP 90 Output to Excel

  Hi: VFP 90 is able to generate output to XML format. Great !! Excel is able to import file from XML format. Great !! So, we are trying to combine both tools. The problem is that VFP XML file contain the FRX table. The results in XLS format aren't the expected. But, in Data section of XML are stored our values with captions and so on. How could we obtain Excel table from XML file generate by VFP 90 Is it possible Thank you. -- Regards, Ana Madr ...Show All

• Kato12651 REPORT error-invalid path

  i have a button in a form and when its pressed it creates some select sqls which have into table and overwrite an existing table.then from the table i create report..from.. ,then i update the report and finnally i report form.the problem is that if i press the button->see the report->close the report->press again button->i get a message "invalid path or file name" if i close the program and reopen its the same press the button->se ...Show All

• Krey 12 hour time format

  Hello, I am doing a program that will compute the time in and time out.  As much as possible I want to do the time() function and not the datetime() function but the problem is if I use time() it displays the 24 hour format.  What I am tasked to do is to subtruct the time out to time in and be able to display the 12 hour format. Any advice will be greatly appreciated. But if you're storing both the date and the time, why no ...Show All

• shasunder crystal reports

  i know that crystal reports are compatible with vfp.how can i run a crystal report from inside  vfp #define WS_MAXIMIZE  29949952 oCrystal=CreateObject("Crystal.CRPE.Application") oRpt = oCrystal.OpenReport("c:\myReports\myReport.RPT") oRpt.preview("Report Preview Title",,,,,WS_MAXIMIZE,0) PS: Code is from VFP5-6 days. Since then I don't use Crsytal and things might have changed. ...Show All

• Bhupinder Report Toolbar

  Hello Experts A small problem. The main form of my application is set as 'Top Level form'. When I set the ReportBehaviour to 90, the preview toolbar appears but am not able to access it. Whereas the ReportBehaviour = 80 creates its own preview container hence no problem. Any suggestions. Thanks, Jitendra Shahani This is a known bug in the VFP ReportPreview.app.  The only workaround that I know of tha ...Show All

• A L MA Enhancement Request: Ability to pass cursors as parameters

  The ability to pass a cursor to a method of an object belonging to another data session would be a great addition for a future versions of VFP. Today, we have to resort to arrays, which is kind of a kludge, or CursorToXML/XMLToCursor, which is way too slow for large data sets. If cursor could be passed between data sessions, n-tier apps would benefit greatly. Any thoughts Eyvind.   Lisa Slater Nicholls ...Show All

• Bishwajit Aich reading html file in foxpro

  Hi I want to check an .html (or TXT if thats easier) file with foxpro for this line: src="cid:image001.jpg@01C67F47.26775C40" and replace it with src="image001.jpg" how can I do this, I can't figure it out :( Something like this: local lcText lcText = FILETOSTR("c:\temp\MyFile.HTM") lcText = STRTRAN(lcText,[src="cid:image001.jpg@01C67F47.26775C40"], ...Show All

• Jeff Reed - MSFT designing query in foxpro

  After creating a query using vfp6.0 and when i re-open the query the database is unable to locate the tables. 'errors: tablename.dbf does not exist'. The query is not executed. The design is as follows: I have 5 tables which are located in different folders, i.e, table A,B,C - folder1 and table C,D - folder2 I have created a database in another folder, say c:/database, and i have added a local view. The view has to join all the tables d ...Show All

• Steve Simpson =SYS(1037) on VFP90 no longer allows printer changes

  Can anyone tell me how to work around the changes in SYS(1037)   I used to call this with =SYS(1037) before printing in a batch (checks and invoices) and it no longer allows my customers to change the printer in VFP90 (no 'apply' button).  The 'prompt' option in REPORT FORM works just perfect too, but I don't want to call it in a loop (too repetative.)  Any ideas Thanks I had planned on looking into this more over the weeke ...Show All

• Corina H my SQL passthrough problem

  Good day to all, could i ask where i got wrong with this code , because when i run the .prg for this code, at first try it won't work, then the second time around it works, as if no error. Like when you open VFP, then at the command window you execute the do command, it won't work, but at the second or 3rd try it works. Please help...thanks in advance LOCAL lcConnect STORE 0 TO lcConnect STORE SQLCONNECT ('My SQL Server C ...Show All

• Dominic Riccetti MSComctlLib.TreeCtrl.2 BackColor ???

  MSComctlLib.TreeCtrl.2 does not have BackColor property. Is it possible to define one (it is of course possible) and actually make it functionable Thanks. Unless you're the only one who'll be using your applications, you shouldn't introduce any colors that the user hasn't chosen in the Windows Display Properties dialog. Doing so raises several problems: 1) The colors you add may be incompatible with the user's Windows colors, re ...Show All