How Uniface is building select clause. In one form, I can see few fields in select clause. In some other form, select clause has different fields though where clause is same in both form.
How Uniface is building select clause. In one form, I can see few fields in select clause. In some other form, select clause has different fields though where clause is same in both form.
How Uniface is building select clause. In one form, I can see few fields in select clause. In some other form, select clause has different fields though where clause is same in both form.
Hi Ajeet,
by default Uniface compiler build a fields list of each entity included into a component; this field list is composed by:
- fields picted on paint tableau
- fields referred into component triggers
The fields list of each entity is used for DBMS access of the component.
As a developer you can change this default behaviour using the specific component property called "fields list"; possible values: [Default], AllFields, UserDefined.
More info here.
Hope it helps.
Gianni
+3How Uniface is building select clause. In one form, I can see few fields in select clause. In some other form, select clause has different fields though where clause is same in both form.
Hi Ajeet,
Beside the answer from Gianni have a look at $selectlist
Ingo
How Uniface is building select clause. In one form, I can see few fields in select clause. In some other form, select clause has different fields though where clause is same in both form.
Hi Ajeet,
It depends....
Uniface Query By Form....
Form A:
Fields A,B,C have values in them, and you have a read u_where / where
select clause will contain A,B,C and whatever you have in u_where/where
Form B
Fields A,D,E have values in them and no read u_where/where.
select clause will contain A,D,E.
Remember,
By default Uniface will (should!) fetch all fields in an entity - because Uniface doesn't know
until runtime what the specific database is (RMS vs Oracle vs MSS etc). However, only the fields
listed in the fields list should be / will be formatted for output. In the long gone past, this
formatting was done in (as far as I can remember) blocks of 4 fields... What it is today I cannot speak to.
In addition, the $selectlist statement can be 'dangerous' - as in, there could be fields in the record
updated by another user, and you don't get to see that because the record you're looking at contains
a subset of the columns... Use with caution....
hth,
Knut
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
