Subject RE: [IBO] Where to place a global TIB_StoredProcs?
"G. Nau" <b404_r66@...> wrote:

>I use a TIB_StoredProc used to testing the existence of a
>partnumber in the partnumber-table.
>I've placed the TIB_StoredProc into the global datamodule and
>created a standard function, which i use all over my application.
>Function DoesPartNumberExist (PN : String) : Boolean;
> with datamodul.StoredProc_doespartnumberexist do
> Begin
> parambyname('SEARCH').asString:=PN;
> execute;
> Result:=Boolean(fieldbyname('RESULT').AsInteger);
> End;
>Work goods, but I have a transaction problem here.
>As the application is doing an insert/update/delete to the table, the
>changes are not visible to the stored procedure. Other applications
>can see the update; even the applications IB_Grid reflects the
>changes immediately.
>I've made some tests and found the place where the
>TIB_StoredProc is placed crucial.
>I've duplicated the TIB_StoredProc and the function in my testform
>and from there on it works fine.
>But I don't like to place an identical StorecProc and function all over
>my forms.
>My question:
>Where shall I place the globally used StoredProc? or is there
>something else I have to keep in mind?
> Gunther
>Gesendet von Yahoo! Mail - Jetzt mit 1GB Speicher kostenlos - Hier anmelden:

Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at