Page Redirection

[Rogers]

I have this code in my AfterInsertRecord of my grid component

 session.__protected__total_due=e.datasubmitted.total_due

total_due is a label field. In my onpageredirect I have the following code

e.url= "https://www3.cenpos.net/webpay/html5/?merchantid="+"&amount="+session.__protected__total_due

The page doesn't get populated. However when I change total_due to a text field the page variable gets populated with the value in the total_due field

What could be the reason for this?

[Rogers]

Re: Page Redirection

Sorry i forgot to add, I get this message

Error executing afterInsertRecord event handler: command: session.__protected__total_due=e.datasubmitted.total_due Property not found
e.datasubmitted.total_due subelement not found.

[Steve Wood]

Re: Page Redirection

I cannot test right now but believe a Label does not carry in the e property. Can you convert to a hidden field type? Hidden, Text, etc. field types do come over in e.

[Rogers]

Re: Page Redirection

I tested it as a hidden field as well but it is not possible for me to make it hidden since I would want the user to see the value in this field.
I believe I read somewhere that I have define a primary of which I did in the Query part of the Grid. I also have in the afterinsertrecord
e.primaryKeyValue=invoice_number.

All I am trying to accomplish is to navigate to an external page and populating it using page variables from within the grid component. At first I created my own custom button and created an on click javascript event to open a new page and just added the variables which was pretty straight forward. However I am not sure how to do validation checks when the user clicks the custom button before navigating to the external page. Thus I decided to use the built in submit button since it would be easier for me to do my validation checks. However I am stuck since I can't pass this page variable if the field is a label.

Any solution would be appreciated.


Thanks

[Steve Wood]

Re: Page Redirection

First, e.primaryKeyValue already contains the primary key value, you don't set it to anything. Next, your choices (that I know of) are to set your Total_due as Hidden and use Query to create a dummy copy just for display, or write some xbasic in your event to go get the total_due value from the database using that primary key.

[Rogers]

Re: Page Redirection

Thanks for replying Steve.

How do I go about creating a dummy copy of the Total_due?
And would this dummy copy be a text or label?
I did set the Total_due as a hidden field but when I do the issue with this is that the url doesn't get populated with the page variable.


Also write some xbasic in your event to go get the total_due value from the database?
My concern is that the user should be able to see the Total_due and not edit it and to pass this same total due to a page as a variable once the submit button is clicked.

[Steve Wood]

Re: Page Redirection

I can't get back to this for about 12 hours so hopefully someone else can chime in.

[GGandhi]

Re: Page Redirection

the field total due, is that a calculated field and you are keeping that as a label. so no one will interfere?
if the answer is Yes then you do the calculation in the afterInsert function and assign the result to the session variable.

        dim d1 as n
	dim d2 as n
	dim total as n
	d1 = e.dataSubmitted.d1
	d2 = e.dataSubmitted.d2
	total = d1 * d2
session.__protected__total_due = e.datasubmitted.total

d1 and d2 are the precursor of the total
edit: I see you are keeping as a label for that reason.

[GGandhi]

Re: Page Redirection

duplicate
deleted by me

[Rogers]

Re: Page Redirection

Thanks for the replies.

I saw this thread on the message board http://www.alphasoftware.com/alphafo...ted+field+grid

Would it be possible to do something like this for version 10?
That is to make a textbox field read only.

[Rogers]

Re: Page Redirection

I set the property "Enable Expression" for the control to false and this disabled the textbox for editing. Now I am able to pass the variable to the page.

Another concern I have though is that my calculated fields only change when I click outside of a textbox field. Is there a way to update the calculated field whenever the user types in a value in another field?

For instance some fields on my grid are:
ss_amount------------ textbox
lv_amount------------ textbox
pe_amount------------textbox

total_amount--------- label

I want the total_amount to change whenever the user enters a value in any of the field even before leaving that field.

How can I accomplish this?

[Steve Wood]

Re: Page Redirection

Keep your total field as a client-side calculated field but add this to each of the other three controls in the onKeyUp event:

{dialog.Object}.refreshClientSideComputations();

Note that this does not save the record to the database. You have to Submit or add additional javascript to your event(s) to cause it to auto-submit.

BTW, this is specifically because you said you wanted the total to change "before leaving the field."

[Rogers]

Re: Page Redirection

Thanks,

That is fine since the submit button will save the records then navigate to another page.
I just want the user to see the updated calculations.

What I would like though is for the submit button to be enabled once the grid initializes.
How can I accomplish this?

[Rogers]

Re: Page Redirection

Ok I got it to work with the help from a post on the messageboard

I placed a hidden field on my grid called Makedirty then I added the following code into the javascript system events on Gridrender

setTimeout("{grid.Object}.setValue('G','MAKEDIRTY',1,'five')",1200);

[Rogers]

Re: Page Redirection

Steve

What you gave me for the onkeyup was for a dialog.

I used the following code for the grid {grid.Object}.refreshRow({Grid.RowNumber});

but I received the message below

onkeyup.PNG