[Gambas-user] Problems in the database component design

[Gareth Bult]

If you enclose the field names (in MySQL) with `` characters, you can anything as a field name.

(and MySQL field names are case sensitive so auto-conversion would be bad)

----- Original Message -----
From: "Benoit Minisini" <gambas at ...1...>
To: gambas-user at lists.sourceforge.net
Sent: Saturday, August 18, 2007 9:52:13 PM (GMT) Europe/London
Subject: [Gambas-user] Problems in the database component design

Hi, everyone.

I designed the database component with the idea of having table and field name 
case unsensitive.

Of course, alas not all database systems deal the same way with that, and so I 
decided to systematically convert field and table names to lower case before 
sending them to the drivers.

But there are problems yet. 

The last one detected by Fabien Bodard is that you can't use SQL keywords as 
field names when creating a table.

So I think I will switch to a case sensitive design. It will make things 
harder for old VB newbies, but a cleaner design is better.

What do you think about that?

-- 
Benoit Minisini

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Gambas-user mailing list
Gambas-user at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user