on 8/29/02 22:07, Gunnar Swan at GunnarSwan (at) PracticeToPass D.O.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)
For Valentina use
WHERE RecID = 0
> 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 ?
--
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan@paradigmasoft.com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on (at) lists D.O.T macserve.net
-------------------------------------------------------------
©2002 Ruslan Zasukhin |
