[Sybase] probleme sur un delete.
Bonjour,
Je dois supprimer des tuples deja traité et voici ma requete :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
delete from tempdb..CALYONWRK as cal
where exists
(
select 1
from tempdb..WRK c,
ID_XACT e
where e.INST_PRICE = c.INST_PRICE
and e.PF_COD = c.PF_COD
and e.INST_NUM = c.INST_NUM
and e.INST_PRICE = c.INST_PRICE
and e.INST_QTY = c.INST_QTY
and c.XACT_DAT = substring(convert(varchar(8),e.XACT_DAT,112),7,2) + '-' + substring(convert(varchar(10),e.XACT_DAT,112),5,2) + '-' + substring(convert(varchar(10),e.XACT_DAT,112),3,2)
) |
voici le message d'erreur :
Citation:
<eb1>Incorrect syntax near the keyword 'as'.
State:37000,Native:156,Origin:[SYBASE][ODBC Sybase driver][SQL Server]</eb1>
Je suis sous Sybase version Adaptive Server Enterprise/12.0.0.8/P/EBF 11874 ESD2/Sun_svr4/OS 5.7/2058/64bit/FBO/Thu May 20 09:12:03 2004
Merci
PS : J'ai essayé sans le "as" et pareil, ça passe pas... :'(
