Help Again Please

[Ruslan Zasukhin]

On 3/24/04 5:56 AM, "Michael de Haan" <mdeh at earthlink.net> wrote:

Hi Michael,

> 2)
> 
> 
> Please help with the line;
> 
> db.SqlExecute( mySQL, Binds )
> 
> In the ref (VALENTINA for REALbasic Reference), this is shown as:
> 
> SQLExecute( Query as String, [Binds() as String] ) as Integer.
> 
> When I try and write the line "db.SqlExecute( mySQL, Binds )" it will
> not execute unless it is written as a function that returns an integer,

Right, because REALBasic always require assign result of function to some
variable.

> (that is the error message generated if no integer variable is
> supplied)

> as in RecCount=db.SqlExecute( mySQL, Binds ).
> 
> 
> 
> So, what does compile, but still does not work is the following:
> 
> RecCount=myDB.sqlExecute(mySqL, theArray)
> 
> where mySqL is
> 
> "INSERT INTO iCpts ( cCode, cDesc, cVal ) VALUES (:1, :2, :3)"
> 
> and theArray is
> 
> 0    '12123'
> 1     'bu'
> 
> etc etc
> 
> 
> I have tried :
> 
> -- changing the values of VALUES to :0 etc :1 etc
> -- removing the double quotations on either end of the mySqL string
> 
> Not sure what to try next?

well, please try to find example in our EXAMPLE or TEST projects.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------