Page 2 of 2
Posted: Tue Jul 28, 2009 5:10 pm
by mwieder
...and I have to say that I looked at rev's ODBC driver again and it has indeed been rewritten to allow the specification of a cursor type, so it is now possible to move forwards and backwards through records. I don't know if this will help your situation or not - there apparently is a problem with trying to use a File DSN (only system DSNs seem to work), but it should solve the MoveToPreviousRecord issue.
Posted: Wed Jul 29, 2009 12:00 am
by bonbon
Thanks specialsof and mwieder - I had almost forgotten about this post ! I'll have a look when time permits, and I'll post the outcome(s) for anyone who is interested.
Posted: Fri Jul 31, 2009 1:23 pm
by bonbon
Prompted by mwieder, and using an Access database via ODBC, I put "static" into the databaseSpecificOption parameter of the revOpenDatabase command, and now moveToPreviousRecord works ! Many thanks. For anyone interested, the "open" command looks like this:
Code: Select all
put revOpenDatabase("odbc","NamesAccess",,,,"static",,) into tConID
if tConID is "" then
answer warning "Problem accessing database"
end if
and "move to prev record" looks like this:
(where curID comes from a revQueryDatabase SQL query) - easy ! Many thanks.