Re: Using Sequence #'s from PB Datawindow

In article <4a44mg$cr8_at_news.fmso.navy.mil>, kevin geist <kevin_geist_at_fmso.navy.mil> wrote:
>Have a sequence # in Oracle7 db which will be used in 3 history tables.
>Would like to put the next value into each history table as the update
>happens. Is there a way to do this automatically.
>
In SQLPreview event of this datawindow, use PB function GetSQLPreview() to capture the SQL statement which will be submitted to the database, modify the SQL string to include the next value of the sequence, finally use PB function SetSQLPreview() to have the new SQL statement executed by database.

• Xiangqun

-- 
Xiangqun Gu                      email: qun_at_cs.utexas.edu
Department of Computer Science
University of Texas at Austin
Austin, Texas