[Gambas-user] TableView Data from database

[rocko]

You are so close Bruce!
Actually I dont need to send data back to the database.
Thats done with a DataBrowser that displays and updates the entire database.
This is a separate entity that gets SOME data form the database IF the
daysLeft field in the database is less than a certain amount, 20 days
for example.
I want it to retrieve and only retrieve 4 fields form the database.
I would like to use a DataViewer as I think that would be easier, but
wasn't sure if the DataViewer could do that.
The user would click a button and a new form would show the data.

Sorry my code doesn't show the IF Then statement that is actually a
requirement that I'm seeking, oops my bad.

On 09/29/2012 03:38 AM, Bruce wrote:
> 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
> 
> 
> 
> ------------------------------------------------------------------------------
> 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
>