Digital Workshop

This is a quite basic question but it involves script and databases so I'm posting it in here...

I'm just learning OpusScript and I'm new to this type of language and syntax (I trained on COBOL and have only had experience of SQL since).

In the following case:

var rset = mydb.ExecuteSQL("select * from products;");

how would I trap the false return (i.e. no records)? The example I found in the help files uses IF. But can I use IF with an assignment (as above?) or is there some two stage process I have to do?

Could someone please help with some syntax?


Thanks v. much

Melanie

Hi Melanie,

Thank you for your enquiry.

The easiest way to determine if no records were returned is to use the GetNumberOfRecords() function to count the number of records in the record set. For example:



If no records were returned, the debug pane will appear and display 'No Records Found!'.

Kind regards,

var rset = mydb.ExecuteSQL("select * from products;");
if (rset == false) {
Debug.trace("Error")
}

This will test for rset returning false but this only happens if there is an error. If there are no records you will get a record set object and will have to use the GetNumberOfRecords() function as Robin suggests.

Thanks both v. much.