SELECT count(*) as

[Ruslan Zasukhin]

On 11/22/11 8:19 PM, "Inselfan" <baleareninsel at gmx.net> wrote:

> Hola,
> 
> using this:
> 
> put revQueryDatabase (DB_ID, "SELECT count(*) as anzahl from MYFILE where
> something = '"&yxz&"' and something_else = 'false'") into counted
> 
> shows me wrong results in counted. Does one of you will be so kind to tell
> me my fold?

You expect to see count(0) into variable  counted ?

But in fact you get here result of revQueryDatabase () function -> cursor ?
I think you need now ask field(1) of that cursor



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]