the following appears in the release notes for Clarion 8 build 8740:
>> WORKAROUND: MSSQL 2008;R2 and earlier, could cause application lockups and potential data loss when you enabled the MARS feature of MSSQL, and did not wrap ADD statements in transaction frames, and you had post auto-increment statements and had one user browsing a table at the same time another user adds a record to that table. This workaround will only effect MSSQL files /MULTIPLEACTIVERESULTSETS=TRUE driver string and the "IsIdentity" user option on a field and the EMULATEAUTONUMKEY user option on the file.
I'm thinking those using MsSql may encounter this a fair bit, so an update is probably recommended. Also;
>> PTSS 38548: MSSQL Driver bug causes data loss
which further suggests an update is recommended.
cheers
Bruce
Topic: Clarion 8 SQL update (Read 11669 times)