[Gambas-user] RE: Database Field Names

[Benoit Minisini]

On Wednesday 19 April 2006 09:55, Timothy Marshal-Nichols wrote:
> Thanks. I was a bit annoyed when I sent that email. I have charmed down
> now.
>
> First thoughts. How about:
>
> 1.	Send the field name to the database in the case entered by the user.
> 2.	Before the field name is sent to the database check the name is unique
> in the table with a case insensitive test. Do not allow field names that
> fail the case insensitive test.
>
> Thanks
>
> 8-{)} Timothy Marshal-Nichols
> <mailto: timothy.marshal-nichols at ...247...>
>

Maybe this is the better idea. 

It seems that there is a syntax to force 'case insensitiveness', but, of 
course, it is not standard, and I'm not sure all DBMS have it.

Regards,

-- 
Benoit Minisini