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..
![Sad :(](./images/smilies/icon_sad.gif)
Thank you
Regards
-snop21
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
Code: Select all
put "Select count(*) from CBMS_Setting" into tSQL
put revDataFromQuery(,,conn,tSQL) into tNumber
answer tNumber
Code: Select all
put "Select * from CBMS_Setting" into tSQL
put revDataFromQuery(,,conn,tSQL) into tData
answer the number of lines of tData
Code: Select all
SELECT ROW_COUNT()