Re: new and old values

Article View: borland.public.interbase.sql

Article #19

Back to borland.public.interbase.sql Previous Next

#19

From: Martijn Tonies
Date: Wed, 21 May 2008 20:39

26 lines
1738 bytes

Hi,

> I am trying to make a scenario of saving a bill contains many items, I
> need when a user make an update to be able to get old and new values of
> that update so I am thinking of writing a stored procedure
>
> can I access new and old from the TIBStoredProc or it is only accessible
> from triggers ?

NEW and OLD is only available in Triggers.

That being said, a TIBStoredProc is a client-side component to call a
server-side Stored Procedure, you cannot touch the internals of that
procedure from the component.


-- 
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Technical Details

Message-ID: <48348793@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!t-online.de!feeder.news-service.com!news.isoc.lu!newsgroups.borland.com!not-for-mail

References: <483481ec@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,ed21a630be2a7972
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Martijn Tonies" <m.tonies@upscene.removethis.com>
Newsgroups: borland.public.interbase.sql
References: <483481ec@newsgroups.borland.com>
Subject: Re: new and old values
Date: Wed, 21 May 2008 22:39:46 +0200
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1914
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914
NNTP-Posting-Host: 212.238.159.172
Message-ID: <48348793@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1211402131 212.238.159.172 (21 May 2008 13:35:31 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!t-online.de!feeder.news-service.com!news.isoc.lu!newsgroups.borland.com!not-for-mail

Reply to Parent Message