Brian, I don't have the control over changing the fields. We bought a proprietary system that built on UniVerse. To access the data, I use UniObject and SQL SELECT statements.
Anyway, does that mean SQL SELECT is not "compatible" with the Tfile fields? Are there any tricks or tips that I can use to still SELECT the Tfile fields? Thanks, TA -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Saturday, May 05, 2007 4:13 AM To: [email protected] Subject: RE: [U2] How to SELECT (SQL) a TFile field? 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
