Re[2]: delete from
Not to state the obvious, but you are also going to have trouble with
the () around the table name and the "" around the not like qualifier.
Craig Lanford
mailto:craig.lanford@alltel.com
______________________________ Reply Separator _________________________________
Subject: Re: delete from
Author: dmorales@giro.es (Diego Morales) at internet
Date: 3/30/00 4:39 AM
delete from (.........
You don't need the '*' because you never delete fields, you always delete
all the record.
Si us plau, contesti a him_lommel@t-online.de
Destinataris:
informix-list@iiug.org
CC: (cci: Diego Morales/Informatica/Area
Administrativa-Financiera/Nacional/Grupo Giro)
CCI: Diego Morales/Informatica/Area
Administrativa-Financiera/Nacional/Grupo Giro
Assumpte: delete from
Hi there, maybe someone can help me:
Script in unix:
echo "delete * from (fa_daten) WHERE (fa_nr Not Like"E%")"|dbaccess
dbasename
error message:
Database selected.
201: A syntax error has occurred.
Error in line 1Near character position 8
Database closed.
What`s wrong ???