3 Replies Latest reply on Oct 20, 2013 11:33 PM by Kutir Mobility

    Fixed Schema sql query

    Alexey Mironov

      Hi,

      I have some FixedSchema model -

       

      class TsdInventtable

        include Rhom::FixedSchema#PropertyBag

       

        # Uncomment the following line to enable sync with TsdInventtable.

         enable :sync

        #enable :pass_through

        #add model specifc code here

        set :sync_type, :bulk_only

        

        property :ItemId, :string[20]

        property :ItemName, :string[140]

        property :VendId, :string[20]

        property :VendName, :string[140]  

           

      end

       

      and try to exec this code -

       

       

      db = ::Rho::RHO.get_src_db('TsdInventtable')

      db.execute_sql("select * from TsdInventtable")

       

      but it is not work. I use RhoStudio 2.0

      Single -

       

      db = ::Rho::RHO.get_src_db('TsdInventtable')

       

      work well.... What the problem?