Re: delete from

Posted in 2000

Diego Morales — Thu, 30 Mar 2000 11:39:07 +0100 — source: Informix-list mailing list archive (1991-1998)

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 ???