🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.opensource
Article #283

Re: getting ip in a stored procedure

#283
From: FrankW
Date: Mon, 04 Jul 2005 07:05
23 lines
1507 bytes
Hi Bill,

thanks, but as i understand that's only in ib7, not in the open source 
version.

"Bill Todd" <no@no.com> wrote in message 
news:42c88270$1@newsgroups.borland.com...
> 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: <42c8b4f3@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-mail
References: <42c8794f@newsgroups.borland.com> <42c88270$1@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: "FrankW" <nospam@nospam.com>
Newsgroups: borland.public.interbase.opensource
References:  <42c8794f@newsgroups.borland.com> <42c88270$1@newsgroups.borland.com>
Subject: Re: getting ip in a stored procedure
Date: Mon, 4 Jul 2005 00:05:26 -0700
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 222.126.70.223
Message-ID: <42c8b4f3@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1120449779 222.126.70.223 (3 Jul 2005 21:02:59 -0700)
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