TDatabase::Execute() with Oracle 8i problem

Article View: borland.public.cppbuilder.database.multi-tier

Article #488

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#488

From: Howard Lee Harkness
Date: Thu, 30 Aug 2001 16:08

14 lines
1553 bytes

Seems the TDatabase::Execute() works ok for most of my inserts and
updates, but I have one that bombs with an access violation.  The sql
is of the form:

  insert into table1 (select '00005', '11', office, casetype from
table2, table3 where eventkey='4')

That's not the exact query...  But I have tested the actual query
using SQLPlus, and it runs ok.  It also runs ok if I pass it to a
TQuery, which indicates that TDatabase::Execute() can't handle complex
inserts for some reason.

Spam Me and Get Sued <harkness@suespammers.org>
see www.suespammers.org for details & free spam-nuking email account

Technical Details

Message-ID: <vrosot8qlbg82k5bngu7glcp6panclbqqs@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!193.174.75.178!news-fra1.dfn.de!news-lei1.dfn.de!newsfeed00.sul.t-online.de!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: fcd2b,d5800e30e8806962,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-08-30 11:14:48 PST
From: Howard Lee Harkness <harkness@suespammers.org>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: TDatabase::Execute() with Oracle 8i problem
Date: Thu, 30 Aug 2001 11:08:34 -0500
Organization: YGBSM!
Message-ID: <vrosot8qlbg82k5bngu7glcp6panclbqqs@4ax.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 209.211.240.254
X-Trace: dnews 999194974 209.211.240.254 (30 Aug 2001 11:09:34 -0700)
Lines: 14
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!193.174.75.178!news-fra1.dfn.de!news-lei1.dfn.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews