Dynamic Field Validation Progress-4GL -

created process links enterprise data xml file in progress 4gl database ... using dynamic queries, pass table name, field name , it's value include uses temp-table copy of table populating ... hoping not have write specific validation clauses each field being populated ... expectation schema validation clause kick in when field being written ... expect might have validation clauses actual table field, build runtime program validation. hndfield:validation-expression , hndfield:validation-message ... kind of defeats purpose of having dynamic query if have build runtime validation program each field.

concepts causing me grief:

using: define temp-table blah foo.

1) doesn't appear include foo validation clauses on fields in blah (confirmed viewing hndfield:validate-expression ... returns ? temp-table fields) if assign foo validation , message temp-table field, doing update blah.somefield not validated.

2) using dynamic query with; assign hndfield:buffer-value = "somevalue" no-error. if query using foo instead of blah, assignment doesn't use schema field validation clause ... added validate foo no-error.

3) buffer-copy blah foo doesn't appear validations

how else can force schema validation keep data linking purely dynamic?

have tried adding 'validate' option?

define temp-table blah foo validate. 

that work (or bad) normal validation.

from online help:

validate

the temp-table fields inherit, dictionary, validation expressions , validation messages database table, table-name.

personally prefer keep validation in code , out of database. @ least except basic validation (perhaps making sure there's master record detail record).

i find dictionary approach limited , hard maintain. guess that's opinion based.