Multiple Recordsets from a Single Expression ?

Article View: borland.public.cppbuilder.database.ado

Article #3350

Back to borland.public.cppbuilder.database.ado Previous Next

#3350

From: Peter Moscatt
Date: Mon, 07 Oct 2002 03:06

10 lines
1508 bytes

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)";

Technical Details

Message-ID: <3da0fa4c$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,85e61ef802f7259b,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-10-06 20:14:01 PST
From: "Peter Moscatt" <pgmoscatt@optushome.com.au>
Sender: "Peter Moscatt" <pgmoscatt@optushome.com.au>
Reply-To: "Peter Moscatt" <pgmoscatt@optushome.com.au>
Subject: Multiple Recordsets from a Single Expression ?
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 203.2.231.20 203.2.231.20    
X-Forwarded-For: 203.2.231.2
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3da0fa4c$1@newsgroups.borland.com>
Date: 6 Oct 2002 20:06:52 -0700
X-Trace: newsgroups.borland.com 1033960012 207.105.83.65 (6 Oct 2002 20:06:52 -0700)
Lines: 10
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail