Easy to Create, Easy to Change - Easy to use!


Reference of blank on a currency field ..


Started by grohmann.papier@t-online.de
Search
You will need to Sign In to be able to add or comment on the forum!

Reference of blank on a currency field ..

Hello DataEase forum community ....
I have since discovered a difficulty and therefore do not get ahead.
When I query a currency field to blank I get no response.
With all other field types the query working properly ...
Is there a good idea where to look?

Best regards
Markus

Written by grohmann.papier@t-online.de 23/09/15 at 18:12:44 Dataease [{8}]FIVE

Re:Reference of blank on a currency field ..

Just tested this and it works fine.

1) Is the currency field actually blank or is it 0.00?
2) If there is a derivation in the currency field it will result with 0.

I think you need to make a "non-working" sample and upload it to show what you do to not get this to work.

We have tried to break it and even configured our test PC to German to see if it has anything to do with digit separators etc.


But we simply can't replicate this problem.

A simple test can be to do ToText() on the currency and see what you get out then as a string. You can also do length() to see if there is any size to the result.

In our test we just got blank, blank, blank and the length was always 0.

Written by DataEase 23/09/15 at 18:32:16 Dataease [{8}]FIVE

Re:Re:Reference of blank on a currency field ..

Written by grohmann.papier@t-online.de 23/09/15 at 19:03:58 Dataease [{8}]FIVE

Re:Re:Re:Reference of blank on a currency field ..

Here the simpl app....

no User/password

Kind regards

Markus

Written by grohmann.papier@t-online.de 23/09/15 at 19:11:40 Dataease [{8}]FIVE

Re:Re:Re:Re:Reference of blank on a currency field ..

OML is not as the rest. It read the text in the GUI control and not the column value.



As you see here (simply did a Message Field 1.value window . in the action clicked on the Button to the left).

The currency control insert a , and . for thousands if necessary in the visual representation and that is what you read with .value.

.value is ALWAYS string and what you see in the control.

so if you have a number field and want to check if it is bigger and smaller than a number you have to allocate it to a temp number if not the comparison will be string.

However the solution here is simple.

You also have access to the column value in OML so by writing this instead it will work.

if Field 1 = blank then

Text22.visible := 0 .

else

Text22.visible := 1 .

end.


So to recap:

Field.value returns the string represenation of the GUI controol
Field returns the column value stored in the multiview.

Written by DataEase 23/09/15 at 19:45:11 Dataease [{8}]FIVE

Re:Re:Re:Re:Re:Reference of blank on a currency field ..

Oh yes I understood ....
As always, thank you for the fast and accurate help!
Sometimes a small change can have a big impact ....

Thanks again!

Markus

Written by grohmann.papier@t-online.de 23/09/15 at 20:11:35 Dataease [{8}]FIVE