Forms4: Cursor or Record Group?

From: Gary John Walker <gjwalker_at_gjw1992.demon.co.uk>
Date: Sat, 19 Mar 1994 22:19:20 +0000
Message-ID: <764115560snz_at_gjw1992.demon.co.uk>


 In Forms 4, what is the advantage of using Forms Record Groups  functions rather than a standard PL/SQL select into a cursor?

 Below is just some background ramblings.

 My knowledge of both is limited, but having battled with record  groups, eventually getting something to work, I reckon there must  be a better way. (note: the record group problem was that even  with using a populate_with_query in a trigger, the forms item  used in a 'where' clause remained constant after the first time  used, tho rows returned were 'refreshed' on every call so it  wasn't simply me seeing old values in the returned record group.  Workaround was to build a record group based on the form's item's  current value. One record group for every diff item value during  a forms session).


          Gary John Walker     gjwalker_at_gjw1992.demon.co.uk

-------------------------------------------------
Received on Sat Mar 19 1994 - 23:19:20 CET

Original text of this message