|Subject||Re: [IBO] Where to place a global TIB_StoredProcs?|
> I use a TIB_StoredProc used to testing the existence of aAre you sure the transaction that it uses in the main datamodule allows read
> 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
> 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.
commited or is started just before calling the SP?