[thelist] Boolean and asp and access

[Ken Schaefer]

All we are doing is passing a literal string (which happens to be an SQL
Statement) to Access. It is Access (or rather the Jet engine) which parses
the SQL statement, and works out what things mean what. So:

strSQL = "UPDATE myTable SET myField = True WHERE PrimaryKey = 1"

will always work. As far as VBScript is concerned, there's just a literal
string of text.

This is different to using keywords in some client language (such as
VBScript).

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Christopher Mahan" <chris_mahan at yahoo.com>
Subject: Re: [thelist] Boolean and asp and access


:
: --- Ken Schaefer <ken at adOpenStatic.com> wrote:
:
: > You can use "True" and "False". No need to remember what the values
: > are per
: > se.
:
: Yes, assuming the client language supports bool type.
: in access,
:
: True is -1 and false is 0 by default (don't know if these can be
: changed in database settings)
:
: But, like Ken said, it's better to use the bool True and False. (They
: don't have to be capitalized either.)
:
: =====
: Christopher Mahan