Error 16943

Error 16943

Post by Coope » Thu, 11 Apr 2002 01:26:28



Hello

Here's a subject I couldn't find documentaion on :

An application sends request to an SQL Server (2000,
database compatibility 7), using ADO (server side cursor,
Openstatic)

The request sends is a quite simple select order. No
temporary table nor cursor is used.

But an 16943 Error is returned, telling the cursor
operation couldn't complete because of table schema
modification.

Any clues what is going on ?

TIA

Cooper

type of order sent :

select FI.PK_FIC, CH.CHQSEQ, FI.DATCMPPREV, FI.DATTRAIT,
FI.CAQIDE, FI.NOMFICHIER, CH.OFFSETRECTO, CH.LG_RECTO,
      CH.LG_VERSO,  IsNull(CH.BOITE,0) As BOITE, CH.CHQZ1,
CH.CHQZ2, CH.CHQZ3, CH.CHQZ4, CH.OFFSETVERSO, FI.TYPIMG,
      FI.TYPFIC,  CASE FI.PHASEARCH WHEN 0 THEN 1 ELSE 0
END ESTLOCAL,  CH.INDCIRC, CH.RIDE,
      IsNull(CH.REFARCH,'') As REFARCH, IsNull
(L.LOTAGENCE,'') As LOTAGENCE, FI.NUMFTT,
      IsNull(CH.IND_BAL,'') as IND_BAL
      from  CN_30002_A..CHEQUE CH (nolock)  
      inner join CN_30002_A..FICHIER FI (nolock)  on
(FI.PK_FIC=CH.FK_FIC)  
      inner join CN_30002_A..REMISE R (nolock)  on
(R.FK_FIC=CH.FICHIER_REM and R.REMSEQ=CH.REMSEQ)  
      left join CN_30002_A..LOT L (nolock)  on
(R.FICHIER_LOT=L.FK_FIC and R.LOTSEQ=L.LOTSEQ)
      where CH.REFOPE1='000002011700023204190510' and
CH.CODE_PI is null  and IsNull(FI.SENS_TRT,0)<>1