main logo
Subject: Re: VXCMD thingies...
Author: Ruslan Zasukhin
Posted: 2001/01/31 05:52:09
 
View Entire Thread
New Search


on 31/1/01 04:39, sylvain at macbrowse .DO.T com at sylvain@macbrowse.com wrote:

> Hi Ruslan,
>
> Is it true that...
>
> SELECT * FROM MyBO WHERE RecID = 0
>
> ...is better than...
>
> SELECT * FROM MyBO
> Cursor_SetBlank
>
> ...if I want to get an empty cursor ?
> I ask because it is not documented.

Your examples are VERY different!!!

----------------------
SELECT * FROM MyBO WHERE RecID = 0

will return you EMPTY cursor with no records but with fields.


--------------------
SELECT * FROM MyBO
Cursor_SetBlank

SQL return you cursor with ALL records of BaseObject (i.e. even million)
SetBlank will just CLEAR RAM BUFFER of cursor.


--
Best regards,
Ruslan Zasukhin

-------------------------
Paradigma.

e-mail: ruslan at paradigmasoft .DO.T com
web : http://www.paradigmasoft.com

To subscribe to the Valentina mail list
send a letter to valentina-on@lists.macserve.net



-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
 
©2001 Ruslan Zasukhin
<-- Prior Message New Search Next Message -->