Pl/SQL code help

2002-04-08 Thread Roland . Skoldblom
Hallo, I have some trouble with this pl/sql procedure. I would like that this lvsql to be run only if the field Borttags_flagg = 0 but i get an error in the if statement, whatis wrong with this? It get the erromressage: LS-00103: Encountered the symbol ||AvdNr|| when expecting one of the

RE: Pl/SQL code help

2002-04-08 Thread Thomas, John
Roland, I think you have a quote in the wrong place: If A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' || Should probably read: If 'A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 ' || Cheers, John Thomas -Original Message- Sent: 08

Ang: RE: Pl/SQL code help

2002-04-08 Thread Roland . Skoldblom
But when I have fixed that error and then have the then statement put before the lvsql statement I get this errormessage: What does that mean? How to fix it? PLS-00103: Encountered the symbol THEN when expecting one of the following: ( - + mod null an identifier a double-quoted