Re: TADODataset instead of TADOQuery

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

Article #2383

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

#2383

From: Viatcheslav V. Vassiliev
Date: Sat, 05 Jul 2003 09:17

32 lines
2109 bytes

Use TADOConnection->Execute() with eoExecuteNoRecords in ExecuteOptions. Or
try to add eoExecuteNoRecords in ExecuteOptions property of TADODataset.

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

"M. Noroozi Eghbali" <galaxy@irandoc.ac.ir> �������/�������� � ��������
���������: news:3f067d4f@newsgroups.borland.com...
> Hi,
>
> Since I need to send WideString SQL commands to Microsoft Jet 4.0
provider,
> I changed all TADOQuery components of my application to TADODataset but
when
> I try to make a table via this component I get this error message:
>
> "Current provider does not support returning multiple recordset from a
> single execution."
>
> The command is: "Create Table Thesaurus (LineNum Integer, Primary Key
> (LineNum));"
>
> This command worked properly when I used TADOQuery. Any help?
>
> Thank you in advance,
> Mehrdad
>
>

Technical Details

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

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!small1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3f067d4f@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,8c5e40a63bf82231
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-07-05 02:39:10 PST
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3f067d4f@newsgroups.borland.com>
Subject: Re: TADODataset instead of TADOQuery
Date: Sat, 5 Jul 2003 13:17:22 +0400
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 213.247.201.57
Message-ID: <3f0697d7$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1057396695 213.247.201.57 (5 Jul 2003 02:18:15 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!small1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message