TDatabase::Execute() with Oracle 8i problem

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Howard Lee Harkness Thu, 30 Aug 2001 16:08

#488

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads