search for: sql92

Hello, I''m wondering if there is any plan to leverage SQL92 INFORMATION_SCHEMA in ActiveRecord? In a nutshell, INFORMATION_SCHEMA provides the meta information necessary to automatically discover all the associations between objects (primary and foreign keys, has_many, has_one and belongs_to, etc). Most relational databases do support this SQL92 s...

For some reason, rails is generating this SQL: SELECT FIRST 1 * FROM questions WHERE (parent_id IS NULL) ORDER BY position DESC 1. There is no column named position referenced in my code. 2. POSITION is a reserved word in SQL92. It is the name of a string function that returns the offset of one string within another. I believe that this is a bug in Rails. Either position should be quoted or the property it is trying to use should be renamed since no SQL92 compliant database would honor this query (DB2, Oracle, postgre...

Every now and then when I am working on making the SQL Server adapter pass all the ActiveRecord tests, I notice one that looks like a false positive in the core DBs. Here is one case in relations_test.rb. Can someone look at this and just tell me it is normal for other DBs and just odd for SQL Server? Or maybe it is just my understand of some SQL standard. I''m really not that SQL smart.

Hi, Is anyone using Oracle with RoR successfully? Is everything running smoothly? What are the main issues? any response is appreciated thanks, Chris -- Posted via http://www.ruby-forum.com/.

Hi, How would you order the results of a complex aggregation using ''calculate'' (from ActiveRecord::Calculations::ClassMethod)? I have a "legacy" table from which I would like to retrieve some aggregated data, with an ordering. Something like: Entry.calculate(''avg'', ''thevalue'', { :order=> ''avg_thevalue DESC'' })

...atabase extensively during the time I was programming in REALbasic, and I can honestly say it burns just about anything out there when it comes to speed. Don''t let the fact that it''s not so widely known hold you back. Its object-relational nature (besides being able to use SQL92) makes it stand out between everything else I''ve seen and is perfect for Rails integration. For the record, I have no affiliation with this company whatsoever, I just like their product a lot :-) Some information extracted from the site (you can find all other information at http:...

R-help users, Thanks in advance for any assistance ... I truly appreciate your expertise. I searched help and could not figure this out, and think you can probably offer some helpful tips. I apologize if I missed something, which I'm sure I probably did. I have data for many "samples". (e.g. 1950, 1951, 1952, etc.) For each "sample", I have many data-frames.

Hello. Where is there an Agile Messageboard? On the first part of the Depot example, a price field shouldn''t be an integer right? (it should be more of a float since a price has decimals) Dominic Son -- Posted via http://www.ruby-forum.com/.

Dear all, I have some problems with importing data from an Access data base via RODBC to R. The data base contains several tables, which all are imported consecutively. One table has a column with column name "NO". If I run the code attached on the bottom of the mail I get no complain, but the column name (name of the respective vector of the data.frame) is "Expr1014" instead

I sure hope so: http://duckdown.blogspot.com/2006/03/additional-thoughts-on-why-ruby-isnt.html Seems like it''s getting genuine rebuttals, though. It''s actually kind of amusing.