C/Front and SQL transactions...

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)!