Thank you. It worked perfectly!
On Aug 28, 9:17 am, Jeremy Evans <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
