To all,

I've got an app that's using ODBC calls via SqlExec() against a Sql Server 7 database. I'm having problems with the return cursors in that they are doing record level locks, even though the cursor is local to the workstation. This is really screwing up my app because I've got some user input on some of the cursors, but the input is not being "registered" by the cursor unless the record pointer is moved.

I've tried DBSetProp() against it, but I get an error saying something about "db_buftorow" in views.

Looking at the documentation (shows you how despirate I am) I see it says the default value for the locking is "1"... no locks. When I run DbGetProp() against the cursor, I see the cursor is set to lock level 3... optimistic record lock... and I can't change it.

I've tried SELECT * FROM INTO CURSOR and it STILL doesn't work.

Any help?

TIA,

Thom C.