Syntax to insert a boolean

[Ruslan Zasukhin]

on 1/7/04 7:12 AM, chuck hinkle at chuckbo at hinkles.us wrote:

Hi Chuck,

> I know there's probably an example for this, but I'm off to bed and am too
> tired to hunt it down tonight.
> 
> Let's say I have a table with a vboolean field in it. (Call is isBold)
> And, I have an RB variable defined as a boolean. (Call it isBold)
> 
> 
> I'm building an SQL insert statement and I'm not sure how to do that. That
> is:
> 
> 
> dim isBold as boolean
> dim SQL as string
> dim vCur as vCursor
> dim Label as string
> dim Label_size as integer
> dim Record_count as integer
> 
> SQL = "Insert into Labels (Label_name, Label_size, isBold) Values ("
> SQL = SQL + "'" + ValentinaEscapeString(Label, False) + "', "
> SQL = SQL + str(Label_size) + ", "
> SQL = SQL + ??????                           <<< -- what goes here?
> SQL = SQL + ");"

            TRUE FALSE
            1 0 
       
> Record_count = app.myDB.sqlexecute(SQL)

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