Digital Workshop

Hello all,

I have a script (in Opus 2.81 Pro) with the following code:

var myDB = new Database("FILEDSN = C:\\Program Files\\Common Files\\ODBC\\Data Sources\\Crash.dsn;")
var RecSet = myDB.ExecuteSQL("SELECT * FROM Mission;")
var num_records = RecSet.GetNumberOfRecords()
Debug.trace(num_records)

When I run the script I get an error "Action (3, -1) : Function Not Found : Check spelling and capitalisation"

Can't figure out what seems to be the problem

Jan

Hello

Strangely enough this worked the first tun
through, then returned the same error on the second try.


Chris

Have also tested the code in Opus Pro 05 (demo version) and get the same error message, so it doesn't seem to be version related.

Jan

Try tracing RecSet, as it sounds like ExecuteSQL isn't returning a record set. Are there entries in that table?

Hello,

Have modified the code a little so to avoid any mistakes... and added a Debug.trace(RecSet)

var myDB = new Database("FILEDSN = C:\crash.dsn;")
var RecSet = myDB.ExecuteSQL("SELECT * FROM CrashList;")
Debug.trace(RecSet)
var recCount = RecSet.GetNumberOfRecords()
Debug.trace(recCount)

The first time that I run the code the Debug.trace returns a "Database RecordSet Object" and 11 (as record count)... so this seems to be OK,
But, when I restart the same code I get a "false" and the error message...

Note: The first time that I run the code, Opus "asks" where the dsn is located, so I browse to the root directory of my harddisk where it is located. The second time I do not get the same "question"...

Jan

P.S. dsn looks as follows:

[ODBC]
DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
DriverId=25
DefaultDir=C:\
DBQ=C:\crash.mdb

Did it do that before?

You don't have the double backslash in the DSN line, i.e..

var myDB = new Database("FILEDSN = C:\\crash.dsn;")

which might be part of the problem this time.

Hello Dave,

1 or 2 backslashes gave the same result!!
The first time that I preview my publication, I have to select where the .dsn file is located and after selecting it, everything works OK!
However, when I preview again I don't need to select the file any more and I get an error.
When I close the publication and open it again, the results are the same as mentioned before... first time it works, then it gives an error.

To test the .dsn and the database I have also used the query wizard to select data and this works OK with no problems at all...

I also used the query wizard to get data and script code in the same publication...
Well, the data found by the query via the wizard is displayed OK everytime I preview the publication, but the data found by the code again gave an error the 2nd time...

The reason for using code instead of the wizard is simply that I want to be a little more flexible in setting up a query... e.g. the query (code) unfortunately can not be edited within the wizard.

Jan