Binding with UPDATE

Deane Venske dean at eduss.com
Thu Oct 16 22:14:05 CDT 2003


Ruslan Zasukhin wrote:

>on 10/16/03 7:44, Deane Venske at dean at eduss.com wrote:
>
>  
>
>>It's always scary when you start replying to your own emails... kind of
>>like talking to one's self :P
>>
>>I've noticed that SELECT has no binding either. That's probably why
>>there is no binding for WHERE clauses. I'd love to be able to use
>>Binding throughout an SQL query because I do believe it would make
>>writing Valentina code quicker and easier.
>>    
>>
>
>Correct.
>
>Binding was added only into INSERT, UPDATE, DELETE (not in part WHERE)
>
>Yes I agree that it will be cool provide binding params in any place of SQL
>query. We have not this yet in SQL parser of 2.0. But I think we will add
>it.  
>
>Also by standard must be used simply '?' in place of bind param.
>Not :1 as we use now (this syntax is from Oracle I think).
>
>I don't know if we will be able preserve :1 syntax in 2.0.
>If not then you will need update your sources to replace :1 on ?
>
>  
>
That wont be a problem at all using '?', looking very much forward to 
version 2.0 Ruslan :D
Thanks for the response and looking forward to binding for WHERE and SELECT.

Thanks,
Deane



More information about the Valentina mailing list