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? Regards, Martín Trejo Chávez --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
