Re: Transaction ID

Article View: borland.public.interbase.sql

Article #936

Back to borland.public.interbase.sql Previous Next

#936

From: Shahid Iqbal
Date: Sat, 05 May 2007 04:42

25 lines
1692 bytes

because i want to write it into a logtable e.g

INSERT INTO MYLOG (TRANS_ID, USER_ID, DATE_TIME, MACHINE_ID, LOG_INFO)

Trans_ID :  Active Transaction ID.
User_ID :  logged in User id from my own table not an interbase user.
Date_Time: Server Date & Time. (Select Current_TimeStamp from rdb$database)
Machine_ID : Computer Name where application is running.
Log_Info: BLOB data.

hope u understand.

"Bill Todd" <no@no.com> wrote in message 
news:463b499e$1@newsgroups.borland.com...

> Shahid Iqbal wrote:
>
>> Firebird is providing the active transaction id, why not Interbase !!!
>
> Why do you need it?
>
> -- 
> Bill Todd (TeamB)
>

Technical Details

Message-ID: <463c0ba3@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References:

<46398310@newsgroups.borland.com> <4639d52d$1@newsgroups.borland.com> <463abe99@newsgroups.borland.com> <463b499e$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,d90274d8031a6000
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Shahid Iqbal" <delphiexpert@lycos.com>
Newsgroups: borland.public.interbase.sql
References: <46398310@newsgroups.borland.com> <4639d52d$1@newsgroups.borland.com> <463abe99@newsgroups.borland.com> <463b499e$1@newsgroups.borland.com>
Subject: Re: Transaction ID
Date: Sat, 5 May 2007 09:42:41 +0500
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 210.2.150.94
Message-ID: <463c0ba3@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1178340259 210.2.150.94 (4 May 2007 21:44:19 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message