On 6/29/07, Michael Sharpe <msharpe at ucsd dot edu> wrote:
> You could say (this has always worked for me)
>
> >>>>> "SELECT myField FROM myTable WHERE myBooleanField"
>
> Then again, on my machine (same setup as yours), it also works to say
>
> >>>>> SELECT myField FROM myTable WHERE myBooleanField=1"
>
> and
> >>>>> SELECT myField FROM myTable WHERE myBooleanField='1'"
>
> Are you working with a database which may have been populated by an
> older version, where 'true' may have been used instead of '1'?
The database could have been created with RB 2007R2, but that is as
far back as it possibly could have gone.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
|