>I feel embarrassed to ask, since I've been doing this way long enough to know the answer, but my mind has gone blank on me: When creating a remote view as in
>
>"CREATE SQL VIEW Potential_Underpayments_View1 REMOTE CONNECTION qcm_Connect1 SHARE ;
> AS SELECT ; " etc, etc.
>
>for example or when running a pass-thro query such as in:
>
>"lcSQLQry = 'SELECT h.short, pats.pat_type, pats.totchg AS pttotchg, ' + ;
>= SQLPREPARE(gnConnHandle, lcSQLQry, 'Some_Cursor')
>= SQLEXEC(gnConnHandle)" etc, etc.
>
>What is the DBSETPROP() or other related command that will apply only a "shared" lock on the target table in an MS SQL database and will prevent applying an "Exclusive" lock on that table? /psb

Are you sure you have your connection set for Automatic transactions?

BOb