Re: Emptying Table in ADO

Execute this TADOCommand, do not use TADODataSet or TADOQuery.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Ihsan" <ihsa@xxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:4273776b$1@xxxxxxxxxxxxxxxxxxxxxxxxx
>
> 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: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.conversion)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: [Access2003, VBA] Use DAO or ADO?
    ... ODBC, whatever the back end. ... to a jet backend to open a ado recordset. ... customers want/need sql server and another wants to use MySql. ...
    (comp.databases.ms-access)
  • Re: Transaction not commited rollback?
    ... > I then, in my VB App, using ADO, execute multiple stored procedures ... > What if my VB program crashes before the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Run Access Query From Excel With Parameter?
    ... Indeed, the word exec (or execute, at long) is not required either, so just: ... Note that if you have more than one parameter, you may have to be sure of the right order of the parameters, using an explicit PARAMETERS clause in your Jet query. ... Building, explicitly, an ADO parameters collection is required when your stored proc return a value in one of the parameters, but that is not something Jet does with its stored procedures... ...
    (microsoft.public.access.modulesdaovba)