How do I know if a component is being opened as normal or as a lookup?

[PhilM]

Hi all,

I want to use a grid as a lookup on a field on a form, and Alpha seems to know somehow when a grid is used in that way because it prepends a 'Select' hyperlink to each line of the grid.

How do I test for that and then are there JavaScript or xBasic points that become 'available' when the grid is used as a lookup?

What I would like is to perform an Ajax callback when the Select hyperlink is clicked ... something like 'beforeSelect/onSelect/canSelect/afterSelect'. For example, to decrement a stock value if the grid is looking up a stock item to be 'consumed'.

Thanks,

Phil

[Davidk]

Re: How do I know if a component is being opened as normal or as a lookup?

I want to use a grid as a lookup on a field on a form

On a "form"... on a desktop Form? Or a UX?

[Davidk]

Re: How do I know if a component is being opened as normal or as a lookup?

Let's assume a UX Component.

It doesn't look like there is a built-in process for doing this... but... looking at what Alpha is doing with that Select link... there is a way to, in a sense, replace Alpha's function with our own.

I don't know if this is quite advisable... but an interesting exercise none the less.

That Select link you see in the Grid is rendered by Alpha on the fly. In that link is an onclick event which calls an Alpha function... for example...

DLG1_GRD_CUSTOM_XJOY_GridObj.lookupGridSelectRow('DLG1','CUSTOMER_ID','O',4); return false;

What we're going to do is take over the Select link... put our code in. We still use Alpha's code to return the value we're after from the grid... but we call that in our own function.

In effect, we're using the DOM's hierarchy to our advantage. I don't know if that's kosher, but it works.

Have a look...

http://www.youtube.com/watch?v=mS35mvi7RBc

[RichCPT]

Re: How do I know if a component is being opened as normal or as a lookup?

David, that is great. I always wondered how to do something like that.

BTW, you can use {Grid.RowNumber} when you are defining the html for the select link! The following seemed to work in the select link label:

<a href="#" onclick="myFunction({Grid.RowNumber});" class="GrBlueLink"><span>Select</span></a>

Then in the js function you are guaranteed to have the correct row number that was clicked.

function myFunction(rowNum) {
alert(' in "myFunction" row = ' + rowNum);
}

[PhilM1965]

Re: How do I know if a component is being opened as normal or as a lookup?

Hi David,

On a grid form ... define a field as a look up field using a component for the look up. I'll have a look later at your solution. I am sure it will work in the same way as on a UX component.

Thanks again (as always)

Phil

[Davidk]

Re: How do I know if a component is being opened as normal or as a lookup?

Phil,

For a Grid-to-Grid process the parameters for the "lookupGridSelectRow" method are a bit different...

{Grid.Object}.lookupGridSelectRow('GRID1','CUSTOMER_ID','G',currValue);

Where currValue is whatever you've selected as your current value in the grid to return.

[Davidk]

Re: How do I know if a component is being opened as normal or as a lookup?

Rich,

I'm wondering how you're using the target Lookup Grid. Are you setting clicking on the row first and then clicking "Select"? Using {Grid.RowNumber} as a parameter in the function always returns, in my case, 1 because that's the value of the Customer_Id in the 1st row.

[PhilM]

Re: How do I know if a component is being opened as normal or as a lookup?

Hi David,

This is what I am doing ... and the Ajax callback is to decrement the stock level of the frame when it has been selected.

http://screencast.com/t/RDptnvCznFi

So it's from a 'Grid Form' or Detail View of the Grid. Sorry, I sometime get caught up in using Clarion naming rather than Alpha ... 25 years is hard to shake! So, which version should I use, in this case?

Thanks,

Phil

[RichCPT]

Re: How do I know if a component is being opened as normal or as a lookup?

David,
I was just clicking on the select button, no need to select the row first. My test case is an updateable grid with textbox defined with a Lookup grid that opens in a popup. I did NOT test it from a UX or when the lookup is used as a dropdown instead of a popup.

[RichCPT]

Re: How do I know if a component is being opened as normal or as a lookup?

To answer the question: "How do I know if a component is being opened as normal or as a lookup?"

Try this in the server-side "function OnGridInitialize as v (e as p)" for the called grid:

e._state.CalledForLookup = "N"
if variable_exists("request.variables.__formAction")
if UPPER(request.variables.__formAction) = UPPER("showLookupGrid")
e._state.CalledForLookup = "Y"
end if
end if
....