U++ framework: Newbie corner » Getting the SQL statement without execute it

Home » Community » Newbie corner » Getting the SQL statement without execute it

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

Getting the SQL statement without execute it [message #50661]

Fri, 30 November 2018 12:49

Giorgio
Messages: 218
Registered: August 2015

Experienced Member

Hi there,
is there a way to getting the SQL statement upp is going to issue, without actually execute it?

For example the following code will produce (in PostgreSQL) the SQL statement "insert into PERSONS(NAME, SURNAME) values ('John', 'Doe')" and will execute the query:

try {
      SQL & Insert(PERSONS)
            (NAME, "John")
            (SURNAME, "Doe");
} catch(SqlExc) {
      ErrorOK(t_("Failed adding data to the database due to the following error: ") + SQL.GetLastError());
}

What I would like to have is a way to have the statement "insert into PERSONS(NAME, SURNAME) values ('John', 'Doe')" in a string variable, without actually executing it (so I will not find a new record in the db); is there a way to achieve this?

Thanks,
gio

Report message to a moderator

[Message index]

		Getting the SQL statement without execute it By: Giorgio on Fri, 30 November 2018 12:49
		Re: Getting the SQL statement without execute it By: sduensin on Wed, 28 August 2024 23:58

Previous Topic:	Immediately refresh a control?
Next Topic:	OK and Cancel Layout

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 25 14:55:04 GMT+2 2026

Total time taken to generate the page: 0.00980 seconds