Thread View: borland.public.cppbuilder.database.ado
2 messages
2 total messages
Started by Jonathan
Mon, 11 Dec 2000 07:30
triggers in oracle
Author: Jonathan
Date: Mon, 11 Dec 2000 07:30
Date: Mon, 11 Dec 2000 07:30
19 lines
1876 bytes
1876 bytes
Hello. i can't find information on how to do the following thing: i'm sending batched insert statements to my database using PreparedStatement class. if there is a way in which a failure in one insert statement does not reflect on the following statements, pleases tell me the steps in which that could be achieved. currently, i'm trying to construct a BEFORE INSERT trigger that has the following behavior: if the record to be inserted exists, then the insert is not performed and the next insert is called upon. in essense, i'm trying to do :new++. thanks in advance fot the help. jacob zukovsky.
Re: triggers in oracle
Author: Mark Cashman
Date: Tue, 12 Dec 2000 01:37
Date: Tue, 12 Dec 2000 01:37
16 lines
1809 bytes
1809 bytes
Hi, Jacob! I would think you would simply use transactions and normal C++ exception handling. Any reason you wouldn't? Also, please do not crosspost as it is against the newsgroup guidelines (http://www.borland.com/newsgroups) ------ Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at http://www.temporaldoorway.com - Original digital art, writing, music and more - C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring (Join us!) http://www.temporaldoorway.com/programming/index.htm ------
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