[FAQ] Help Please

[Ruslan Zasukhin]

On 3/23/04 7:07 AM, "Michael de Haan" <mdeh at comcast.net> wrote:

Hi Michael,

> Ruslan,
> 
> Is there any obvious reason to you why this syntax  is not working?
> 
> RecCount=myDB.sqlExecute(MySQL)
> 
> where MySQL  is:
> 
> "INSERT INTO iCpts ( cCode, cDesc, cVal ) VALUES (:1, :2, :3) binded
> with  { "12123","bu","23"}"

Yes. Must be:

    mySQL = "INSERT INTO iCpts ( cCode, cDesc, cVal ) VALUES (:1, :2, :3)"

And later, I assume you use V4RB:

dim Binds(-1) as String
Binds.append '12123'
Binds.append 'bu'  
Binds.append '23'  
    
    db.SqlExecute( mySQL, Binds )

I.e. Binds is true array of strings.


> and where
> 
> iCpts  is a table name
> 
> cCode, cDesc, cVal are the field description
> 
> 
> as in   .........
> 
> CodeC=new vString("cCode", 8)
> DescC=new vVarChar("cDesc", 504)
> cVal=new vString("cVal", 2)

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