U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » sql session in a global variable?

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

Return to the default flat view

Create a new topic

Submit Reply

Re: sql session in a global variable? [message #34839 is a reply to message #34831]

Wed, 14 December 2011 10:29

mr_ped is currently offline

mr_ped
Messages: 826
Registered: November 2005
Location: Czech Republic - Praha

Experienced Contributor

Didn't try the sources, so just by quick reading it...

The "sql" in connect procedure is local variable, so it gets destroyed once it gets out of scope. I'm afraid this is making it's content invalid. The assignment to "sqlPointer", unless the Sql class has very clever copy constructor, will not help to preserve it. I'm too lazy to check actual Sql source, sorry. Wink

Wink

Anyway, I don't like the "sqlPointer" variable name, because it is not pointer, but an object, so the variable name is misleading.

I would suggest to completely remove sqlPointer class member variable, and create new instance of Sql every time you need it.

See http://www.ultimatepp.org/srcdoc$Sql$tutorial$en-us.html , especially step 2 may help you. After you set global "SQL", you can then get new instance by simple "Sql sql;" in your code.

Report message to a moderator

Send a private message to this user

[Message index]

		sql session in a global variable? By: Wolfgang on Tue, 13 December 2011 22:55
		Re: sql session in a global variable? By: mr_ped on Wed, 14 December 2011 10:29
		Re: sql session in a global variable? By: Wolfgang on Wed, 14 December 2011 10:33
		Re: sql session in a global variable? By: mr_ped on Wed, 14 December 2011 11:03
		Re: sql session in a global variable? By: mirek on Thu, 15 December 2011 08:29
		Re: sql session in a global variable? By: Wolfgang on Thu, 15 December 2011 09:51
		Re: sql session in a global variable? By: mirek on Thu, 15 December 2011 11:23
		Re: sql session in a global variable? By: Wolfgang on Thu, 15 December 2011 11:26
		Re: sql session in a global variable? By: mirek on Thu, 15 December 2011 11:56
		Re: sql session in a global variable? By: Alboni on Thu, 12 September 2013 22:14
		Re: sql session in a global variable? By: coolman on Fri, 12 June 2020 22:41
		Re: sql session in a global variable? By: mirek on Sun, 14 June 2020 10:18
		Re: sql session in a global variable? By: Wolfgang on Thu, 15 December 2011 11:58
		Re: sql session in a global variable? By: mirek on Thu, 15 December 2011 12:49

Previous Topic:	Schema files, layouts
Next Topic:	SqlArray with an Option

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sat May 10 21:12:42 CEST 2025

Total time taken to generate the page: 0.03516 seconds