Executing more sql commands
Executing more sql commands
(OP)
I want to execute several sql commands after each other.
but executing this part I get an error:
[Microsoft][ODBC SQL Server Driver]Function sequence error"
I don't know much about sql but can somebody help me with this problem ?
CODE
UPDATE CLIENTS SET CLIENTS.XDEPTID = 1085, CLIENTS.XDEPTNR = 88513, CLIENTS.POB = 921
WHERE (((CLIENTS.XDEPTID)=921) AND ((CLIENTS.XDEL) Is Null Or (CLIENTS.XDEL)='N'));
UPDATE CLIENTS SET CLIENTS.XDEPTID = 1086, CLIENTS.XDEPTNR = 88520, CLIENTS.POB = 894
WHERE (((CLIENTS.XDEPTID)=894) AND ((CLIENTS.XDEL) Is Null Or (CLIENTS.XDEL)='N'));
WHERE (((CLIENTS.XDEPTID)=921) AND ((CLIENTS.XDEL) Is Null Or (CLIENTS.XDEL)='N'));
UPDATE CLIENTS SET CLIENTS.XDEPTID = 1086, CLIENTS.XDEPTNR = 88520, CLIENTS.POB = 894
WHERE (((CLIENTS.XDEPTID)=894) AND ((CLIENTS.XDEL) Is Null Or (CLIENTS.XDEL)='N'));
but executing this part I get an error:
[Microsoft][ODBC SQL Server Driver]Function sequence error"
I don't know much about sql but can somebody help me with this problem ?
RE: Executing more sql commands
UPDATE CLIENTS SET CLIENTS.XDEPTID = 1085, CLIENTS.XDEPTNR = 88513, CLIENTS.POB = 921 WHERE (CLIENTS.XDEPTID=921 AND (CLIENTS.XDEL Is Null Or CLIENTS.XDEL='N'));
UPDATE CLIENTS SET CLIENTS.XDEPTID = 1086, CLIENTS.XDEPTNR = 88520, CLIENTS.POB = 894
WHERE (CLIENTS.XDEPTID=894 AND (CLIENTS.XDEL Is Null Or CLIENTS.XDEL='N'));
Note that this...
(CLIENTS.XDEL Is Null Or CLIENTS.XDEL='N')
...can be reduced to...
ISNULL(CLIENTS.XDEL,'N')='N'
best wishes
RE: Executing more sql commands
Replace 'ISNULL' with 'COALESCE' in the previous post
RE: Executing more sql commands
This question needs to be posed in some other forum, depending upon what client you are using to issue these statements against SQL Server. Once again my apologies for wasting your time.