Andreschrosa Posted October 28, 2008 Share Posted October 28, 2008 I'm making a history page in my application, which will allow the user to set a starting and ending date for a given equipment, and display the data stored in the sql database by that equipment. I'm not sure the sql query is working (as I cant seen to get results from the querytoclass function, possibly I'm using it wrong). It also dosent display on the table. How you add various rows in the table component with a addcolumn command? private handle global string sql private result handle = DB.Open("DSLeituras","powerview","pwv") sql = 'Select Thetime, Vm from Leituras order by Thetime' //result = db.Query(handle, sql) result = DB.QueryToClass(handle, sql, 'result') //? result.Vm page.Historico.Component.tabelahistorico.ClearColumns() //page.Historico.Component.tabelahistorico.AddColumn(formatdatetime(%c, result.Thetime), 'Data') page.Historico.Component.tabelahistorico.AddColumn(result.Vm,'Vm') DB.Close(handle) Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.