Re: getting login name in 4GL

Dennis J Pimple wrote: > > > Quibbling; > I don't think there's any guarantee that tabid = 1 will alway be in the > database (I vaguely recall that some sort of ALTER TABLE or UPDATE > STATISTICS caused the tabid to be something else), so: > > SELECT USER INTO login_name FROM systables WHERE tabname = "systables" > > Might be better. Dennis, indepedent of this issue can you or someone else from Informix definitivily clarify if there is ever a chance that a record with tabid=1 may not exist in the systables table in any Informix Engine Version. Vaguely statements can only cause confusion. Regards Tolis +---------------------------------------------------------------------+ | V+K Relational Solutions email: tvarnas@compulink.gr | | Deligiorgi 26 tvarnas@orbit.de | | 546 42 Thessaloniki Voice: (30) 31 820270 | | Greece Fax: (30) 31 865463 | +---------------------------------------------------------------------+