Re: Error Deleting From Table

From: David (dfm_at_cmgasia.com.hk)
Date: 03/24/04


Date: Wed, 24 Mar 2004 15:49:33 +0800

Greg Cheek <greg.cheek@acs-inc.com> wrote in message
news:40610d40$1@newsgroups.borland.com...
> table name - Proc
>
> query.sql.add(Delete From Proc);
> query.ExecSQL;
> What's wrong with this statement,
> please help
>
>
> Thanks
> GSC
>
>
Not sure without your error message but I would
query.sql.clear; // just to make sure
query.sql.add('delete from proc');
query.execsql;

David



Relevant Pages

  • Re: Error Deleting From Table
    ... mILAN ... Greg Cheek wrote: ... > query.sql.add(Delete From Proc); ... > GSC ...
    (borland.public.delphi.database.ado)
  • Re: Args getting written into text ouput
    ... > arguments, the data displays correctly, but wish throws an error message ... ran into problems closing the pipe that calls rman. ... Each time I closed the pipe, the stuff on stderr would cause my proc ...
    (comp.lang.tcl)
  • Re: A deep bug in TK/entry
    ... toplevel .ent ... set iwant ... this proc, ... The error message in 1) could re-occur at any time! ...
    (comp.lang.tcl)
  • A deep bug in TK/entry
    ... toplevel .ent ... set iwant ... this proc, ... The error message in 1) could re-occur at any time! ...
    (comp.lang.tcl)
  • Re: Invalid Argument while Opening file
    ... variables and second_pass proc process those lines inside the file. ... checktclvars.pl line 268, <INFILE> line 13591. ... If you accurately reported the error message, ... quotes in it, as if the name of the file included quote symbols. ...
    (comp.lang.perl.misc)