CDATA
This feature is to allow you to use livesql in place of loadby's as a more powerful direct way to control SQL statements. If valuedefaultinto is specified, then the value returned from livesql will be placed into this field. Any new record created will get the field specified in valuedefaultinto set to the results of the livesql excluding prefix and postfix. Make sure defaultintotable is also set, it is the corresponding table.
See paymaster defaultpay window for example of how this is used.
CDATA
This is the tablename that the field is been applied to for defaultintofield.
CDATA
Used in livesql statements. If the variable been included in the sql statement is null then include this value instead.
CDATA
Postfix is a general text area that is append to the field data when displayed. This is designed for use in livesql.
CDATA
Prefix is a general text area that is prepended to the field data when displayed. This is designed for use in livesql, to hide unneeded parts of an sql statement when conditions fail.
CDATA
By default, values retrieved will be "purified" (i.e. made database safe by escaping apostrophes etc). This can be overridden for values retrieved from fields or widgets in livesql, or set on a per-sql block basis.
CDATA
CDATA