Re: USER/TODAy in forms

Miguel A. Caldera aka mac@antares-dev.com wrote: { posted by: kistler@an.hp.com (Jim Kistler) { > The TODAY function seems to work okay in a form in which I want to aid { > the user by filling in today's date, but USER doesn't. { > { > How can I "capture" the $LOGNAME of the user with "USER" in a form's field? { If using a 4gl program to access the form, the function "USER" appears { to be a pure sql command that is not available in 4gl code but { can be used as a constant in a select statement. { The only way I have found to use it is as a constant in an insert or { update statement, or { (really cheesie) { select user from systables where tabname = "systables" I thought I had answered this before but: let user_var = fgl_getenv("USER") or, on some systems, let user_var = fgl_getenv("LOGNAME") -- gburnore@garys.arasmith.com -------------------------------------------------------------------------- How you look depends on where you go. -------------------------------------------------------------------------- | '۳''''''۳''''''''''''' Gary L. Burnore | '۳''''''۳''''''''''''' Director, Programming & Development | '۳''''''۳''''''''''''' Myers Information Systems, Inc. | '۳ 3 4 1 4 2 ''' 6 9 0 6 9 ''' | Official Proof of Purchase ==========================================================================