SQL Insert

Giganews Newsgroups
Subject:SQL Insert
Posted by: Bruno Køhler Pedersen
Date:Thu, 27 May 2010

D. Ent.prise 2010. Access 2007 connected with TADOConnection

Previously with paradox tables I used to write:

Insert into tablename(FieldName)
Values(thevalue)
in the SQL property of a TQuery, and in the code I had:
MyTquery.execSQL;

Now I can use TADOQuery in the same way, but isn't to prefere to use TADODataSet. In that case how?
I have looked for a method like execSQL for TADODataSet.
Thank you
Bruno

Replies