Adding records to a database using ADO

[cturland]

Hi all,

Can anyone give me help with adding new records to a database using ADO. Do you have to run an add SQL query in the RecordSource?

Thanks,
Carl

 

[Bigley]

Use the ADO command object to execute a sql string. The string should be something like "INSERT INTO myTable....."

 

[link9]

Also, if you have some ADO Recordset, you can use the .addNew method of the recordset to add the new records.

 

[cturland]

The .addNew command only as the data to the recordset and not to the database............doesn't it?

 

[link9]

Correct, but then you use the .update to update the actual database.

 

[cturland]

Ah I see!!

I was working along the right lines but I guess somewhere my syntax is wrong. Would you be able to write a quick bit of sample code for me? For example to add the string in text1.text into a column called Name in the database.

Thanks for your help,
Carl