Re: Forms Questions
Date: Thu, 14 Aug 2003 12:29:54 GMT
Message-ID: <bhfvc4$kdj$1_at_cronkite.cc.uga.edu>
In article <jLw_a.62309$tQ2.1777659_at_news1.telusplanet.net>, "Dave" <LazyOracle_at_Yahoo.Com> wrote:
>1.Given a tabular style databased based block with 3 fields, (the underlying
>table has more than 3 columns, and the 3 displayed fields are not the
>primary key of the table), when I go through the form from top to bottom,
>how to determine that a duplicated record is encountered?
I assume you're talking about duplication in newly added rows. If you don't have the primary key columns in the data block, Forms won't check for duplicates... and I don't see how *you* could prevent duplicates without excessive coding. The database, however, will reject any duplicates at commit time and you can trap that in the on-error trigger. I actually prefer this over the Forms' checking method.
>2. Is there any way to obtain the value of certain field in certain
>NON-CURRENT record in a tabular style data block WITHOUT using go_record?
I assume that the "certain record" isn't so specific that you could store it in variables. No... no way that I'm aware of, anyway. Received on Thu Aug 14 2003 - 14:29:54 CEST