Digital Workshop

Hello all,

Have the following code in my Opus 2.81 Pro publication:

var myDB = new Database("FILEDSN=C:\Program Files\Common Files\ODBC\Data Sources\crash.dsn;");
var Rset = myDB.ExecuteSQL("SELECT * FROM REGISTRATIONS)";

Gives me the following error:
Undefined identifier 'RSet'

Using the same DSN with the built-in query wizzard doesn't give me any errors and all data retrieved from the database is correct.
However, I do not want to use the wizzard as it is not as flexible as using code.

Removing the "var RSet" part and adding the following code
var errorMsg = myDB.GetLastError
Debug.trace(errorMsg);

Gives me the following message:
[Function built-in]
Don't know what this means!

Any help is highly appreciated...

Jan

Should be



Is there any other script following the var Rset line? Also make sure you have the case correct, because you have var Rset (lower case s) whereas your error says RSet is undeclared (upper case S).