[Gambas-user] TableView Data from database

[Bruce]

On Fri, 2012-09-28 at 20:11 -0700, rocko wrote:
> Ok that makes a little more sense.
> But I have some questions.
> 
> Do I have to use a TableView?
Well that depends on whether you want to have some sort of display of
the data at all.  If you just want to update the data, say on a daily
basis, then you can just use the result cursor itself.  There is no need
to display result!myfield if all you want to do is change its' value.

> Originally I used DataView but that displays all
> the fields in the database, I just want to use some
> of the fields if certain conditions apply, like
> if the 'Days Left' field is less than 20 days.
> 
> Then if so display just 4 fields in a separate
> Dataview/TableView.
OK, I think I got the idea of what you are trying to do.  Just to
confirm, is it:
a) load a result cursor with a set of records where 'Days Left' is less
than 20 days
b) display that set of rows to the user in some way
c) make some sort of update to the data displayed (I'm still not sure
here as your example code does not seem to show any update?)
d) At some point, update the data back to the database.

d) is somewhat worrying as you said "when the form opens".  I think
there is still some sort of requirement you haven't revealed here?

> Now exactly what is the 'idx' variable you used?
> Is it just an integer used to count thru the loop.
Yes
> 
> I ask cause I tried your example and it's not working.
> I don't get any error's, just the TableView is not being
> filled with any data.
The example was just a "skeleton" code, you need to fill it out with all
the things you need to do to 
a) display the data
b) change the data
c) update the data, and 
d) save the data back to the database.
> 
> 
> On 09/28/2012 07:39 PM, Bruce wrote:
> > On Fri, 2012-09-28 at 19:27 -0700, rocko wrote:
> >> Huh?
> >> I'm sorry Bruce I'm not following.
> >> I want the fields to update when the form opens.
> >> Just the ID, Location and Days Left fields.
> >>
> > Unless a row is selected in the tableview, Tableview1.Row will be -1.
> > (You can check that in the debugger.)  So your sResult!location =
> > TableView1[TableView1.Row, 1].Text line reports the Bad Row Index error
> > as TableView1[-1, 1].Text is incorrect.
> > If you want the update to happen automatically when the form opens you
> > will have to iterate through the rows of the tableview explicitly. As
> > in 
> > For idx = 0 to TableView1.Rows.Max
> >   ...
> >   sResult!location = TableView1[idx, 1].Text
> >   ...
> > Next
> > 
> > Bruce
> > 
> > 
> >>
> >> On 09/28/2012 07:17 PM, Bruce wrote:
> >>> On Fri, 2012-09-28 at 18:55 -0700, rocko wrote:
> >>>> I get a "Bad Row Index" error when I do that.
> >>>>
> >>>>
> >>>> On 09/28/2012 12:07 AM, Алексей Беспалов wrote:
> >>>>> It do that:
> >>>>>
> >>>>>  sResult = DB.Edit("inventory", id = &1, ID)
> >>>>>   sResult!id = ID
> >>>>>   'sResult!location = TableView1.Columns[1].
> >>>       If TableView1.Row < 0 then Error.Raise("You haven't selected a row
> >>> in the tableview yet!")
> >>>>> *  sResult!location = TableView1[TableView1.Row, 1].Text*
> >>>>>   sResult.Update
> >>>>>
> >>>
> >>> hth
> >>> Bruce
> >>>
> >>>
> >>>
> >>> ------------------------------------------------------------------------------
> >>> How fast is your code?
> >>> 3 out of 4 devs don\\\'t know how their code performs in production.
> >>> Find out how slow your code is with AppDynamics Lite.
> >>> http://ad.doubleclick.net/clk;262219672;13503038;z?
> >>> http://info.appdynamics.com/FreeJavaPerformanceDownload.html
> >>> _______________________________________________
> >>> Gambas-user mailing list
> >>> Gambas-user at lists.sourceforge.net
> >>> https://lists.sourceforge.net/lists/listinfo/gambas-user
> >>>
> >>
> >> ------------------------------------------------------------------------------
> >> How fast is your code?
> >> 3 out of 4 devs don\\\'t know how their code performs in production.
> >> Find out how slow your code is with AppDynamics Lite.
> >> http://ad.doubleclick.net/clk;262219672;13503038;z?
> >> http://info.appdynamics.com/FreeJavaPerformanceDownload.html
> >> _______________________________________________
> >> Gambas-user mailing list
> >> Gambas-user at lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/gambas-user
> > 
> > 
> > 
> > ------------------------------------------------------------------------------
> > How fast is your code?
> > 3 out of 4 devs don\\\'t know how their code performs in production.
> > Find out how slow your code is with AppDynamics Lite.
> > http://ad.doubleclick.net/clk;262219672;13503038;z?
> > http://info.appdynamics.com/FreeJavaPerformanceDownload.html
> > _______________________________________________
> > Gambas-user mailing list
> > Gambas-user at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
> > 
> 
> ------------------------------------------------------------------------------
> How fast is your code?
> 3 out of 4 devs don\\\'t know how their code performs in production.
> Find out how slow your code is with AppDynamics Lite.
> http://ad.doubleclick.net/clk;262219672;13503038;z?
> http://info.appdynamics.com/FreeJavaPerformanceDownload.html
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user