[V4REV] problem with binded variables - SQL

[Ruslan Zasukhin]

On 11/7/08 4:37 AM, "David Simpson" <dsimpson at dotcomsolutionsinc.net> wrote:

Hi David,

I have correct this WIKI page. Please read it now.

And it points now, you need check
    V4REV/Examples/SQL/Binding


> When I use the following SQL code in Valentina Studio 3.52:
> 
> INSERT INTO tbl1 ( fldLong, fldString ) VALUES ( :1, :2 )
> binded WITH { "2", "NULL" };

Page was confusing.  Sql query must looks as
    INSERT INTO tbl1 ( fldLong, fldString ) VALUES ( :1, :2 )

Array of values you will prepare in send in REVOLUTION code.
 
> For this table:
> 
> CREATE TABLE "tbl1" (
> "fldLong" LONG  NOT NULL,
> "fldString" TEXT (512) );
> 
> I get this error on MacOS X, using Valentina Studio 3.52:
> 
> 17:10:55: Error: Kernel error: 0x71000. line 2:1: expecting EOF,
> found 'binded'
> 
> I picked a simple example for my testing, from this web page:
> http://www.valentina-db.com/dokuwiki/doku.php?
> id=paradigma:public:en:documentation:vsql:reference:insert
> 
> Any suggestions?
 
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]