curDetail is buffered and those records may be freshly added? I would try Buffering clause to SELECT command:
Select *, 00000000.00 As nScopeTotal ; >From curDetail ; With (Buffering = .T.) ; into curosr curDetail2 ReadWrite Does this changes anything? ----- Original Message ----- From: "MB Software Solutions" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 14, 2007 5:41 AM Subject: Re: VFP9 problem with regular SELECT SQL > MB Software Solutions wrote: >> Check this out: >> http://mbsoftwaresolutions.com/images/enigma111307.png >> >> The reccount of curDetail (cursor created in code via CREATE CURSOR >> command) is 3, and yet when I do a SELECT SQL into curDetail2---with >> *no* WHERE clause or any conditional SQL---the reccount of curDetail2 in >> ZERO. >> >> wtf? Paging Dr. House of the VFP ward....what the heck is the diagnosis >> for this enigma? >> >> > btw, those 3 records in curDetail are NOT deleted. > > vfp9sp1 > > tia! > --Michael > > > -- > Michael J. Babcock, MCP > MB Software Solutions, LLC > http://mbsoftwaresolutions.com > http://fabmate.com > "Work smarter, not harder, with MBSS custom software solutions!" > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
