Re: Committing single record in Forms 5.0

So your user calls up the data on the form, and changes stuff all over the place, but you want to only commit the changes to one record, right? This sounds like trouble to me.

About the only way you can cause one record to update and commit without the others is to issue your own SQL Update command from a button, and follow it with a Forms_DDL('COMMIT'). You should then re-query the block so the form 'sees' the updated record in it's database state.

But you are trying to do something really strange to Forms. You might want to alter your design of the form.

Steve Cosner

In article <36A30709.875723AC_at_icon.co.za>, Louis Spies <louiss_at_icon.co.za> wrote:
>Hi everyone,
>
>I have a form with several blocks that get updated simultaneously, and
>at a certain stage, commit just one record in one block. Is this at all
>possible? If so, how?
>
>I want to be able to do this in a when-button-pressed trigger.
>
>Thanks in advance
>
>Louis Spies
Received on Wed Jan 20 1999 - 04:59:46 CET