On Aug 27, 4:11 pm, ChilliCoder <[email protected]> wrote: > Hi list, > > I'm working with Sequel in Ruby 1.8.6 and MS SQL Server 2000 and now I > face a problem. > > The database I'm accesing has collation set to Latin1 with case > sensitive and the tables are named on lowercase so when Sequel > generates SQL statements they generated all in upper case and then SQL > Server responds with error messages as 'Invalid object name: > CATALOGO_PRESUPUESTOS' because the table is named > 'catalogo_presupuestos'. > > The SQL generated is > SELECT * FROM [CATALOGO_PRESUPUESTOS] WHERE ([IS_ACTIVE] = 1) ORDER BY > [CENTRO_COSTOS], [CUENTA] > > And I need > SELECT * FROM [catalogo_presupuestos] WHERE ([is_active] = 1) ORDER BY > [centro_costos], [cuenta] > > I've read the Sequel::Dataset documentation but found no hint on how > change this. > > Any idea? Is there something missing?
You want to do: DB.identifier_input_method = nil DB.identifier_output_method = nil That will ensure that Sequel doesn't modify the identifiers you use. 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 -~----------~----~----~----~------~----~------~--~---
