V4REV update -- SQL binding.

[Ruslan Zasukhin]

On 9/2/05 5:31 PM, "Trevor DeVore" <lists at mangomultimedia.com> wrote:

>>> OK.  Does Val 2.x support binding?  I know in 1.x binding was
>>> supported in RB but not in Rev.  If it is supported in 2.x it would
>>> be nice if support for this was available in Rev.
>>> 
>> 
>> Please clarify what binding you mean:
>>     SQL binding:        WHERE f1 = :1 and f2 = :2
>> Or
>>     binding to GUI controls
>> 
>> ?
> 
> Ruslan,
> 
> I was thinking about SQL binding.  You should be able to bind using
> variable length parameters:
> 
> get V_SomeFunction(dbref, "SELECT * WHERE ID = :1 AND ID2 = :2",
> tID2, tID2)

Yes we can do this
 
> OR using an array which is indexed from 1 to then number of variables
> to bind to.
> 
> put "someValue" into tArrayA[1]
> put "someOtherValue" into tArrayA[2]
> 
> get V_SomeFunction(dbref, "SELECT * WHERE ID = :1 AND ID2 = :2",
> tArrayA)

I think we use Arrays.

Ivan ?


-- 
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]