Hi Markus:

I mean the Compiler running on top of the Data Layer for 64 bits (not VFP Runtime at all), already supports those commands.

We'll implement APPEND FROM, anyone knowing .NET tricks for speedy parsing is welcome to provide a .NET implementation written of course in VFP.

Below are some ideas for the implementation. Of course if we don't surpass VFP speed, we can always use the VFP9TableLayer functionality, compiling your code.

To translate the PDF you could use http://open-source.onestop.net/2005/07/pdftohtml.html or grab the commandline version in sourceforge.net and turn that to HTML. Then use Google translator. Convoluted?, yes, but I don't know about other options.

And now some ideas about the implementation:

The function prototype could be something like:

FUNCTION AppendFromDelimited
TPARAMETERS tcFile as string, toFor as System::Delegate, ;
 taListFields() as string, tcCharDelimiter as string, ;
tcFieldDelimiter as string, tnCodePage as Integer

toFor would be a delegate with this signature:

FUNCTION BooleanReturn as boolean

That is applied in every possible record to check if it is included or not. Don't worry if you don't know how to do that it is very simple so you can let that to us ;-). We already did it for implementing SCAN, LOCATE AND every other command having a FOR clause, except the FOR .. ENDFOR that is another different thing, ;-)





>Hi Samuel,
>
>> the compiler supports most of the required commands the two big missing are APPEND FROM (only APPEND BLANK) and SELECT SQL.
>
>even if the compiler will support these commands in time, what about the data layer?
>
>As the contest will be run on Windows XP I tend to use the vfp9t.dll data layer rather than your new data layer. I may be wrong, but even if you already implemented these commands in the data layer it will take some time to get them as speedy as VFP's implementation, right?
>
>
>>Where can I read more about the contest and specially where can I get the data or sample data. I did a quick check and did not find anything, a link would be appreciated.
>
>As I understand one has to be a subscriber of the magazine to join the contest. I uploaded the data generator and the contest description to one of my sites for you:
>
> http://indot.net/dotnetprocontest07/datagenerator.zip
> http://indot.net/dotnetprocontest07/dotnetprocontest.pdf
>
>Unfortunately everything is in german but the diagram in the PDF should tell the required steps nevertheless. Feel free to ask me for details.
>
>BTW, does someone here know a way to translate the whole PDF document to english?
>
>Markus