C/Front and SQL transactions...

kine

Hello,

we have problem with C/Front reading uncommited (i think that it is "dirty read") data from MS SQL. Can I set C/Front to some issolationlevel to read only data that is already commited?
:?:

Thanks...

dmccrae

There is no way to set the transaction type explicitly.

All you can do is use DBL_LockTable() on the table prior to reading records. This has the effect in SQL of changing to the SERIALIZABLE transaction isolation level, and placing UPDLOCKs (update locks) on all rows read. This is probably more than you need for just reading alone, but you will not get dirty reads anymore until you commit/rollback. Note: it does not place a table lock on the table as in Navision Server (unless SQL Server later escalates many row locks to a table lock)!