[Gambas-user] Problems in the database component design

[admin at ...1080...]

Hi

What i know is that MySql and MS Sql Server are case sensitive for table 
names but not field names. I think this is OK as standard. And the 
sensitivity  has nothing to to with vb-newbies but with Sql.

Werner


Benoit Minisini wrote:
> 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?
>
>