🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

ADO and InterBase

#4784
From: Roman Bouchner
Date: Tue, 25 Sep 2001 14:34
29 lines
1780 bytes
Hi
I have some problem with using ADO and InterBase database. I am using ODBC
(Gemini EasySoft) and in both cases there is this problem:

/* part A*/
query->SQL->Text = "SELECT * FROM SysLevels";
q->Open();
int c = q->Fields->FieldByName("id")->AsInteger;
q->Close();

/* part B*/
query->SQL->Text = "INSERT INTO DocFTP (Title, BaseDir)  VALUES
('test','test')";
query->ExecSQL();  /* There is Access Violation error */

If I execute these parts separately, it does work, but when I execute part B
after part A, there is "Access Violation Error"
Could anyone help me? I really don't know how to solve this situation. I
suppose it
could be because of bad implementation of ADO component.
I have been trying others ODBC drivers and OLE DB drivers, but I found only
other problems (typically with Access Violation Error).
I am using:
Borland C++ EnterPrise 5.0 with updatepack1 and ADOupdate.
Interbase 6.0 and InterBase 6.1
patch MDA 2.6

Thanks
Roman
Technical Details
Message-ID: <3bb09649_1@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,364a8b0faf6980f9,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-09-25 07:43:31 PST
From: "Roman Bouchner" <bouchner@aipsafe.cz>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADO and InterBase
Date: Tue, 25 Sep 2001 16:34:23 +0200
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 62.24.72.15
Message-ID: <3bb09649_1@dnews>
X-Trace: dnews 1001428553 62.24.72.15 (25 Sep 2001 07:35:53 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews