Crash: memo data in Visual FoxPro ?

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

mwieder
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 3581
Joined: Mon Jan 22, 2007 7:36 am
Contact:

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
Posts: 62
Joined: Thu Jul 17, 2008 11:48 pm

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
Posts: 62
Joined: Thu Jul 17, 2008 11:48 pm

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.

Post Reply