On Oct 6, 1:23 pm, File <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've done this code:
>
> $db = Sequel.odbc('EmpyreanAge', :user => 'admin', :password =>
> 'password')
> #$db = Sequel.odbc('EmpyreanAge', :user => 'admin', :password =>
> 'password', :db_type => 'mssql')
> @sql = $db[:invTypes].sql
>
> At the end of it I get @sql = 'SELECT * FROM "INVTYPES"', which won't
> work in SQL Server 2005 (express edition) cause my table is invTypes
> and not INVTYPES. Is this a mssql server setting thing or is there a
> tweak I can use in Sequel so that :invTables == [invTables].I don't think that there is a setting for it yet. You can work around the issue by redefining quoted_identifier for the database not to call upcase. A patch that adds a Sequel::Database.upcase_identifiers= setting would be appreciated if you can find the time. Thanks, Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
