U++ framework: U++ TheIDE and Library: Releases and ChangeLogs

Home » Developing U++ » U++ TheIDE and Library: Releases and ChangeLogs » SQLApp example...

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

SQLApp example... [message #5360]

Fri, 15 September 2006 22:50

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

Quite complex, therefore I am posting it here for review. (There were requests for this).

BTW, it crashes at the end because there is bug in Sqlite3 plugin when you use global SQL. I will fix that soon.

Report message to a moderator

Re: SQLApp example... [message #5363 is a reply to message #5360]

Sat, 16 September 2006 01:06

zsolt
Messages: 702
Registered: December 2005
Location: Budapest, Hungary

Contributor

Cool, but in book.cpp this would be better:

void SQLApp::EditBook()
{
	if(!book.IsCursor())
		return;
	BookDlg dlg;
	int q = book.GetKey();
	SQL * Select(dlg.ctrls).From(BOOK).Where(ID == q);
	if(!dlg.ctrls.Fetch(SQL))
		return;
	if(dlg.Run() != IDOK)
		return;
	SQL * dlg.ctrls.Update(BOOK).Where(ID == q);
	Query(q);
}

Report message to a moderator

Re: SQLApp example... [message #5365 is a reply to message #5363]

Sat, 16 September 2006 08:49

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

zsolt wrote on Fri, 15 September 2006 19:06

Cool, but in book.cpp this would be better:

void SQLApp::EditBook()
{
	if(!book.IsCursor())
		return;
	BookDlg dlg;
	int q = book.GetKey();
	SQL * Select(dlg.ctrls).From(BOOK).Where(ID == q);
	if(!dlg.ctrls.Fetch(SQL))
		return;
	if(dlg.Run() != IDOK)
		return;
	SQL * dlg.ctrls.Update(BOOK).Where(ID == q);
	Query(q);
}

Ooops, thanks Smile

Mirek

Report message to a moderator

Previous Topic:	SqlExp deeply refactored
Next Topic:	SQLite and Sql changes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon May 04 17:26:24 GMT+2 2026

Total time taken to generate the page: 0.00411 seconds