Bob,

Have you reinstalled the latest version of MDAC? I had a problem with Crystal Reports and doing this resolved it.

Thanks for all of the effort to explain and defend your discovery. Everyone at EQ2 appreciates you saving us from having to learn 'the hard way'.

Regards,




>Pickup up the programs at:
>ftp:\\www.interactivedatasystems.com\rebug.zip.
>
>Two programs here, Northwind.prg to generate a test DBC and rebug.prg to that contains the code necessary to show that REQUERY() has issues and/or VFP8 is unstable. You will need access to SQL 2000 and the classes from the FFC directory under HOME().
>
>Rebug.prg
>*-- Demonstration of a Major REQUERY() bug in VFP v8.
>*--
>*-- The following class libraries are from the
>*-- VFP8 FFC directory. Notice that if you move
>*-- the object creation up, say below _BASE, the problem
>*-- may or may not go away. You may also need to add
>*-- more class libraries to reproduce. On our development
>*-- machines, this is all it takes. Go ahead, try it and then
>*-- move the object creation up a few classes. As you approach the
>*-- the top, the problem goes away voila!
>*-- Demonstration of a Major REQUERY() bug in VFP v8.
>*--
>*-- The following class libraries are from the
>*-- VFP8 FFC directory. Notice that if you move
>*-- the object creation up, say below _BASE, the problem
>*-- may or may not go away. You may also need to add
>*-- more class libraries to reproduce. On our development
>*-- machines, this is all it takes.
>
>Northwind.prg
>*-- Generate the required views.
>
>Enjoy!