[Gambas-user] Big change in database component

[timothy]

> -----Original Message-----
> From: gambas-user-bounces at lists.sourceforge.net 
> [mailto:gambas-user-bounces at lists.sourceforge.net] On Behalf 
> Of Benoit Minisini
> Sent: Tuesday, 11 September 2007 07:49 PM
> To: gambas-user at lists.sourceforge.net
> Subject: [Gambas-user] Big change in database component
> 
> 
> Hi,
> 
> The database component is now case sensitive, i.e. table 
> names, field names 
> and index names are now all case sensitive.
> 
> This should fix indirectly many problems:
> * A field, index or table name can be a SQL reserved word.
> * Field names that mix upper case and lower case are 
> displayed 'as is'.
> * The behaviour should be more consistent across all database drivers.
> 
> I tried to make it optional, but there are too many 
> differences in the 
> behaviour of all databases to do that reliably.
> 
> So, by using SQL quoting in all requests, case sensitivity is 
> now forced.
> 
> It is yet possible to have the dbResult["field"] syntax case 
> unsensitive. Tell 
> me if you find that useful.
> 
> And of course, tell me if you encounter any problem with your 
> own databases, 
> as this is only tested on my local machine!
> 
> Regards,
> 
> -- 
> Benoit Minisini
> 

I do think this is a more practical way of interfacing to a database.
(Even if it does not comply with SQL standards ;-)

Thanks

8-{)} Timothy Marshal-Nichols
<mailto: timothy.marshal-nichols at ...247...>