I just set to a value I know does not ever exit. Problem solved.
8/29/02 12:07:41 PM, Gunnar Swan <GunnarSwan /AT/ PracticeToPass .DO.T com> wrote:
>Good Day,
>
>In the past, I have done the following to get a cursor with no records. When I only add records, I don't need to drag all records from
the
>database.
>
>tmpSQL = "SELECT * FROM tblStatistics WHERE 1=2"
>set TheCursor = new (Xtra "VCursor", parmDatabase.DBReference, tmpSQL)
>
>See the WHERE 1=2. One will never equal two, so this should open a cursor with no records.
>
>I've been able to do this on SQL Server and Oracle.
>
>In any case, how do I open a Cursor with no records, regardless of how many records are in the table ?
>
>Thanks.
>Gunnar
>
>
©2002 Gunnar Swan |
