It do that: sResult = DB.Edit("inventory", id = &1, ID) sResult!id = ID 'sResult!location = TableView1.Columns[1]. * sResult!location = TableView1[TableView1.Row, 1].Text* sResult.Update
2012/9/28 rocko <sunblast...@gmail.com> > I'm using a Table view to view data from an SQLite database. > I would use a dataview but I only need to display some database fields > not all of them. > > This is the code I have so far: > Public Sub Form_Open() > > Dim sResult As Result > Dim id As Integer > > TableView1.Columns.Count = 3 > TableView1.Rows.Count = 10 > > TableView1.Columns[0].Title = ("ID") > TableView1.Columns[0].Width = (TableView1.Width / 10) * 2 > TableView1.Columns[1].Title = ("Location") > TableView1.Columns[1].Width = (TableView1.Width / 10) * 4.5 > TableView1.Columns[2].Title = ("Days Left") > TableView1.Columns[2].Width = (TableView1.Width / 10) * 2 > > sResult = DB.Edit("inventory", id = &1, ID) > sResult!id = ID > sResult!location = TableView1.Columns[1]. > sResult.Update > > I obviously get an error at runtime on the second to last line as I'm > not sure how to put data from the database into the table column. > > I believe I asked this question before using a dataview on how to > display only some data from the database as using a dataview would be > easier but I never got a response so I'm trying a table view as it has > more options--at least I think so. > > Any help would be appreciated. > > > > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://ad.doubleclick.net/clk;258768047;13503038;j? > http://info.appdynamics.com/FreeJavaPerformanceDownload.html > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > -- ____ С уважением Алексей. ------------------------------------------------------------------------------ Got visibility? Most devs has no idea what their production app looks like. Find out how fast your code is with AppDynamics Lite. http://ad.doubleclick.net/clk;262219671;13503038;y? http://info.appdynamics.com/FreeJavaPerformanceDownload.html _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user