[Gambas-user] Problems in the database component design

[Rob]

On Saturday 18 August 2007, Benoit Minisini wrote:
> 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.

Case sensitive meaning keywords will have to be upper case?  I would 
actually have to fork gb.db for my clients if you did that.  

If you're talking about enforcing case sensitivity in field names, it 
would still cause problems in a lot of existing code written by ex-VB 
users, but maybe I'd just never update those projects to gambas2.  I 
don't think that's what you're talking about, though, since you 
mention problems with creating tables.

Any way you look at it, I think that imposing case sensitivity on a 
case-insensitive language like SQL would be a design flaw.  If you do 
feel you have to implement this, could you make a new property called 
something like "passthru" so we can send our unmodified queries 
through to MySQL or whatever the target database engine is?

Rob