problem with binded variables - SQL and Revolution

David Simpson dsimpson at dotcomsolutionsinc.net
Thu Nov 6 20:37:40 CST 2008


When I use the following SQL code in Valentina Studio 3.52:

INSERT INTO tbl1 ( fldLong, fldString ) VALUES ( :1, :2 )
binded WITH { "2", "NULL" };

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?

David Simpson
www.fmpromigrator.com





More information about the Valentina mailing list