Search results for query: *

I'm running version .5815 which claims to be SP2. Downloading and installing the referenced update didn't change this. G.

Yes although your options are limited by the versions of Excel supported. Lookup APPEND FROM in the manual. You may find it easier to save from Excel as CSV and import that.

I've written a system for this using the Royal Mail PAF files. If you're going to be storing the PAF data locally then you'll need to cater for around 15-20 lookup tables because there is so much data.

Have you tried sending Ctrl Z ?

Foxpro has always had problems with ambiguous dates. I use SET DATE BRITISH to force dd/mm/yyyy display format.

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.