Simplicty and flexibility!


retval := GetValue("ObjectName") .
GetValue("MyOject","OldValue) -- DE9. All field objects now keep oldvalue if changed and this can be queried.

To get the value of an object. This function is very useful in ExecDQL or to pick values out of non-referable fields like editable form virtual fields etc.

Remember that you can use this function to pick any field value but if you pick a Memo it will only return the first 255 characters.

This is a GUI function so it will return the value of the GUI object rather than the PRISM column that has populated it. 


ObjectName: String

The object from which you want to retrieve the content.
Arg2: String
When Arg2 is set it will read alternative value for object.

Arg2 - Values
- OldValue : Will return the previous value of the object before the last change. (only live, not stored in database).


String(255): The content of the object you queried.



See Also


On the forum about GetValue

setvalue getvalue

Following on from the 'Reporter' thread, which has gone haywire and is putting latest replies not at the bottom but in the middle of the thread!  I figured I'd start a new thread.I'm now having to learn QBM and ditch DQL as dataease no lon...

Product: Dataease [{8}]FIVE. Written by Simon B 09/09/14 at 15:31:40

Re:setvalue getvalue

The initial problem is that you have been advised to use the wrong function.If i am not mistaken Adrian took this from the top of his head and mixed them up. The format is the same but they do very different things. SetValue() and GetValu...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 09/09/14 at 15:55:42

Re:Re:setvalue getvalue

Ahaaaaaaa! it worked! :DSmug look for doing a qbm that works.  Only taken me 20 years ... :D  Soooooo, I can now do a report using qbm and a dql for the data entry form to get the variables (an entered start and end date for the repor...

Product: Dataease [{8}]FIVE. Written by Simon B 10/09/14 at 08:25:12

if with getvalue setvalue

I have two virtual fields "ok" and "ok1". In the derivation of "ok1"I have "if(GetValue("KDNR") = blank, SetValue("OK","N"), SetValue("OK","J"))".That sould bee updated with "refreshform"? The Record is not saved jet....

Product: Dataease [{8}]FIVE. Written by Rainer 06/09/16 at 15:00:49

Re:if with getvalue setvalue

Yes. Depends on the derivation of the Virtual Fields and the order of the fields.If the virtual fields that are set are after the one that "manipulate" them them derivation of the virtual fields will "trump" your attempts to set t...

Product: Dataease [{8}]FIVE. Written by DataEase 07/09/16 at 08:44:18

On the blog about GetValue