Crash: memo data in Visual FoxPro ?

mwieder · Post by **mwieder** » Tue Jul 28, 2009 5:10 pm

...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.

bonbon · Post by **bonbon** » Wed Jul 29, 2009 12:00 am

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.

bonbon · Post by **bonbon** » Fri Jul 31, 2009 1:23 pm

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:

Code: Select all

revMoveToPreviousRecord curID

(where curID comes from a revQueryDatabase SQL query) - easy ! Many thanks.