Michael, If you add "readwrite" or "nofilter" to the SQL Statement which creates curDetail does the problem still exist?
Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 14 November 2007 03:42 To: [email protected] 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.
