(RDMLX) Inspection of SQLLite bound text boxes

Please mark posts as being for RPG or RDMLX (LANSA) developers.
To subscribe by email, display this forum, scroll to the end and select ‘Subscribe Forum’.
Post Reply
billcros
Posts: 18
Joined: Fri Apr 11, 2014 7:27 am

(RDMLX) Inspection of SQLLite bound text boxes

Post by billcros » Wed May 28, 2014 12:41 pm

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
Posts: 345
Joined: Tue Apr 17, 2012 7:33 pm

Re: Inspection of SQLLite bound text boxes

Post by MarkDuignan » Tue Jun 03, 2014 8:26 pm

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
Posts: 18
Joined: Fri Apr 11, 2014 7:27 am

Re: (RDMLX) Inspection of SQLLite bound text boxes

Post by billcros » Wed Jun 04, 2014 5:29 am

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
Posts: 345
Joined: Tue Apr 17, 2012 7:33 pm

Re: (RDMLX) Inspection of SQLLite bound text boxes

Post by MarkDuignan » Wed Jun 04, 2014 5:01 pm

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

billcros
Posts: 18
Joined: Fri Apr 11, 2014 7:27 am

Re: (RDMLX) Inspection of SQLLite bound text boxes

Post by billcros » Thu Jun 05, 2014 5:25 am

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
Posts: 345
Joined: Tue Apr 17, 2012 7:33 pm

Re: (RDMLX) Inspection of SQLLite bound text boxes

Post by MarkDuignan » Thu Jun 05, 2014 5:31 pm

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.

Post Reply