Information générale
Titre:
Getting data from SQ: Svr without 'locking' the table
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement