General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Automatic Transactions ????
Hello Everybody !
My VFP 8.0 application works with a MaxDB Database via ODBC.
In the extra options of the IDE i set automatic transactions off in the remote data view!!
(no autocommit!)
When reading spezial data into a cursor i do
l_select = "select ..... with lock optimistic"
=sqlexecute(connhandle,l_select,"mycursor")
the wanted behavior is, that there is an entry in the locks table of the MaxDB database
(user,session,tablename,keyvalue ...)
we use this entry to decide wether other users can use the same record(s) at the same time.
when starting the programm from the IDE everything works as aspected.
there is a record in the locks table until we do a "commit"
when starting the programm from an exe there is no entry in the locks table ??????
What is missing ???? Do we need a spezial set command in our main programm ?????
is there a confict with the "SET MULTILOCKS ON" command in our main programm ???
(we use this for spezial operations with local cursors)
Any help welcomed
Best regards
Albert
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only