My weekly post: use post instead of commit

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Mon, 22 Mar 2004 09:40:41 -0400
Message-ID: <000901c41013$4bb4f530$2501a8c0@dazasoftware.com>

Hi,
last week I investigate something interesting related to database work.

If your developers are working with form developer/2000, and they are using blocks
(one block per table, procedure or view) usually used because it have several advantages like query built in functions.

The only way to put that data back to the database seem to be
1) executing a commit.
2) executing manual inserts, deletes and updates.

But there is a third option if you need to post the data in a block WITHOUT DOING A COMMIT, to validate data for example, you can use post. If you modify some form triggers on-close and on-rollback, you can get the window closed and the data posted there.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon Mar 22 2004 - 07:42:47 CST