OnExistingRowRender event handler error setting session variables

[ids-dave]

Hello, I am working on upgrading from v10.5 to v11 and have 5 production sites running on a dedicated godaddy server

4 of the sites are up and running with v11 with no problems, but the 5th one has been a problem child

Currently I am trying to figure out why I'm getting this error on the dedicated production server but it works fine on my development machine (running local)

Error message -> Error executing OnExistingRowRender event handler: command: dim session.__protected__startdate as D Exception executing XBasic instruction.

I know I saw something in the "what's new' release notes for v11 that touched on this, but I cannot zoom in on anything specific that says how to code this under v11. This particular OnExistingRowRender event in my app loads up about 40 session variables and all of the character formatted ones are fine. My memory says there's an article about this being handled differently in v11 but like I said earlier, I just cannot seem to understand what I need to do with this.

Any suggestions are much appreciated

Thanks, Dave

[Steve Workings]

Re: OnExistingRowRender event handler error setting session variables

When referring to the session variable in that event, you need to use e.rv.Session. So your instruction should be:

dim e.rv.session.__protected__startdate as D

I'll note too, that for version 12 compatibility, session variables may need to be character-type. Not a critical item here or now, but worth noting for future development.

Also, your __Protected__ part of the string is still OK - does no harm, but starting with v11, all session variables are protected, so you could just as well have:

dim e.rv.session.startdate as D

[ids-dave]

Re: OnExistingRowRender event handler error setting session variables

Thanks Steve.... what you mentioned about v12 was what I was recalling but didn't distinguish it as a future item to consider. Hard to keep all the new v11 stuff straight.

As for the "e.rv." prefix on the dim statement ..... why does it work when run locally ? It is concerning to think code that works in development and tested on the local WAS will not execute in a production web environment.

I'll try your suggestion later tonight after the traffic slows down at 11pm (time to brew more coffee)

Thanks, Dave

[ids-dave]

Re: OnExistingRowRender event handler error setting session variables

Bummer.... adding "e.rv." didn't work. Newest error message is Error executing OnExistingRowRender event handler: command: dim e.rv.session.__protected__startdate as D Exception executing XBasic instruction

[ids-dave]

Re: OnExistingRowRender event handler error setting session variables

Making some progress

Tried different variations of the "dim" statement to no avail. So I tried declaring the property type in the instruction that sets the value instead of the dimension statement and that worked

original code that fails on the web server (but works locally)
dim e.rv.session.__protected__startdate as D
e.rv.session.__protected__startdate = e.rowData.data("start_date")

modified code that works on the web server
dim e.rv.session.__protected__startdate as c
e.rv.session.__protected__startdate = convert_type(e.rowData.data("start_date"),"D")

the bad news comes in two flavors

1) now I've unearthed a bunch of xbasic functions that are getting similar errors in the "add.args" statement. I'm 99% sure it's going to be the same basic

2) The errors I encountered all involved dates and times but I also have about 10 variables that are numeric, but didn't get any errors when those variable get set in the function. But just because there wasn't an error message doesn't mean the numeric variables are set correctly. I'm going to have to test everything inside out (about 50 grids and most of them have server-side events and xbasic function). I'd much rather get errors rather than search for some piece of data that doesn't get processed correctly because of a property type issue and no errors are generated


I really wish there was an explaination of why this works on a local machine but not on a web server

[RichCPT]

Re: OnExistingRowRender event handler error setting session variables

Pretty pleeeease....

Alpha Software, would you post a corrected chapter 37 for the "Alpha Five� Professional Learning Series: Introduction to Web Applications" that explains the proper use and intent of session variables under Alpha 11?


The sample should demonstrate a session variable method that works under both "Working Preview" mode AND running for real under the server. The sample must demonstrate that the session variable can be set in one grid and picked up by the called grid and that the code will work under both modes of operation (WP and server). There seems to be a difference in how WP and server mode work, depending on the GLOBAL / SHARED / PRIVATE storage class when omitted from the DIM!!! Also, might be good to throw in a discussion about client-side caching of session variables and how to avoid that. And, if you could demonstrate how two instances of a browser running on the localhost could each get their own copy of session variables, it would be icing on the cake.


Thanks.


-Rich Fulham