🚀 go-pugleaf

Where does the error appear?  When opening the DataSet or when calling
Insert()?
Did you think of using TADOTable or TADOCommand?
Greetings,
Didi

"Mike" <mikeh@gmx.de> schrieb im Newsbeitrag
news:3fa00b93@newsgroups.borland.com...
> Hello,
>
> I use the ADODatSet component to build a connection using jet driver to a
> access file. this works fine. no i like to insert new data to the acces
db.
> here is my code:
>
> try
> {
> ADODataSet->Open();
> ADODataSet->Insert();
>
> // insert data
> ADODataSet->FieldByName("Contacname")->AsString = delivery_name;
> ADODataSet->FieldByName("Company")->AsString = delivery_company;
> ADODataSet->FieldByName("Adress")->AsString = delivery_street_address;
> ADODataSet->FieldByName("City")->AsString = delivery_city;
> ADODataSet->FieldByName("ZIP")->AsString = delivery_postcode;
> ADODataSet->FieldByName("State")->AsString = delivery_state;
> ADODataSet->FieldByName("Country")->AsString = delivery_state;
>
> ADODataSet->Post();
> ADODataSet->Close();
> }
> catch(...)
> {
> Beep();
> ShowMessage("Error");
> }
>
> Whe i run that code, there always is an error message that CommandText
> missing. But I have no sql code and do not know, why i need CommanText and
> do not know what to put there.
>
> Any ideas. Can anybody help me?
>
> Mike
>
>