Get record data from treegrid

[barrymavin]

Hi David,

Sorry but that makes no logical sense to me.

If the section is bound to a table it has an active record.

The treegrid is in that section so when the section is refreshed so will the Treegrid.

So how are you expecting deggweight.cfk_degg = "{degg.cpk_degg}" to work? You will change the treegrid.

How are you going to refresh the TreeGrid. Its an endless loop.

[avianmanagement]

Hi Barry,

It makes perfect sense to me, perhaps I'm not explaining it properly.

Yes the tree grid refreshes when section 1 moves to a new egg record.

I want to refresh the section2 when the user clicks on another row in the treegrid.

Page with two sections

Section 1 has the egg data

section2 has the weight data for the egg

Section 2 has a tree grid which has an SQL statement which display just some of that weight data.

select tweight,nweight,nperlossatpip,lnotes,calive,ldrill ed,nveingrowth,cpk_deggweight from deggweight where deggweight.cfk_degg = "{degg.cpk_degg}"

So the treegrid shows those fields for the egg weight record. Last one is the PK for the egg weight record the user is on in the treegrid

When section one moves to a new egg section 2 updates to show the one record for the weights for the egg in the main UI and the grid displays a limited set of data for all the weights for the egg.

UI in section 2 only shows one record, except for the tree grid which displays limited info for all of the weight record.

Use is on say record 4 of 6 in the weights

User clicks on row 2 in the treegrid and I want section 2 to goto record 2 and display the full data for that record, basically move to that record.

I don't see any loop since we are simply moving between records of the weights.

David

[avianmanagement]

When the user moves to row 2 deggweight.cfk_degg will be the same value as when they were on row 6

I'm picking up cpk_deggweight, the Pk of the weight record rather the pk of the egg, so there is no need to refesh the grid as the data in it does not change.

[avianmanagement]

Hi Barry,

Lets simplify it a little

Section1 egg record

section 2 weight records for the egg, there are lets say 10 record of weights for the egg

Section 2 UI currently shows the data for record 2 of the egg weights

I know the PK value for record 6 of the egg weights

How do I in section2 move to that record and update the UI in section 2 to show the weight data for record 6?

David

[barrymavin]

Ok i misunderstood. So you want to refresh another section.

Do you have a key on the table that the section is bound to?

Just set the searchfilter.

Lianja.get("yoursection2").searchfilter = your_key = the_value_from_the_tree_grid

[avianmanagement]

Hi Barry,

No I don't want to refresh another section.

I want to refresh section 2, the one the tree grid is already on by using the PK I get from the values in the sql statement used to pull the data for the treegrid.

I'll try the method you suggest as that will work I think

[avianmanagement]

Hi barry,

////////////////////////////////////////////////////////////////
// Event delegate for 'click' event
proc page1_EggWeight_EggWeightGrid_click()

local lcEggWeightPK
lcEggWeightPK = (this.item(this.activerow,8))
Lianja.writeOutput(lcEggWeightPK)
Lianja.get("page1.EggWeight").searchfilter = lcEggWeightPK
Lianja.getElementByID("page1.EggWeight.EggWeightGr id").caption = lcEggWeightPK
Lianja.getElementByID("page1.EggWeight").refresh()

//Lianja.writeOutput("Clicked on row " + etos(this.activerow) + ", info = 8 " + etos(this.item(this.activerow,8)))
endproc

This does not work, but I'd like to test this with the next beta where the refresh in the grid is fixed to be really sure I'm dealing with the correct records in the treegrid

[barrymavin]

If the TreeGrid is in the same section that you want to refresh I dont see how that can work as the TreeGrid itself will get refreshed.

So why not have a grid section above this form that relates to this form. You seem to be wanting to relate other form content inside a section.

If thast what you want you are making work for yourself unnecessarily as you are bypassing a lot of built-in functionality.

[barrymavin]

From what i understand a page navigation panel will do this for you.

See the example_navpane2 app



Note that you can refresh the navigation panel dynamically:

Lianja.get("page1").refreshNavigationPanel("select ... from ... where ....")

The where condition can include {macros}

[avianmanagement]

Hi Barry,

OK so if the tree grid gets refreshed it's not an issue as far as I can see as it will just so the same information before and after the refresh.

When the tree grid gets refreshed it is not going to do anything unless it is clicked on to move to another record for the egg weight

The refresh is not going to fire the click code

I need to section be laid out in a very specific way as we have spent years getting the UI layout to work for maximum productivity when weighing a lot of eggs.

I just need to be able to take a PK value for deggweight and move to that record. Section 2 is bound to dEggweight.

Why have a grid section above the form when the treegrid has the data I need to tel me whcih record I wan to move to.

I'm not changing the egg by clicking on the row in the grid, just picking up a new Pk for deggweight, then I want to use that to move to the deggweight record for that PK.

The deggweight record relate to the same egg as in section1