Answer Questions

• Radha Mukkai VFP 9.0 SQL worthless under a non client server network?

  Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred rec ...Show All

• SimonDa Fatal Error when writing to excel

  Hi, The version of Foxpro is 6.0.  The application I am buliding is to write data into Excel 2003.  There are times when I am getting a Fatal Error at a stage when I am writing the data into the cells.  Prior to this step I have other processes where I add more sheets and rename them, setup the borders and page setup and all works fine. I try to debug the application and it runs fine.  The problem is that the message is ...Show All

• johntas44 Report Window

  I have designed a form which includes a preview button, when I click the preview button, the report preview is working, but it was showed behind of the form, how would I do to show the report window front of the form can anyone help Thanks a lot. Yes, the right suggestion for my question, because i have set the form is always on top. now I have solved the problem already, Thanks lot. What is the setting of the form's Alw ...Show All

• Warren Blackwell Disappearing Records

  Hello, I have a weird problem that I need some help on.  The this past Tuesday night my server crashed prior to the backup schedule.  I have a data file, running under Codemine, that wound up with 8 corrupted records at the tail end of the table.  To restore the file, I deleted these eight records and packed the table.  When I browsed the table, I found that all of the records that were added to the table on Tuesday (abo ...Show All

• ebc forms

  hi everyone i have a small problem with forms. i have made a form with some controls and stuff on it. i have also added the resizable class library to it so the form and the controls can be resized. until now everything works perfectly. but the problem comes when i make an executable .exe file of my project which runs the form. now when you run the .exe file foxpro creates another foxpro system window outside of the main form and now if i try t ...Show All

• Galin Iliev Cancel Button Does not work--A known bug?

  I have no idea if it is a known bug. The important fact for me is that it is a bug. It occurs in _VFP.StartMode = 4 as well as in interactive session (_VFP.StartMode = 0). It caused me to lose numerous error records before I realized what was going on. In exe environment when one error follows another there is no way to quit because the Cancel button does not do what it is supposed to be doing. You crush the system and no records are saved of ...Show All

• Morgan Cheng table manipulation

  Two tables exist, call them tableA and tableB. They share some data. which was easy to get select a.work_id, a.sp_id, b.work_id, b.sp_id; from tableA a inner join table b on (a.work_id = b.work_id); order by work_id; into cursor hold1 there is still a matter of getting all the data from tableA and tableB that they don't share. i tried doing a left outer join, but i still get duplicates. Any ideas MP dave, you all over these threads....ur ...Show All

• Corbon91 Trouble with update MS SQL table with an untypical column name.

  I have problem with updating views of SQL server. When I have name of column for e.x. "Name_en-us" VFP translated this to "Named_en_us".  Unfortunately when I try updating,  ODBC returns me an error. Do you have any idea how to tackle this problem You can use angled brackets on untypical column names (and/or column names which are a keyword, contaning a space etc). ie: DBSetProp('myView.name_en_us', ...Show All

• Roman G. Append data from same table

  Dear Experts Table1 has two character type fields as name c(40) country c(40). Data in fields is as follows Mike England Eric France Robert Germany (3 records) I want to append second field's data into first field, new row, as Mike England Eric France Robert Germany (6 records) I want to get above result Please help If the order is relevant, you can use the following program. Afterwards you have to pack the table: ...Show All

• Wokoek How to access VFP popup errors?

  Hi all I am writing an external application which can detect Foxpro errors. The problem I am having is the native VFP error popup. I can not access the message text in that popup. Windows API can only return the handle and the title of the main popup window. It does not detect any children of that window. Sample: Is there a way that I can access to the "Variable 'A' is not found." text message from an external app This screen shot is a sample: ...Show All

• LDesmons VFP 9.0 ReportListener creates a PDF page as an image

  Hello, I'm using VFP 9.0 ReportListener object. When I print a report using Acrobat Distiller printer driver, it creates the PDF pages as images. I want the output as it was with the previous versions, text as a text and image as an image. Is there any way to do it Thank you in advance Hi Cetin, Thanks for the links, We purchased a third party software called QuickFRX2PDF with the source code. It works&nb ...Show All

• Çetin Yaşar SELECT wrkArea statement

  Please consider this piece of code. It is a bit weird as far as DO loop goes but it is the way I frequently do things. The problem I run into is the  SELECT statement. USE HistData!myTable IN 0 wrkArea = 0 DO WHILE ! EMPTY (wrkArea+1)   wrkArea = wrkArea + 1   wrkArea   cTableAlias = ALIAS (wrkArea)      IF cTableAlias = "MYTABLE"     SELECT wrkArea    & ...Show All

• AliSyed Report Designer Help Needed

  I have created a statement with 2 bands 1)Acctno, 2)Orderno,  Within the page footer band I have created a portion that the user is to cut and submit back, however, due to overflow of information to a 2nd page I end up the next customers data appearing within the "submit with payment" area. I have tried to include this "submit with payment" portion within the Acctno Band, however it does not stay at the bottom of the 2nd page (it floats). A ...Show All

• dydoria 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. Do you know how this compares ...Show All

• WhiteClaw48 unresolved issue on DTPicker Control

  I am sorry for doing this but for some reason I could not post any more in that thread. Maybe it has become too long. Although I feel that the discussion should be winding down but I want to thank Craig for his post and I want to say that I will definitely try the code. This is for Marcia: " I am sure that we have provided much entertainment for the onlookers " It is very good, I like it and I can subsribe to this statement . ...Show All