Are you sure the hang-up was the first SQLEXEC call, or the RECCOUNT call? Did you see a 0 return on the end of ?"First Call:" then the record count after a bit? Or you get a 1 after it?
Tracy -----Original Message----- From: MB Software Solutions General Account Sent: Monday, December 01, 2008 11:02 AM On Mon, December 1, 2008 10:21 am, Tracy Pearson wrote: >> From the VFP 9 help file: "Speeding up Data Retrieval" >> > > Controlling Cursor Fetching > If you want to fetch the entire cursor, you can issue the GOTO BOTTOM > command, or any command requiring access to the entire data set. > > I read this as RECCOUNT() being one of the other commands as it would > require access to the entire data set. > > Try this: > > > nHandle = SQLSTRINGCONNECT(lcCStr) ?"Set Asycn Mode" > ??SQLSETPROP(nHandle,"Asynchronous",.T.) > lcSQL = "SELECT * FROM email ORDER BY sent" ?lcSQL ?"First Call:" > ??SQLEXEC(nHandle,lcSQL,"csrTest") + " " > DO WHILE SQLEXEC(nHandle) = 0 > ??"." > =INKEY(.25) > ENDDO So by choosing this approach it won't hang on the first SQLEXEC call? _______________________________________________ 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.
