🚀 go-pugleaf

Place eoExecuteNoRecords into ExecuteOptions property of ADODataSetRemote.
If this does not help, provide command text, like

str = "INSERT INTO MACHINE VALUES ('" +
ADODataSetLocal->FieldValues["Serial_Number"] + "','TO30',1,'1','" +
ADODataSetLocal->FieldValues["Model_Code"] + "','1','0.0.0.0','" +
ADODataSetLocal-FieldValues["EqptNo"] + "',1)";

ADODataSetRemote->CommandText = str;

Write here the value of str.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server and MS Jet (MS Access) databases.

"Peter Moscatt" <pgmoscatt@optushome.com.au> �������/�������� � ��������
���������: news:3da0fa4c$1@newsgroups.borland.com...
>
> I am trying to write data to an Access database using the code shown below
but get a runtime error saying "Current provider does not support returning
multiple recordsets from a single expression."
>
> The provider is set to: Microsoft.Jet.OLEDB.4.0
>
> How do I get around this problem ?
>
> Pete
>
> ADODataSetRemote->CommandText = "INSERT INTO MACHINE VALUES ('" +
ADODataSetLocal->FieldValues["Serial_Number"] + "','TO30',1,'1','" +
ADODataSetLocal->FieldValues["Model_Code"] + "','1','0.0.0.0','" +
ADODataSetLocal->FieldValues["EqptNo"] + "',1)";