Yes it hung on the first SQLEXEC call. Using your code had some interesting results which I will theorize about in a follow up post, since I have found more info over the weekend.
Your code acted as follows: First Call is printed.. Pause for (a long time) Then it prints 0 and goes through the loop and prints a bunch of .... until it finally finishes, this process goes fairly quick depending on the # of records returned. At 11:01 AM 12/01/2008, Tracy Pearson wrote: >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? > > > [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.
