The best option is probably to change them into TRANS() or XLATE() fields.
Much more user friendly. If you're not familiar with the syntax:
1> I
2> XLATE("filename",keyfield,remote_field_number,"X")
3> conversion
4> header
5> length just
6> S or M (Single/Multivalued)
or
2> TRANS(filename,keyfield,remote_field_name,"X")
eg.
I
XLATE("CUSTOMERS",CUSTNO,1,"X")
MCU
Surname
20L
S
or
I
TRANS(CUSTOMERS,CUSTNO,SURNAME,"X")
MCU
Surname
20L
S
Also if you want SQL compatible dictionaries it's a good idea to avoid periods
in the name (underscores are fine).
And remember you can use EVAL expressions as well.
Brian
I have some Tfile fields in the DB. I can select them using the LIST
command but I am having trouble to do so with SQL SELECT command.
How to select the fields with SQL Select?
Thanks,
TA
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
