On Tue, 2012-03-20 at 14:33 +0000, Mark Stanton wrote:
> Thanks Dan & Jean-Francois,
>
> Got to use double quotes? Whose idea was that? :-S Mutter mutter
> mutter, yup that works :-(
>
> All working now! We'll find out how good it is next week when it
> gets used in the production run! :-)
>
> Thanks again
> Mark Stanton
> One small step for mankind...
Further update from personal testing: I opened a database in LO that
I use for education purposes. I created a table (TEST_DV) using Design
View with 3 fields; created a second table (TEST_SQL) using Tools > SQL
using a CREATE TABLE statement. Closed the db, renamed it to have a .zip
extension, and looked at the Script file inside the database folder
which was inside the zip file.
What I discovered was: TEST_DV (name of the table and its fields
were all contained in double quotes using the case for each letter of
these names); TEST_DV (name of table and its fields were all caps but no
quotes).
My conclusion: If you use Design View to create a table, you will
have to use double quotes for the names of your tables and fields; use
SQL statements to create tables, and you don't have to use quotes (just
all caps).
What I have not tested: modifying the Script file to remove the
quotes around these names while making the names all caps. {Someone else
will get this privilege.} Besides, I don't know if it would be worth the
time to do it.
--Dan
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
