IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Message Boards
Tech Search:

Advanced
-Collapse +Expand More Board Options
MOREINFO...
-Collapse +Expand My Moderator Settings
MODERATOROPTONS

BOARDSTATS
Posts: 16052
Threads: 4729
Topics: 95
Boards: 34
Groups: 34
 

Prestwood eMagazine

January Edition
Subscribe now! It's Free!
Enter your email:

   ► MB Lobby ►   Print This     

calculated field Posts

"calculated field" Message Board Posts

More...

Thread 5 of 5

Tom
Calculated fields
Could someone help with explaining with an example ot two the basics of entering code to get calculated fields to work. Looking through what examples I can find, if I use this code -, , Begin, table1FieldZ.value := table1FieldX.value * table1FieldY;, End;, , I get a message 'undeclared identifier table1FieldX' is because I have not declared something? It's very hard to work these things out when many of the so called help pages only give "the" line of code and miss out all the other stuff., , Also I can find examples to put a calculated field into a grid, but what do I have to do to display a calculated field in a box?, Thanks, Tom. Confused
Posted to MB Topic: Delphi Distributed Apps « Delphi Board
16 years ago
2 replies. Last post:

Rodgers.J
I am assurance that It was functioning due to the fact Popcorn Time Download If you know exactly how to play risk-free, go ahead was birthed. 
16 years ago
Nothing New Since Your Last Visit
3152
Hits

Thread 4 of 5

Sam.S
Changing the formula of a Calculate field via code
Does anyone know how to change the formula of a calculated field through code? I was hoping it was a property that I code adjust, but I haven't been able to find it. There's a true/false "calculatedField" property but I haven't found the actual formula. The reason I am looking is I find formulas occasionally get dropped when taking forms in and out of design. Rather than check every formula each time I open the design of a form, I'd like to automate it so it checks itself.
Posted to MB Topic: ObjectPAL « Paradox Board
16 years ago
1 Reply:

Anonymous
{Too Long!}
16 years ago
Nothing New Since Your Last Visit
1665
Hits

Thread 3 of 5

OzPaul
Calculated field and treat blank as zero
First I should mention that I have "treat blanks as zero" ticked in settings of Pdx10 running on Win7 at work. On my report  I have numeric fields which are covered by undefined calculated fields that show a text value of "Absent" when the corresponding numeric value is 0.0. Otherwise the numeric value is shown. The problem is that when the field is left blank, I want a calculated field to show "Not Done". When I set up an iif isBlank() condition in a calculated field, the calculation treats the blank field as a 0 and reports 0.0 rather than "Not Done". It is as if the treat blank as zero over-rides the isBlank() request.... This does not seem right to me because  the underlying table value certainly is blank... Can you help? Regards. Paul
Posted to MB Topic: Paradox Reports « Paradox Board
16 years ago
4 replies. Last post:

OzPaul
FYI, I have discovered that if I use the syntax fieldname = blank() rather than the isBlank() approach, then it works!
16 years ago
Nothing New Since Your Last Visit
2918
Hits

Thread 2 of 5

Gary.L3
Custom method call in a calculated field
Can someone please help with this? In Corel Paradox 8, I have a custom method that returns a string that I want to display in the field value box.   However the only thing that displays is ERROR.   The help menus say that the method has to be in the "RSL runtime library." My method was attached at the form level.   Any help would be appreciated.
Posted to MB Topic: Paradox Forms « Paradox Board
16 years ago
11 replies. Last post:

AIBreveleri
{Too Long!}
16 years ago
Nothing New Since Your Last Visit
3475
Hits

Thread 1 of 5

PaulHoran
report problem
{Too Long!}
Posted to MB Topic: Paradox Reports « Paradox Board
16 years ago
1 Reply:

Dan
Hi Paul You are going to need to convert the numerical data to a string and append spaces to the right side of the string using the fill function.  If you want to convert the numerical field values into positional values you will probably have to resort to opal.
16 years ago
Nothing New Since Your Last Visit
2505
Hits
More...

"calculated field" Knowledge Base Posts


Mike Prestwood
1. User ForceRefresh() to Update Calculated Fields If you ever have a calculated field on a form not update when you think it should, then use forceRefresh() to make the calculated field display the correct values.
Posted to KB Topic: OPAL: Commands
15 years ago, and updated 14 years ago

Tip
Nothing New Since Your Last Visit
9441
Hits

Corel Paradox / ObjectPAL Coding
 
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2022 Prestwood IT Solutions.   [Security & Privacy]