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

[Ruslan Zasukhin]

On 10/24/04 7:49 PM, "SoftIl" <softil at onlinehome.de> wrote:

> Hi,
> I've got following problem:
> 
> If I do this in my application:
> uint _returnValue = myDataBase.SqlExecute("SELECT COUNT(ohrNummer) FROM
> tiere WHERE (ohrnummer = '0577105079') AND (ohrnummerCountry LIKE 'DE00'
> NO_CASE)")
> I get '0' as result.  That's wrong.

Wrong is to use SqlExecute() with SELECT

You need SqlSelect()


> If I run the same command in Valentina Studio (or in visql) I get as result
> '1'. That's right.
> 
> Where is my mistake?

-- 
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
-------------------------------------------------------------