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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
