having issues using session variable

[sremias]

Hi all! I have 14 years of programming experience but I am completely new to Alpha Anywhere, xBasic and JavaScript so please excuse my ignorance! I hope what I'm about to say makes sense and that someone can offer some helpful advice. And honestly, it should be relatively simple!

I'm trying to use set a session variable to use throughout my application. Basically, when I click on a grid row, I need the id of the record (which is also available in detail view) and on detail view there is an image that when clicked, I need to pass the id so it can be used in a SQL update statement. So the bottom line is, on the DETAIL view, when I click an image, I want to pass the ID to the new web component.

First thoughts were to set the session variable in the OnDetailViewRender server side event. However, it is firing when the GRID is loaded and not when I click on a row to display the DETAIL view. It doesn't fire at all when the DETAIL view is launched. If I could figure this much out, I can probably get what I want to work.

Next thing I tried was the client side OnRowSelect event. I can get the id of the record clicked from the grid (log_nbr):

var rn = {grid.object}._selectedRow;
var log_nbr = {grid.Object}._getValue("G",'LOG_NUMBER',rn); //NOTE: get an error when I use "D" so left it as "G"

now I want to set log_nbr to a session variable for use on the other screen.

I see that session variables are not available client side without setting the PUBLISH SESSION VARIABLES property on the grid so I did set that to SESSION.LOG. I can initialize SESSION.LOG to anything I want (like in OnGridInitialize SESSION.LOG = 123) but I need to set it in the OnRowSelect to the value of log_nbr and I can't figure out how. SESSION.LOG = log_nbr: causes an error "session is undefined".

So I'm clearly doing something wrong or misunderstanding how the session variable works. Can anyone help?

Thanks in advance.

[Steve Wood]

Re: having issues using session variable

Bit hard to tell but sounds like you want a onclick event on the image that leads to an Ajax callback, where you would write and execute your sql update.

[sremias]

Re: having issues using session variable

thanks for your response Steve. I could do that for the update (although I already have that logic working elsewhere using a hard coded value for what I want to be the session variable) but I still have the issue of how to set the value of the session variable. I need the value of "LOG" to be available to me when I get to the screen with the image. right now I don't have it as it's on the prior screen, not the screen with the image...hence my dilemma!

[agillbb]

Re: having issues using session variable

See M41 on http://news.alphasoftware.com/v11preview/videos_v11.htm
Or search the page for the word 'session'.
Note that there are other options available to you as well, like storing in state variables, storing in {grid.object}.myvarname = 'yea'; and in global javascript variables in particular. Session variables are server-side, so a callback would be required, whether indirect or direct.

[GGandhi]

Re: having issues using session variable

I think this is what you need to do,
do an ajax callback function on the onClick event of the image. while filling in the information click on the last row of that pop up, compute current row data.
that will supply the id of the record from the detail view, regardless you are submitting the data or not.
then you can set your session variable to that value.

this will set the session variable,
if you explain what you are doing better than in post #1, there may be an easier way to pass the information to the new component.

[Steve Wood]

Re: having issues using session variable

Using the same onclick you can set the session var in the callback function.

[sremias]

Re: having issues using session variable

Ok I have figured it out and wanted to post my solution here in hopes of helping others:

In the image OnClick event, I added an Action Javascript, Open Grid Component. in the Override Settings property, I added the following under "Set Session Variables":

sessLog = {javascript}function(rowNum) { return {grid.object}.getValue('D','LOG_NUMBER', rowNum); } (rowNum)

This uses an anonymous in-line javascript function so it does not need to be declared anywhere else. And like magic, I can retrieve the sessLog value by using session.sessLog

Here's what my update looks like:
sql = "Update qtncp set car_number = :car_number where log_number = " + session.sessLog

Hope this helps someone else! thanks everyone!

[agillbb]

Re: having issues using session variable

Great to hear Stephanie, always helpful to share.
Sounds like you correctly followed video M41 on http://news.alphasoftware.com/v11preview/videos_v11.htm for setting the session variable? (great resource those videos).