Recent content by Gary Sutherland

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