Re: Emptying Table in ADO


Thanks, but it doesnt work. Im receiving error msg 'CommandText does not
return a result set' Please help.

"Jeremy Collins" <jd.collins@xxxxxxxxxxxxxxxx> wrote in message
news:op.spzli6ys4al0tm@xxxxxxxxx
> On Fri, 29 Apr 2005 09:44:58 +0100, Ihsan <ihsa@xxxxxxxxx> wrote:
>
>> Hi!
>> Anyone can suggest the best way of emptying table in ado?
>
> Use ADO to execute the following SQL statement:
>
> DELETE FROM tb_mytable
>
> --
> jc


.

Relevant Pages

  • Re: Command object and batching stored procedure calls
    ... I'm using SQL Server. ... ADO Command object. ... 22 separate statements is the most I've been able to get in one CommandText, ... I'd appreciate it if you could point me to the Books Online where it's ...
    (microsoft.public.data.ado)
  • Re: ODBC Queries
    ... tried placing DoEvents in the code but it doesnt work. ... Use ADO and execute it async. ...
    (microsoft.public.access.formscoding)