Re: Constructed Select and Row Count

In article <duhonCAu35B.MFt@netcom.com> duhon@netcom.com (Joey Duhon) writes: } I'm doing a select with a "construct" (using a cursor) in 4GL. } I was hoping that after opening (or at least after the 1st fetch) } sqlerrd[3] would have the wor count. I can't seem to get this value } anyway i try. } Is there a trick to getting this value, or should i give up? } The sqlerrd[3] value will only hold the correct value for a SELECT after all the rows have been selected. Under SE, thats after you fetch the last row. Under ONLINE, that all depends on how many rows have been selected and the size of your buffers. DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.15 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com