Sending a SQL statement with parameters

[Ruslan Zasukhin]

On 13/3/07 8:28 AM, "Keith Hutchison" <keith.kjtl.hutchison at gmail.com>
wrote:

Hi Keith,

> Someone has asked me how to send in a SQL statement using parameters...

> I don't normally do that :-( I normally create a query object, pass in
> some parameters, let the query object sort it the correct SQL syntax
> and execute the SQL.
> 
> Any examples of how to compose a straight SQL statement that won't
> work unless the engine recognises the parameters ?

Do you ask about SQL Binding?

Something as 

    INSERT INTO T1(f1,f2) VALUES(:1, :2)

?

Each ADK have 
        Example/SQL_way/SQL_Binding


In WIKI also present some general info about this.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]