U++ framework: U++ SQL » questions about sqlArray

Home » U++ Library support » U++ SQL » questions about sqlArray

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: questions about sqlArray [message #35410 is a reply to message #35409]

Fri, 10 February 2012 18:59

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

BioBytes wrote on Fri, 10 February 2012 12:26

Hi papascalientes,

Mirek has given very good explanations as usual. Sure SqlArray can do some actions "magically" but cannot solve all your problems of errors that could happen in code. It is the way I go in my own applications.

The update, insert and delete operations are managed by SqlCtrls and generally, my application menu functions are written on the following basis:

void MainWin::DefineDevices()
{
	SQL.Begin();

	DevicesDlgWin.FillList(); 
        //Initialization of ctrls in the dialog window
	
	if(DevicesDlgWin.ExecuteOK())SQL.Commit();
	else SQL.Rollback();
}

So if the user presses ok (validation) button, the transaction is committed. If cancel button is pressed, modifications are not recorded in database.

Biobytes

BTW, this a bad practice. You should not use transactions whose length depends on user GUI interaction. Transactions should be short.

Report message to a moderator

[Message index]

		questions about sqlArray By: papascalientes on Thu, 09 February 2012 10:24
		Re: questions about sqlArray By: BioBytes on Fri, 10 February 2012 10:22
		Re: questions about sqlArray By: mirek on Fri, 10 February 2012 11:47
		Re: questions about sqlArray By: BioBytes on Fri, 10 February 2012 18:26
		Re: questions about sqlArray By: mirek on Fri, 10 February 2012 18:59
		Re: questions about sqlArray By: papascalientes on Fri, 10 February 2012 19:22
		Re: questions about sqlArray By: BioBytes on Sat, 11 February 2012 09:19
		Re: questions about sqlArray By: mirek on Sat, 11 February 2012 09:55
		Re: questions about sqlArray By: BioBytes on Sat, 11 February 2012 10:04

Previous Topic:	CLOB data handling
Next Topic:	Is it possible to call a stored procedure with an output parameter?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Oct 03 09:04:20 GMT+2 2026

Total time taken to generate the page: 0.14213 seconds