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
how to get number of records in my query?
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
Re: how to get number of records in my query?
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
-
- VIP Livecode Opensource Backer
- Posts: 369
- Joined: Sun Dec 19, 2010 1:10 am
- Location: UK
- Contact:
Re: how to get number of records in my query?
You can also query the number of rows found in the last query;
Code: Select all
SELECT ROW_COUNT()
LiveCode Development & Training : http://splash21.com
Re: how to get number of records in my query?
-Splash21,Bangkok
Thank you for the reply.. )
Got it.. )
Regards
-snop21
Thank you for the reply.. )
Got it.. )
Regards
-snop21