Re: [Lazarus] SQLTransaction: Operation cannot be performed on an active transaction

2013-06-06 Thread Antonio Fortuny
Hi all, I tried reviewed the code and commented the try...except statement for more debug: procedure TfrmMainWindow.bitBtn1Click(Sender: TObject); begin //try DataModuleConn.openConnection;

Re: [Lazarus] SQLTransaction: Operation cannot be performed on an active transaction

2013-06-06 Thread Eric Kom
On 06/06/2013 15:17, Antonio Fortuny wrote: Hi all, I tried reviewed the code and commented the try...except statement for more debug: procedure TfrmMainWindow.bitBtn1Click(Sender: TObject); begin

Re: [Lazarus] SQLTransaction: Operation cannot be performed on an active transaction

2013-06-06 Thread Eric Kom
On 06/06/2013 16:01, Eric Kom wrote: On 06/06/2013 15:17, Antonio Fortuny wrote: Hi all, I tried reviewed the code and commented the try...except statement for more debug:

[Lazarus] SQLTransaction: Operation cannot be performed on an active transaction

2013-06-04 Thread Eric Kom
Good day all; I am trying to set the Active property of TSQLTransaction to False so that I can avoid the above Read Error message: SQLTransaction: Operation cannot be performed on an active transaction The True value is currently set to True. -- Kind Regards Eric Kom System Administrator

Re: [Lazarus] SQLTransaction: Operation cannot be performed on an active transaction

2013-06-04 Thread Antonio Fortuny
Le 04/06/2013 09:56, Eric Kom a écrit : Good day all; I am trying to set the Active property of TSQLTransaction to False so that I can avoid the above Read Error message: SQLTransaction: Operation cannot be performed on an active transaction The True value is currently set to True. Try

Re: [Lazarus] SQLTransaction: Operation cannot be performed on an active transaction

2013-06-04 Thread Eric Kom
On 04/06/2013 10:19, Antonio Fortuny wrote: Le 04/06/2013 09:56, Eric Kom a écrit : Good day all; I am trying to set the Active property of TSQLTransaction to False so that I can avoid the above Read Error message: SQLTransaction: Operation cannot be performed on an active transaction The

Re: [Lazarus] SQLTransaction: Operation cannot be performed on an active transaction

2013-06-04 Thread Antonio Fortuny
Le 04/06/2013 16:54, Eric Kom a écrit : On 04/06/2013 10:19, Antonio Fortuny wrote: Thanks, I did changed to Commit and then caNone before it solved the error, another error message pop up saying Access Violation. Anyway, the problem was solved. The above code its giving me a problem; the