Sorry Alan I should have been clearer. I am using the built in Transaction of the IBODatabase component. This means, I think, that like the BDE every Post completes a transaction. I am only using explicit transactions in some areas at the moment (transactions do not work well with BDE / Dbase).

I believe you are most likely right about an explicit refresh being required, I suspected this from the outset. My hope was that there was a simple / generic C/S system to handle the issue. I am slowing comming to grips with some of the issues :)

Im off home now !


Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
web www.chreos.com
Wild Software Ltd

----- Original Message -----
From: Alan McDonald
To: IBObjects@yahoogroups.com
Sent: Tuesday, September 07, 2004 5:10 PM
Subject: RE: [IBO] Dataset refresh


> Hi Alan
>
> Its not a commit or transaction issue as I am using IBO (as
> opposed to IB_) components

I have no idea what you mean by this... you can have commit/transaction
"issues" in any and all db components... what do you think is the difference
between the components? The IB_ components do not descend from the TDataset
class whereas the IBO components do and are compatible with TQuery etc
components but they both use transactions....

to speed conversion (it is a very
> large app). Just now I was in the invoice screen, opened the
> client management screen and added a new client, went back to the
> invoice screen and selected the client from a combo. This works
> great, however if I do the same with item price (and likely other
> areas), when I add the item to the invoice it does not show.
> Perhaps the Combos are doing a refresh before they locate?
>
>

I dare say that when you drop the combo, it does a refresh of the underlying
query. If you want a record in the invoice screen to reflect the changed
price of the edits you made elsewhere, you will need to refresh at least
that record in the grid or control. This can be done manually by the user
(screen button) or automatically where you think most appropriate e.g. event
driven. There are many other places/events you can use to drive this refresh
and it doesn't have to be the entire recordset but rather the single record
in question.
Bottom line - C/S works very differently from desktop database
environments - there are many advantages but also things you need to get
used to
Alan

> Commit
> Rob Martin
> Software Engineer
>
> phone 03 377 0495
> fax 03 377 0496
> web www.chreos.com
> Wild Software Ltd
> ----- Original Message -----
> From: Alan McDonald
> To: IBObjects@yahoogroups.com
> Sent: Tuesday, September 07, 2004 4:40 PM
> Subject: RE: [IBO] Dataset refresh
>
>
> > Hi All
> >
> > We have an application that has multiple screens open
> > simultaneously. It has an invoice screen. If someone alters the
> > price of an item using another screen while the invoice screen is
> > open, the screen does not pick up the changes until closed and
> > reopened. This is happening in a variety of places. Previously
> > the application was Dbase / BDE and this was all handled for us.
> >
> > I know I could do refreshes in specific places but the code is
> > large and we would surely miss some / cause other problems / slow
> > performance. Is there a good / better way to simulate the old
> > BDE behaviour? Am I missing something?
> >
> >
> > Rob Martin
> > Software Engineer
>
> I don't suppose you mean close and reopen the screen where the
> edits have
> been done?
> If so then maybe you don't know about commit? - maybe you are
> only commit
> retaining? your edits?
> am I on the right track?
> Alan
>
>
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird
> or InterBase
> without the need for BDE, ODBC or any other layer.
>
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
> ------------------------------------------------------------------
> ------------
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/IBObjects/
>
> b.. To unsubscribe from this group, send an email to:
> IBObjects-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
> of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Yahoo! Groups Links
>
>
>
>
>
>
>




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]