Article View: borland.public.interbase.opensource
Article #282Re: getting ip in a stored procedure
From: Bill Todd
Date: Mon, 04 Jul 2005 00:27
Date: Mon, 04 Jul 2005 00:27
16 lines
1282 bytes
1282 bytes
The only way to get the IP address is from the TMP$ATTACHEMTNS table. If you can find a way to know which attachment is running the stored procedure you can query TMP$ATTACHMENTS. -- Bill Todd (TeamB) FrankW wrote: > Hi, > > is there a way to know in a stored procedure the ip of computer which > involves the said stored procedure? Thanks, > > FrankW
Technical Details
Message-ID:
<42c88270$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news-out.nntp.be!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<42c8794f@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 106772,5a24761f562b19ca
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: getting ip in a stored procedure
Newsgroups: borland.public.interbase.opensource
References: <42c8794f@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.17.5.7
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <42c88270$1@newsgroups.borland.com>
Date: 3 Jul 2005 17:27:28 -0700
X-Trace: newsgroups.borland.com 1120436848 216.207.211.19 (3 Jul 2005 17:27:28 -0700)
Lines: 16
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news-out.nntp.be!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail