Re: SELECT count(*) as

2011-11-23 Thread Inselfan
Hola Ruslan, hola Peter, thanks for that. I'll give it a try :) -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/SELECT-count-as-tp4096794p4098916.html Sent from the Revolution - User mailing list archive at Nabbl

Re: SELECT count(*) as

2011-11-22 Thread Pete
RevQueryDatabase returns a cursor not the result of the SELECT. If you use revDataFromQuery instead, you'll get the result of the SELECT, eg: put revDatafromQuery(,,DB_ID, "SELECT count(*) as anzahl from MYFILE where something = '"&yxz&"' and something_e

Re: SELECT count(*) as

2011-11-22 Thread Ruslan Zasukhin
On 11/22/11 8:19 PM, "Inselfan" wrote: > Hola, > > using this: > > put revQueryDatabase (DB_ID, "SELECT count(*) as anzahl from MYFILE where > something = '"&yxz&"' and something_else = 'false'") into counted > &g

SELECT count(*) as

2011-11-22 Thread Inselfan
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?