Well, as I said I made some costmetic changes of the code during posting. Sorry, shouldn't have done this. To be more precise I exchanged the hard coded values 2005 and 1 with the vars. If you fix the code it does updates.

And all in all it's slower than the sql, although I was lucky (or unlucky), that the xbase code ran faster in the two test calls I only did.

The time needed by either sql or xBase varies very much. Taking 2 to 14 seconds with sql and 3 to 50 seconds with xBase on a 1Ghz PIII notebook with 128 MB ram and 40GB HDD. In My first testruns I got some of the best xCase running times and about 2-3 times slower SQL running times.

Now, as I did some more test runs I'd also concratulate to SQL. Maybe the xCase variant can be optimized a little further if I analyize it with COVERAGE. Just for the fun of it...

Bye, Olaf.