LiveCode Forums.

Posted: **Fri Mar 07, 2014 8:47 am**

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

Posted: **Fri Mar 07, 2014 11:30 am**

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

Posted: **Fri Mar 07, 2014 2:20 pm**

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

Code: Select all

SELECT ROW_COUNT()

Posted: **Sat Mar 08, 2014 3:44 am**

-Splash21,Bangkok

Thank you for the reply..

)

Got it..

)

Regards

-snop21

LiveCode Forums.

how to get number of records in my query?

how to get number of records in my query?

Re: how to get number of records in my query?

Re: how to get number of records in my query?

Re: how to get number of records in my query?