G. Roderick Singleton wrote:
On Sat, 2005-10-29 at 10:48 +0200, G Stansfield wrote:
Greetings!
I have downloaded OOo_2.0.0_Win32Intel_install.exe & installed on a Win
2000 Pro machine. I have checked the MD5sum and that is fine.
I was doing very well converting tables & data from an Access database
and raising queries - till I tried including fields where the Field Type
is set to Yes/No [BOOLEAN].
Use "Wizard to create Query", select the required table and those fields
with File Type set to Yes/No [BOOLEAN] are not on the list of Available
Fields.
Use "Create Query in Design View", select the required table and the
fields with File Type set to Yes/No [BOOLEAN] are available for
selection - but I can't find a criterion that works [Yes, "Yes", 1 don't
work, to list a few I have tried].
What am I doing wrong / missing? Something outside OO - like service
pack versions?
My understanding is that Yes/No are only valid in dBase files and
nothing else. What is valid is SQL TRUE and FALSE in most others. All
are boolean but ...
Thanks for the reply, Roderick, which has allowed me to get things
working - sort-of.
For the record & the list, these examples work :
SELECT "id", "fred", "george", "flag" FROM "Table1" "Table1" WHERE ( (
"flag" = False ) )
SELECT "id", "fred", "george", "flag" FROM "Table1" "Table1" WHERE ( (
"flag" = True ) )
but I can only enter/modify the WHERE clause in SQL view mode. That
done, I can toggle design view on/off - and see FALSE (or TRUE) in the
criterion field, but if I edit the criterion I get "Warning. Syntax
error in SQL statement" and the query will not parse/run/save.
This behaviour also confirmed on a Win NT4 SP6a platform.
Regards,
Geoff
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
