[VNET] Question about the dataBase.SqlExecute() Method

Ruslan Zasukhin sunshine at public.kherson.ua
Mon Oct 25 00:43:26 CDT 2004


On 10/25/04 12:24 AM, "SoftIl" <softil at onlinehome.de> wrote:

Hi Carsten,

>>> uint _returnValue = myDataBase.SqlExecute("SELECT COUNT(ohrNummer) FROM
>>> tiere WHERE (ohrnummer = '0577105079') AND (ohrnummerCountry LIKE 'DE00'
>>> NO_CASE)")
>> Wrong is to use SqlExecute() with SELECT
>> You need SqlSelect()
> But SqlSelect returns an cursor object.
> What I need is only the number of records for them the condition is true.

You MUST use it.

And later 

    count = curs.Field(1).value


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------



More information about the Valentina mailing list