Article View: borland.public.cppbuilder.database.ado
Article #120Insert problem
From: Tomislav Hundric'
Date: Sat, 15 Sep 2007 09:27
Date: Sat, 15 Sep 2007 09:27
23 lines
1532 bytes
1532 bytes
Hi, I've got a question regarding insert into table, I'm using access database, ADOConnection and ADOQuery: I have SQL like this: Insert into Table1 (Field1) Select distinct Field2 From Table2 Executing this query throws me this error "current provider does not not support returning multiple recordsets from simple execution" When I look into my table I can see that records are added even though an error was thrown. Basically what I'm trying to do is to fill relational tables with data from one temp table. Is my approach ok, or should I do this in some other way. Thanks in advance, Tomislav.
Technical Details
Message-ID:
<46eba5b2@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 10698b,2042ce4cafe32ddf,start X-Google-Attributes: gid10698b,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit Date: Sat, 15 Sep 2007 11:27:38 +0200 From: Tomislav Hundric' <rifnet@gmail.com> User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.ado Subject: Insert problem Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 83.131.43.115 Message-ID: <46eba5b2@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1189848498 83.131.43.115 (15 Sep 2007 02:28:18 -0700) Lines: 23 Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail X-Original-Bytes: 1378