From: JZ <usenet@...>
Date: 2005-07-21T22:10:56+09:00
Subject: [RoR] mssql adapter and set_primary_key problem

For mssql adapter I cannot change primary key. The following code does not
work :(

class Demo < ActiveRecord::Base
  set_table_name "MojaTabela"
  set_primary_key "IdMojejTabeli"
end

Execute
    OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server
      Invalid column name 'id'.
    HRESULT error code:0x80020009
      Exception.: SELECT * FROM ( SELECT TOP 9 * FROM ( SELECT TOP 9 * FROM 
MojaTabela  ) AS tmp1 ORDER BY id DESC ) AS tmp2 ORDER BY id ASC

The error exception appears for mode ADO and for mode ODBC. Something wrong
is here. I tried to ask on irc rubyonrails channel but nobody said any
word. Mysql adapter works fine. Only mssql adapter has problem.

--
JZ