Re: Forms 4.5 & stored procedures - problems with COMMIT

Have you tried using a FORMS_DDL('COMMIT') command from your form. We use this when we do processing on 'non-base-table' blocks.

Good Luck.

Mike

Alex Savitsky <asavicki_at_sprint.ca> wrote in message news:qyj73.45864$r_1.24255966_at_newscontent-02.sprint.ca...
> Hi all!
>
> Here is the problem I'm stuck with: I have a Forms application that calls
> several stored procedures, which actually do all work, i.e. block is
marked
> as non-base-table and no items are bound to database columns. However, it
> seems I cannot commit data! As long as I am in application, changes I made
> are there, but when I exit changes are gone. COMMIT says that 'No changes
to
> save'; so does COMMIT_FORM. If I use EXIT_FORM(DO_COMMIT) instead of
simply
> EXIT_FORM, it doesnt work either. I really would like to avoid putting
> COMMIT inside procedures. Is there any other way of doing it?
>
> TIA
>
> Alex
>
>
>
Received on Wed Jun 09 1999 - 18:56:38 CEST