TADODataSet AddNew syntax

Hello,

Can anyone give me an example of the proper syntax for using TADODataSet
RecordSet.AddNew when attempting to insert a new record and specify more
than one field and value? I know that AddNew requires two parameters both of
which are OleVariants the first of which is a field list and the second is
the field values. Nothing I try seems to work as I always get an error
indicating the 'field is not found'. As long as I specify a single field and
value it works fine. I am working with Delphi 7 and and Access database.

TIA for any help!
James


.

Relevant Pages

  • Re: ASP / Access: use of same table twice in one query
    ... are in the same table and I need them both in one query. ... I agree it is better to specify the fields I need in the select statement, ... >> The data is stored in an Access database. ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Question about ALTER TABLE and ALTER COLUMN
    ... but I would like to further specify that the column be ... an integer with a default value of zero. ... syntax for a VBA statement to do what I want to do? ... ALTER COLUMN but I don't know the proper syntax. ...
    (microsoft.public.access.modulesdaovba)
  • Re: SW inventory
    ... the file to specify what computer it's from, but the name of the file is the ... >>then puts the resulting file in a share. ... >>Brooke Justice ... > I'd suggest creating a table in an Access database with matching ...
    (microsoft.public.access.gettingstarted)
  • Re: I want to create form look like explorer to receive attachment fi.
    ... The simplest way to allow the user to specify the location and name for a ... file in an Access database would be to use the File Open dialog. ... "MICK" wrote in message ...
    (microsoft.public.access.modulesdaovba)
  • Re: Execute Access VBA Macro from DTS
    ... I was wondering if one is able to specify which ... Kind regards ... I have a DTS package that populates an Access Database, ...
    (microsoft.public.sqlserver.dts)