U++ framework: U++ SQL » Call external funcions in SQL

Home » U++ Library support » U++ SQL » Call external funcions in SQL

Thu, 12 September 2013 20:29

Zbych
Messages: 332
Registered: July 2009

Senior Member

koldo wrote on Thu, 12 September 2013 18:37

SqlSelect sel = Select(SqlAll()).From(TABLE).Where(DATE < GetSysTime());
// .. and one hour later or in some function
SQL & sel;
SQL.Fetch();

If you do that, than the easiest way would be to either create the query each time just before executing.

or let database check current time for you:

Postgres:
SqlSelect sel = Select(SqlAll()).From(TABLE).Where(DATE < SqlTxt("NOW()");

		Call external funcions in SQL By: koldo on Thu, 12 September 2013 18:37
		Re: Call external funcions in SQL By: dolik.rce on Thu, 12 September 2013 19:23
		Re: Call external funcions in SQL By: mirek on Thu, 12 September 2013 20:19
		Re: Call external funcions in SQL By: Zbych on Thu, 12 September 2013 20:29
		Re: Call external funcions in SQL By: koldo on Thu, 12 September 2013 23:09
		Re: Call external funcions in SQL By: koldo on Fri, 13 September 2013 07:58
		Re: Call external funcions in SQL By: koldo on Fri, 13 September 2013 13:57
		Re: Call external funcions in SQL By: koldo on Mon, 30 September 2013 12:49

Previous Topic:	Added code to MySqlSession::DoConnect() correct?
Next Topic:	Strange build error with OleDB

Goto Forum:

] [

]

Current Time: Sun Nov 01 01:57:47 GMT+1 2026

Total time taken to generate the page: 0.00812 seconds