On 6/29/07, keatk at comcast dot net <keatk at comcast dot net> wrote:
> I create the table in the IDE, use DatabaseRecord to create new records and
> RecordSet to modify them istead of raw SQL and DB.SQLExecute. With all that,
> selects using 0 and 1's for booleans work fine.
>
> -------------- Original message --------------
> From: "Dennis Birch" <dennisbirch at gmail dot com>
>
> > On 6/28/07, Karen wrote:
> > >
> > > On Jun 29, 2007, at 1:01 AM, Dennis Birch wrote:
> > >
> > > > "SELECT myField FROM myTable WHERE myBooleanField = 1"
> > >
> > > 1 and 0 work for me for true and false just fine.
> >
> > They clearly do not work for me. Can you describe your setup in more
> > detail? Perhaps I'm doing something wrong with the way I create the
> > table or populate the records.
I create my tables in code, and do everything else the same as you
described. What RB version and OS are you working in? I'm running into
this problem with RB 2007R3 in Mac OS 10.4.10.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
|