Matching ui_get to field?

[Keith Hubert]

I need to print different text as to whether the ui_get_date matches the field Date, how do I write the IF statement for the calculated Text Field?

[Doug Chanley]

RE: Matching ui_get to field?

Keith,

I would think that it would be better to use a variable to
hold the text & change the text depending on whether or not
ui_get_date() is equal to the tables date field.

....This syntax should work for the calc field as well,
just replace the var->text with the name of the calc field....



tbl=table.curent()
date1=ui_get_date("Date","Enter The Date You Want")
if CTOD(date1)= tbl.datefield THEN
tbl.change_begin()
var->text= "Enter the text you want here"
tbl.change_end(.t.)
else
'if ui_get_date() is not equal to the date field
tbl.change_begin()
var->text= "Enter the text you want here"
tbl.change_end(.t.)
end if
end

[Stephen Williams]

RE: Matching ui_get to field?

Keith-
Two ways to get user entered dates into reports...

1. Create GLOBAL variables (maybe SESSION variables will pass depending on context)

2. ASK USER variables. The ui_get_date() is an xbasic interaction rather than a report printing function. When getting user entered dates in reports use ASK USER variables. ASK USER variables can be set up in the report filter section or the report calc fields section. Once used these variables show up as variables with ASK_D_your_question on the drop down field lists.

Use them as any other variable.

If I read your question right all you need is in Report define a Calculated field as

Text = if(ASK_D_Enter_Date=Date,"Dates match text",
"Dates don't match text")
and put Text where you need it...

[Keith Hubert]

RE: Matching ui_get to field?

Doug

Thanks for reply, I think you are are the right path. This is what I am trying to achive: to print a report for a driver to make either a collection or delivery that is required on the date that the report is reqested for, and only the correct instruction for that date will be printed.

eg. field date_1= 13/12/2000
field instr_1 = Collection
field date_2 = 18/12/2000
field instr_2 = Delivery

So far I am able to print a report for the selcted date regardless whether it is a Collection or Delivery, now all I want is to make sure that both instructions cannot be printed on the report for the one Date that was called for with the ui_get_date request.

[Stephen Williams]

RE: Matching ui_get to field?

Keith

when you print the report you will have some sort of filter to pick the date. This will show up as a variable in the fields available to choose from in the reports expression builders.

Text=if(Rept_date=Date_1,Instr_1,if(Rept_date=Date_2,Instr_2,""))

A nested if statement, checks the match on collection, the delivery, if no match is an empty string which won't print anything and if you want the report can shrink appropriately

[Keith Hubert]

RE: Matching ui_get to field?

Stephen

Thanks for you help so far. The reason I was useing ui_get_date in a script was that I was calling for the report by clicking a button on a form. And this then selected the dates of the customers I wanted visited on that date. Can you please tell me how to use the variable created at the form page that I can use against for calculated fields on the report, I am not sure how to use the global command.

Keith.

[Stephen Williams]

RE: Matching ui_get to field?

If you define a variable on the form page the very first property is the level - choices are layout, session or global.

I am not sure but a session variable may pass to a report...Certainly a global variable will. The thing with global variables is once created they stay in memory until Alpha Five quits, unless you issue a DELETE command. And if you use the same variable names you could stumble over old values...

Another glitch is once you decide to use the global variable created in a form, you have to be sure it exists before you run the report else the report will crash...

Which is why I use the ASK variables - they are created within the report definitions and do not stick around afterwards.

[Keith Hubert]

RE: Matching ui_get to field?

Stephen and you other guys, thank you for your help, with bit of this and that I have got what I wanted so far. Now I would like to try one more thing. I have a field for customers "addr1" and a field for "del1". The addr1 is filled from a lookup table, what I want to do is fill "del1" with "addr1" if 'check box' "same" is checked and if not then a new delivery address can be entered in.
Thanks in advance, I know you will come up with the answer.

Keith Hubert

[Stephen Williams]

RE: Matching ui_get to field?

Keith-
Put code in the OnChange event of the checkbox object on the form.
You might try using the Action Scripting tools for this...
1. GET the value of "addr1" into a variable
2. SET the value of "del1" to this variable
If it seems apropriate...
3. Activate the next logical field, considering you just filled "del1"

Steve