Re: Forms and commit

We were still having this problem and the only progress we have made is to see during execution that just before the commit we are in the block we thought we were and after the commit the block had changed to the one where we didn't want to be (as described below). And none of the go_blocks that follow, which do get executed without any msgs, change it. Go figure.

Anyway, I got on Google again and did another search and back in 1997 someone had a problem unlike ours, but the suggestion was to try a different commit. i just tried STANDARD.COMMIT and that 'fixes' the problem. Well, at least with a comment as to why using a different commit will qualify as a fix.

Now back to the real work.

This would all be so much easier in Delphi.

"Scott Mattes" <ScottMattes_at_yahoo.com> wrote in message news:Hdsx7.791$M6.346659_at_news1.news.adelphia.net...
> Forms 6.0.8.12.1
>
> I thought I was going nuts, but I have narrowed it down to the commit
> statement. With the commit working, not only are my inserts not commited,
> but Forms completely ignores my go_block and goes to a canvas that is
'near'
> where i want, but is not the one I want.
>
> I have checked for other triggers that might be getting in the way, but I
> haven't found any. The when-new-block-instance trigger for the block i
want
> to go to does not fire after the trigger that contains the 'commit;
> go_block'.
>
> I think it is time to shut down and think of something else.
>
> Any help would be GREATLY appreciated.
>
>
Received on Fri Oct 19 2001 - 22:18:27 CEST