Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » questions about sqlArray
Re: questions about sqlArray [message #35409 is a reply to message #35401] Fri, 10 February 2012 18:26 Go to previous messageGo to previous message
BioBytes is currently offline  BioBytes
Messages: 310
Registered: October 2008
Location: France
Senior Member
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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: CLOB data handling
Next Topic: Is it possible to call a stored procedure with an output parameter?
Goto Forum:
  


Current Time: Wed Aug 27 00:54:17 CEST 2025

Total time taken to generate the page: 0.05278 seconds