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 |
