Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Transaction Object

2 posts in Objects Last posting was on 2003-07-31 08:09:13.0Z
Ulises Contreras Posted on 2003-07-30 23:09:03.0Z
Sender: 36f3.3f284fc1.1804289383@sybase.com
From: Ulises Contreras
Newsgroups: sybase.public.powerbuilder.objects
Subject: Transaction Object
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f28500f.371a.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Jul 2003 16:09:03 -0700
X-Trace: forums-1-dub 1059606543 10.22.241.41 (30 Jul 2003 16:09:03 -0700)
X-Original-Trace: 30 Jul 2003 16:09:03 -0700, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7528
Article PK: 734815

What I want is to program the transaction object , so that,
when i update a table (or tables), it saves the
sentence that is performing in a log table in my database.
The update of this log table should be
done by a datawindow, datastore or embebed sql. This 3
objects will use the transaction object that i want to
program.
The problem i have, is that i don't know how to get the
sentence that the transaction object is performing, or at
what
time happens the update and how does the transaction object
would notice that the update has happened.
Thank you.


Diego Marrero Posted on 2003-07-31 08:09:13.0Z
From: "Diego Marrero" <diego@vegati.com>
Newsgroups: sybase.public.powerbuilder.objects
References: <3f28500f.371a.846930886@sybase.com>
Subject: Re: Transaction Object
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: 240.red-80-36-136.pooles.rima-tde.net
X-Original-NNTP-Posting-Host: 240.red-80-36-136.pooles.rima-tde.net
Message-ID: <3f28cea9@forums-1-dub>
Date: 31 Jul 2003 01:09:13 -0700
X-Trace: forums-1-dub 1059638953 80.36.136.240 (31 Jul 2003 01:09:13 -0700)
X-Original-Trace: 31 Jul 2003 01:09:13 -0700, 240.red-80-36-136.pooles.rima-tde.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7530
Article PK: 734814

Instead of the transaction object, you could use the SQLPreview event for
datawindows and datastores . For embeded SQL you could write a function in
the transaction object and delegate the execution and log to it.

HTH
--
Diego Marrero
Vega T.I.
922825052 - 667515517
www.vegati.com
<Ulises Contreras> escribió en el mensaje
news:3f28500f.371a.846930886@sybase.com...

> What I want is to program the transaction object , so that,
> when i update a table (or tables), it saves the
> sentence that is performing in a log table in my database.
> The update of this log table should be
> done by a datawindow, datastore or embebed sql. This 3
> objects will use the transaction object that i want to
> program.
> The problem i have, is that i don't know how to get the
> sentence that the transaction object is performing, or at
> what
> time happens the update and how does the transaction object
> would notice that the update has happened.
> Thank you.