At 04:00 PM 5/12/2003 +0800, you wrote:

>Good day.
>
>I have another problem. =( .

Lots of problems here. This is NOT a good design.

>I have a mater detail setup in my application. I want to perform a check
>first before saving the records to prevent duplicate entry of invoices.

Why?

Begin by saying where you are getting the invoice number from.

I'm top-posting this so I can keep the rest of your description together
with this.

Helen

>So in the master dataset before post i have something like this
>
>if masterdataset.state = dssinsert and not masterdataset.ispostretaining
>then
> // search for possible duplicate records code is here
>
>I use the invoice no as search criteria in searcing for the duplicate
>records ... what happen is since ther is a postretain that happen when a
>detail dataset record was post. the search for duplicate records result
>to finding the current invoice since it was postretain ... how could I
>able to do such things that my search wont see the post that was retain?
>
>As of now the solution that I have is to use a different transaction for
>searching the duplicate since it is not yet committed but I feel it is a
>long solution ... There might be a short solution I guess from you
>experts =)
>
>James
>
>
>
>
>___________________________________________________________________________
>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 !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/