End Transaction calls another event.

[SSSMan]

I have been working on this problem for a few days and have not been able to figure this out.

Here is what is happening:

I have a PageFrame with 8 pages.
The user is sitting on a grid on Page3 and from a textbox in the grid, the LostFocus calls the Click event of a button on that page that activates Page4.
Page4 is activated and the user is able to perform some searches for items to add. Once the items are selected, the user pressed a button on Page4. This button activates Page3.
In the Destroy of Page4, the records that were selected are processed and added to the views displayed on Page3.
The Save process is then called.
In the Save process, there is a Transaction.
When the End Transaction command is executed, the program calls the BeforeRowColChange event of the Grid on Page3 which in itself runs the Save routine again and also has some Requery() commands which cause Error #1593.

Does any one know why this is happening at the End Transaction command.

Thanks, David

 

[DSummZZZ]

Why do you fire the BeforeRowColChange manually within the save routine? Or am I missing something?
It sounds to me like you should really rethink the process. Make sure the data has all been saved, and the transaction 'END'ed before trying to requery the data.


-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[SSSMan]

Dave,

Sorry for the confusion, but the BeforeRowColChange is not called by the program but is triggered by something that I have not been able to trace.

When I have been tracing this step by step, as soon as the END TRANSACTION line is encountered, the BeforeRowColChange event is triggered.

Thanks, David.

 

[DSummZZZ]

Probably from the record pointer changing from the cursor being updated.
Maybe as a band-aid you can use TXNLEVEL( ) > 0 to test for being in the middle of a transaction.


-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm