Re: A Successful Commit Returns 'Data Not Saved'

On Sun, 23 Nov 1997 11:41:31 GMT, Thenardier_at_POBoxes.com (ªü´ö Thenardier) wrote:

>
>In a form i have items which Base Table Items properties
>are FALSE. For them I need to manually write a INSERT statement
>to insert new records to a table and then COMMIT (I put those
>codes in the When-Button-Press trigger in a button). Yet after
>a successful COMMIT (from SQLPlus i know so), the form
>display a FRM-##### message saying that no data has been saved.
>
>How can i make it return a data-successfully-commit type of message?
>Set the Base Table Item to TRUE? Tried. And no use.
>
>It's quite simple (to u), isn't it? What if i want to use the info in
>the items, do some calculations, and then INSERT them to more than one
>tables?
>
>Thanx in advance!
>
>
>Cheers,
>Thenard

No it's not quite simple. You're asking for an event trigger, and as the form has nothing in it's event list - as no fields has changed, the form has nothing to do.

Please read the user-guide for Forms development. It seems you're starting on the completely wrong foot. There are ways to do what you want - but usually I will not recommend them as they MIGHT get you into problems elsewhere. But look into standard.commit or :system.message_level for your solution.

Regards
Peter H. Larsen Received on Sun Nov 23 1997 - 00:00:00 CET