how to get number of records in my query?

[snop21]

Hello livecoders,

Just wanna ask how to know how to get number of records in my query?

put "Select * from CBMS_Setting" into tSQL
revNumberOfRecords conn, tSQL

I tried my script above but it's wrong..

Thank you

Regards

-snop21

[bangkok]

Code: Select all

  put "Select count(*) from CBMS_Setting" into tSQL
      put revDataFromQuery(,,conn,tSQL) into tNumber
answer tNumber

or

Code: Select all

    put "Select * from CBMS_Setting" into tSQL
      put revDataFromQuery(,,conn,tSQL) into tData
answer the number of lines of tData

[splash21]

You can also query the number of rows found in the last query;

Code: Select all

SELECT ROW_COUNT()

[snop21]

-Splash21,Bangkok


Thank you for the reply.. )

Got it.. )

Regards

-snop21