Search results for query: *

I've found the screen scaling messes with the positioning when sizing forms, etc, when programming.

Do you have any program code in the form's Init event? G.

This sequence seems to do what you want. lcTest="FA007074000" ? lcTest && FA00707400 lcTest=IIF(LEFT(lcTest,2)="FA",SUBSTR(lcTest,3),lcTest) ? lcTest && 00707400 lcTest=LTRIM(lcTest,1,"0","") ? lcTest && 707400 G.

No problem, Colin. I'm constrained in part by the application I have to integrate this with. Regards Gary

Yes, the customer for whom I'm developing the software has purchased a license for the PAF file. There is also a set of sample files (much smaller) that are freely available to download. Any, thanks for all the replies and the interesting background. The software is finished and on-site...

Thanks Chris, much appreciated. Regards Gary

That would be neater, I agree, Chris. I'll take a look at doing it that way, Regards Gary

Ah, that probably explains it, then, Chris. The PAF.CSV file is roughly 2.5gb in size. Thanks. I guess I'm going to have to split the CSV file and import each file sequentially. Edit: I found a utility called Huge CSV Splitter that appears to have done the job. Regards Gary

Large CSV files is a topic that has cropped up before, I know, but I can't find a reference to this particular problem. I'm writing a tool import address data from the UK PAF.CSV postcodes/addresses file. This is a CSV file containing (at present) 31,827,747 individual UK postal addresses. I'm...

My usual practice is to execute the following commands at the point where I want to begin debugging. SET ASSERT ON ASSERT .F. Regards Gary

I don't know if this helps but I've needed to display image files on a number of occasions when developing software. I store the path and filename of the image in a table text field. When I want to view it I make this call: llRetVal=(WinShellExecute(lcFileName)>31) That executes the following...

Although SELECT SQL does respect the SET DELETE filter setting. Regards Gary

Also the default scope for DELETE SQL is ALL whereas you have to specify it for the FoxPro DELETE, and the table doesn't need to already be open when you issue the DELETE SQL command so long as you properly specify it in the FROM clause. Regards Gary

I prefer to use the Foxpro Delete command rather than the SQL variety. e.g. DELETE ALL FOR INLIST(UPPER(ALLTRIM(class)),'SUS','TB','CAD','EF','ND') AND UPPER(estado)=='NORMAL'

I know what you mean, Chris. Zmodem's great advantage of X/Ymoden was, of course, that a transfer could be resumed in the event that it failed part way though.

Many thanks, Okarl. I found it under the entry for 27 Aug 2006. Now stored safely away. My backup solution, the P2MMX machine also paid off and still works great! It's a bit tiresome transferring files with floppy discs, though. Regards Gary

Now this is a very long shot but I'm hoping someone might still have a copy of the Patch_26.exe utility for Foxpro 2.6 for Windows. This was a utility released by Microsoft to solve the problem of getting Division by Zero errors when running FPW26 on (what was for the time) a fast PC. All the...

If I understand the problem then the following rather rough program out to produce the desired result. You can play around with number of users and records, too. CLEAR lnUsers=3 lnRecords=10 lnAverage=INT(lnRecords/lnUsers) lnRemainder=lnRecords-(lnAverage*lnUsers) ? " User","...

I write a lot of routines for importing data from a variety of formats. You might want to start with something like this: LOCAL lcFileName CREATE CURSOR curImport (im_line N(5,0),im_fld2 C(10),im_fld2 C(10),im_fld3 C(40)) lcFileName=GETFILE() IF !EMPTY(lcFileName) SELECT curImport APPEND FROM...

Thanks Mike. I've begun implementing the changes to the existing program. This is so old that it still uses @SAY and @GET. I did suggest s re-write in VFP but the budget isn't there. Gary