PDA

View Full Version : Field expression (CALC field)


ABC123

Ludwig Beil
07-13-2000, 10:33 AM
calculated fields (restrictions)

Hallo, out there!
I try to build a little application for our school, which handles the results and places points on the screen.

What I have:
a set, which shows the points for certain results(jump, run...) on the form and add the points.

My problem:
I want to show on the form in a calculated field, whether the athlet gets a winner (W) or a special(S) sheet.

I tried to build an expression with two IFs and failed.....
I started like this:
IF(CALC->REACHEDREACHED>=VAL(BURKUNDE_P_SPECIAL), ā€œSā€œ, IF(CALC->REACHEDREACHED>=VAL(BURKUNDE_P_WINNER) :AND. CALC->REACHED

Robert Picard
07-13-2000, 09:09 PM
Hi Ludwig

Could you be more clear when you say the expressions failed.

Did you get an error message? Or did they evaluate but gave the wrong result.

thanks

Robert

Ludwig Beil
07-23-2000, 06:54 AM
thanks for your help. I found a solution for my problem.
Lu

Barry Jackson
07-24-2000, 08:59 AM
I tried your expressions on our Alpha4 V6 and they worked fine. What do you mean by failed ?.
They were certainly accpetable to Alpha.
Perhaps you would like to e*mail a very small portion
of your database and test data - and indicate why you think there is an error.

Ludwig Beil
07-25-2000, 12:57 PM
thanks for your offer, I found a solution two days ago.
Ive been building scripts and apps the hard way and thought I was an expert but after not programming for a year with a4 you have to start again learning......