On Sat, 2006-07-29 at 10:05 -0600, John Batt wrote:
> My wife has a jewelry making business and I use Base ver 2.0.3 to keep
> track of her bead inventory. The database fields are color, reorder
> number, 3 check boxes for bead type called Dynamite Delica and Ornela,
> and color number
> (called DB#). Monthly I run queries and reports. I recently tried to
> query using the following which comes from the overview section using
> the wizard:
>
> /Fields in the Query: FMG.Color (FMG.Color), FMG.reorder (FMG.reorder),
> FMG.Delica (FMG.Delica), FMG.DB# (FMG.DB#)
>
> Sorting order: FMG.Color (ASC)
>
> Search conditions:
>
> No Groups were assigned.
>
> No grouping conditions were assigned./
>
> This query is designed to show all beads of type Delica sorted
> (ascending) by their DB numbers. The search conditions were Delica =
> true. This search condition is missing from the overview. When I
> click on finish to run the query I get the following error:
>
> /SQL Status: HY000
> Error code: 1000
>
> Syntax error in SQL expression
>
> SELECT "FMG"."Color", "FMG"."reorder", "FMG"."Delica", "FMG"."DB#" FROM
> "FMG" "FMG" WHERE ("FMG"."Delica" = )/
>
> You will notice that it says "WHERE ("FMG"."Delica" = )" the search
> criteria "true" is missing. It would seem that doing searches on
> Boolean fields is not permitted under 2.0.3 since I can search all other
> fields in the database with no problem. The problem is not local to
> this database either, I setup the Recipe database, entered several
> recipes two of which were marked vegetarian, and constructed a query to
> search for recipes of type vegetarian (also Boolean) and got the same
> results. Neither is it local to using the wizard to create queries, the
> same thing happens using design view. I can enter any search condition
> in the criterion field EXCEPT = true or = false. My question, How do I
> get around this problem
>
> John Batt
>
Since you also posted this question to [email protected], I
suggest that you look there for answers.
I'm sorry I didn't realize cross-posting to other OOo groups to maximize
my chances of getting help was not allowed.
John
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
