Using Xbasic functions in a UX

[netgeorger]

{Dialog.Object}.ajaxCallback(,,xbasicFunction,additionalData)
I need to use a function in xbasic that calculates the age of a person at their date of death
I have created a UX with three fields and a button the first two fields are date fields, one is the �Date_of_Birth� and the other is the �Date_of_Death� the last field is a numeric field I called �DeathAge�. This is the classic start date end date issue that I would handle with a calculation field on a form using the Age() function in xbasic.
I realize that this could probably be calculated in java script but I would like to learn how to use the plethora of xbasic functions on a UX especially the Time and Date functions.
I believe that I am somehow supposed to know what to do with the statement above
I need to know how to address the variables on the UX such that the are available to the serverside x basic. but I am not at all sure how to do that I think it has something to do with state variables which I really don�t know anything about. I decided to activate the action using an on click event of a button as I could not really see how to get something to happen with just entering the field or something which I don�t know about.
So my question is how can I use the Age() function so as to show the number of the age of the person in the �DeathAge� field on my ux after I enter the Beginning Date and Ending date. I have seen a lot of videos and looked through a great many threads concerning this issue and it still isn�t very clear to me what I need to do or where I need to do it. I suppose there are many ways this could be accomplished which is why I am not quite sure what to do. When you look at this it is all a bit daunting and you tend to get turned around quite a bit following one explanation after another that don�t seem to fit. I don�t really understand why we should have to drop all of the functions in xbasic that have been built over twenty years and have to remake them in java script.
Any clarification of this rather simple problem would be appreciated as I think it would open the door for a lot of other users as well.
Thanks

[mikeallenbrown]

Re: Using Xbasic functions in a UX

Are you using SQL? ...if so how about using a computed column? Add a new column ('deathage' maybe?) and in that column's Computed Column Specification try this formula: (datediff(day,[Date_of_Birth],getdate())/(365))

For a java-script solution try Googling "calculate age in javascript from date of birth". Several solutions come up. You could adapt the code for your age at death purposes. Using JS, as opposed to xbasic, would be ideal and faster. Xbasic makes a round trip to the server which could slow performance depending on what else is going on in your app.

As for xbasic take a peek at this thread: http://www.alphasoftware.com/alphafo...t-January-1st-!!!

It talks about various things age related.

[GGandhi]

Re: Using Xbasic functions in a UX

http://screencast.com/t/QHud0BXXAo2v
take a look at this. just want to remind you
you do not need a button. there are events that can be trapped to trigger the button action on the web side.
this will require a trip to server, wasted energy, can be done easily in javascript.
dividing the days by 365 will not be accurate since there are leap years to contend with. i have posted various codes to calculate age in the code section of this forum.
you might want to take a look.
good luck in the mean time.

[kenshap]

Re: Using Xbasic functions in a UX

If I understand what you are saying you want to do an ajaxcallback, here is an example of one that I did. I set up the callback in action javascript. See the screenshot. The javascript and xbasic functions are below. You can use the alpha anywhere date and time functions to do whatever you need to. You can send back javascript that can essentially do a {dialog.object}.setValue to return the calculation to alpha anywhere.

What I'm doing in case your wondering, is when the initial login dialog is validated I do some localstorage.setItem to save my session variables. Before I sync I make sure the session variables are defined so I execute this callback to restore the session variables in case they timed out on the application server.

ajaxcallback.PNG

function getSessionVars() {
var _str;
_str = '_providerid='+ localStorage.getItem('providerid');
_str = _str + '&_username='+ localStorage.getItem('username');
_str = _str + '&_today='+ localStorage.getItem('today');
_str = _str + '&_firstdate='+ localStorage.getItem('firstdate');
_str = _str + '&_semesterid='+ localStorage.getItem('semesterid');
_str = _str + '&_servicemonth='+ localStorage.getItem('servicemonth');
return _str;
}



function xbresetSessionVars as c (e as p)
'xbresetSessionVars = "javascript commands to be executed in the Browser."
'debug(1)

session.providerid=request.variables._providerid
session.username=request.variables._username
session.today=request.variables._today
session.firstdate=request.variables._firstdate
session.semesterid=request.variables._semesterid
session.servicemonth=request.variables._servicemonth
'xbresetSessionVars = "alert ('" + session.providerid + "');"
end function

[netgeorger]

Re: Using Xbasic functions in a UX

Thank you so much for your advice and guidance I will look into these options. I did look at that thread and found a lot of good information in it. But for me it was still a bit difficult to follow.
Thank you so much

[netgeorger]

Re: Using Xbasic functions in a UX

Wow! Awesome! Thank you so much. It demonstrates exactly what I wanted to do and how to do it. Thank you! Thank you! Thank you! This will help me a great deal at getting started and clarifies many aspects. I will study your other contributions. This will help a lot of others also who are a bit overwhelmed by all the ends and outs of these procedures. I was stumbling over all the literature and variations. I mean the first thing you do is start to read the help files and threads. Then you look at one video after another a very time consuming learning curve along with hours of fooling around with ideas.
I know these things can be done in Java script and it is not too difficult to understand but I want to say you are making a huge contribution with your videos.
Thanks again.

[netgeorger]

Re: Using Xbasic functions in a UX

I can see I am not addressing each post the way I wanted to so my above two posts are to mike Brown and GGahndi with great appreciation and thanks also goes to the post by Kenshap I really appreciate the input it is very helpful I will study what you have shown me thank you all.