Re: User/Today functions
Miguel A. Caldera aka mac@antares-dev.com wrote: { I feel a need to enter soapbox mode. { Gburnore@netcom.com (Gary L. Burnore) posted a response to my response { which was a response to someone else's post. { The original post was how to use the USER and TODAY functions. { Mr. Burnore's method included the words "or, on your system". { My statement from the soapbox is that this is fine for those of us { who do custom development for a given platform, but for those of us { who do applications meant to run on any platform that Informix runs on, { words like "or on your system" are not really acceptable. { This falls into the same category as saying that nroff and the like are { the ultimate solution for pretty printer output. This is one of those { things that may or may not exist on the target system, and requiring { the end user to buy extra things to run your software is like asking { the customer to buy everything from somebody else. { I could go on , but the soapbox timer has expired :^) And a good thing too! Mine's just starting. :| There is nothing extra to buy. There's no xternal program to run. This is NOT like using nroff for pretty printer output. I've stated in previous posts that everything we write must be self contained in Informix because of our clientel. PBS television stations. They don't have a lot of money to spend so telling them they have to have extra stuff won't do. So we do all our pretty reports inside of Informix. As for the ability to extract a user name into informix: define uservar char(8) let uservar = fgl_getenv("LOGNAME") # Works on most systems but jjust i case you're on one that it doesn't work on, do this: define uservar char(8) let uservar = fgl_getenv("LOGNAME") if uservar is null or uservar = " " then let uservar = fgl_getenv("USER") end if There, I feel much better. Anyone else wanna get on the soap box? :) -- 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 ==========================================================================