Building and executing a SQL Statement

NOSPAM.gz...@technologist.com (George M. Zouganelis)

Delphi Developer

Sun, 11 Jul 2004 01:02:05 GMT

Building and executing a SQL Statement

Greetings.

I would like to ask, if there is any way to build a
SQL statement inside a stored proc and execute it.

for example , can this pseudocode be developed:

tmpSQL = 'INSERT INTO TMP_TABLE SELECT COL1, COL2 FROM aTABLE '
:
{block of WHERE Clause building}
:
tmpSQL = tmpSQL || tmpWHEREClause

execute tmpSQL

{continue working with TMP_TABLE}

t.i.a.

TMW

Delphi Developer

Sun, 11 Jul 2004 01:20:31 GMT

Re:Building and executing a SQL Statement

"George M. Zouganelis" <NOSPAM.gz...@technologist.com> wrote in
message news:3c4d92ac.5528317@forums.inprise.com...

Quote

> Greetings.

> I would like to ask, if there is any way to build a
> SQL statement inside a stored proc and execute it.

No. Stored procedures are pre-compiled in Interbase so dynamic
generation isn't possible at this time.

Woody

Team

Delphi Developer

Sun, 11 Jul 2004 02:59:58 GMT

Re:Building and executing a SQL Statement

No. Stored procs are compiled when they are created so you cannot create SQL
dynamically.

--
Bill
(TeamB cannot answer questions received via email)

"George M. Zouganelis" <NOSPAM.gz...@technologist.com> wrote in message
news:3c4d92ac.5528317@forums.inprise.com...

Quote

> Greetings.

> I would like to ask, if there is any way to build a
> SQL statement inside a stored proc and execute it.

> for example , can this pseudocode be developed:

> tmpSQL = 'INSERT INTO TMP_TABLE SELECT COL1, COL2 FROM aTABLE '
> :
> {block of WHERE Clause building}
> :
> tmpSQL = tmpSQL || tmpWHEREClause

> execute tmpSQL

> {continue working with TMP_TABLE}

> t.i.a.

Martijn Tonie

Delphi Developer

Sun, 11 Jul 2004 04:16:21 GMT

Re:Building and executing a SQL Statement

Currently, no.

If you're using the open source version, you might want to take a look at
Firebird, the open source code fork ( www.firebirdsql.org ) -- something
like this is supported in there... Or at least, people have been/are working
on it...

--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

"George M. Zouganelis" <NOSPAM.gz...@technologist.com> wrote in message
news:3c4d92ac.5528317@forums.inprise.com...

Quote

> Greetings.

> I would like to ask, if there is any way to build a
> SQL statement inside a stored proc and execute it.

> for example , can this pseudocode be developed:

> tmpSQL = 'INSERT INTO TMP_TABLE SELECT COL1, COL2 FROM aTABLE '
> :
> {block of WHERE Clause building}
> :
> tmpSQL = tmpSQL || tmpWHEREClause

> execute tmpSQL

> {continue working with TMP_TABLE}

> t.i.a.

George M. Zouganel

Delphi Developer

Wed, 21 Jul 2004 09:15:40 GMT

Re:Building and executing a SQL Statement

many thanks you for your answers.
'hope for a better future :)

Other Threads

1. SQL statement vs Delphi Code: Which is executes fastest

2. execute SQL statement

3. Problem with strings building SQL statement

4. Several SQL Statements In one TADOConnection.Execute

5. Executing SQL-Statements serial

6. Access violation executing a Sql statement

7. re-executing the sql-statement

8. Retrieve SQL Statement after execute

9. Tool for building SQL statements

10. Executing Select stored procedures in a SQL statement