Dob,

Sounds like you tried everything but here are just a couple of thoughts :

Does the outcome change if you get rid of Memo or Binary fields. I guess the question is does it have a type dependency? What is the data you are returning?

How are you connecting to the data source? Sounds like ODBC but have you tried another?

We have just completed our rewrite (in VFP 7.0-Crystal Reports - SQL Server 2000) of our hosptial product. I will talk this over at our development meeting today and see if the dev staff has any ideas.

Best of luck...



























>Hi James,
>
>We did try the latest MDAC from Microsoft without any difference. I will note that if you run the SQL profiler, the REQUERY() select is properly formed, sent, retrieved and returned to VFP8. It appears that perhaps execution continues and the results are discarded when the problem occurs.
>
>Thanks for your response and believe me, we definitely learned the 'hard way'. Never, NEVER AGAIN will we will deploy a .0 release. I have never released a .0 version before, not even with other products such as Office, NT, 2000, 2003. However, in this case, some of the features were so compelling and based on the statements from MS that it was the most stable version ever, I just assumed that this was v7 SP2. My bad, my fault, and I take responsibility. Now I just have to figure out how to move the VFP8 codebase back to v6 without losing all of the hard work of our developers during the past 45 days. We made a lot of changes, mostly to the interface, etc., but still, you hate to lose all that hard work. In addition, we are at a major reflection point with the business, as we are working with another company to integrate our health care app. This opportunity could help our company grow tremendously and give us a captive customer based to increase sales of our products.
>
>Cheers,
>Bob
>
>>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!