(RDMLX) Inspection of SQLLite bound text boxes

[billcros]

If a textbox is bound to a local table field is it possible to extract the value that is in that textbox to an RDMLX variable ? I would like to conditionally run some logic based on the text boxes value but using Get_Textbox does not give me the value that is being displayed for the text box.

[MarkDuignan]

Just to confirm the scenario ………..

You have a normal online form.

It contains a text box - whose value is set from a local (on device) SQLite table row.

When the online form submits to the server you want to get the text box’s value back into your RDMLX program?

[billcros]

Not at submission time. I would like to inspect the value of the text box when it's changed and make sure it is valid. Something else I would like to do is use the value from this text box to perform a calculation and fill in other parts of the form.

[MarkDuignan]

Is the form being used an online form or a local/offline form?

[billcros]

It could be an online or local form but when local and a textbox is bound to the local database I want to know how to inspect the value entered into the textbox.

[MarkDuignan]

The text box has an OnValueChange event.

I think you could try to attach a ExecScript operation to that event and maybe to the Enter key event as well.

The script can extract and alter the value(s) of form view elements.

In the ‘LongRange LANSA Offline Advanced Tutorial’ you should be able to find several examples that do this.

For example –
- Step A4 – Offline Script receiving and sending multiple form element values
- Appendix - Extended Client Logic – Get and Set Properties

If you can’t find appropriate material please let us know.