Skip to Content
avatar image
Former Member

No of Records

Hi

     How to get no of records in user table

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 29, 2014 at 11:54 AM

    Hi,

    SELECT COUNT(*) FROM UserTable

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 06:14 AM

    hi,

    select count(*) as total_records from yourtablename

    the above one u can execute in sql

    if u want to execute the same one in sdk coding..

    RecSet = ocompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

    qtry="select count(*) as total_records from yourtablename"

    RecSet.DoQuery(qry)

    dim tota_records as integer= recset.fileds.item(0).value

    the no of records will be saved in total_records.

    put the break point and then check it.

    Add comment
    10|10000 characters needed characters exceeded