Subject | Refresh on insert for joined table |
---|---|
Author | Rick Roen |
Post date | 2005-09-14T12:05:03Z |
D7 IBO4.5B XP SP2
I have an order entry program with the following two tables:
OrderItems - INVOICENUM, ITEMNUM, QTY_ORDER, QTY_SHIP, RETAIL, ...
Packet - ITEMNUM, DESCRIPTION, RETAIL, ...
For displaying the items in the order I do a join like:
Select OI.INVOICENUM, OI.ITEMNUM, P.DESCRIPTION, OI.QTY_ORDER,
OI.QTY_SHIP, ...
From ORDERITEMS OI
Join PACKET P on P.ITEMNUM = OI.ITEMNUM
Where OI.INVOICENUM = :INVOICENUM
This IB_Query component feeds both a grid and IB_Edit boxes for
editing/inserting.
Everything is fine for display purposes in the grid and edit boxes,
however I can't get the Inserting to act like I want. When the user
adds a new record into a TEdit I verify that the ITEMNUM exists in
the Packet table (a separate IB_Query) Then insert a new record with
some default values for QTY_ORDER, QTY_SHIP etc. The IB_EDIT that
shows the P.DESCRIPTION does not show the Packet description while
in insert mode which is confusing to the user. I would like to
refresh the query somehow to the Joined Packet table Description
field is shown, but a Refresh on the table ( with raKeepDataPos )
only commits the new record since I have the transaction on
AutoCommit.
Is there some other way to get the joined Packet.Description to show
before the commit?
Rick
I have an order entry program with the following two tables:
OrderItems - INVOICENUM, ITEMNUM, QTY_ORDER, QTY_SHIP, RETAIL, ...
Packet - ITEMNUM, DESCRIPTION, RETAIL, ...
For displaying the items in the order I do a join like:
Select OI.INVOICENUM, OI.ITEMNUM, P.DESCRIPTION, OI.QTY_ORDER,
OI.QTY_SHIP, ...
From ORDERITEMS OI
Join PACKET P on P.ITEMNUM = OI.ITEMNUM
Where OI.INVOICENUM = :INVOICENUM
This IB_Query component feeds both a grid and IB_Edit boxes for
editing/inserting.
Everything is fine for display purposes in the grid and edit boxes,
however I can't get the Inserting to act like I want. When the user
adds a new record into a TEdit I verify that the ITEMNUM exists in
the Packet table (a separate IB_Query) Then insert a new record with
some default values for QTY_ORDER, QTY_SHIP etc. The IB_EDIT that
shows the P.DESCRIPTION does not show the Packet description while
in insert mode which is confusing to the user. I would like to
refresh the query somehow to the Joined Packet table Description
field is shown, but a Refresh on the table ( with raKeepDataPos )
only commits the new record since I have the transaction on
AutoCommit.
Is there some other way to get the joined Packet.Description to show
before the commit?
Rick