Re: How to get username in SQL form.

---- original message from Kevin Johnson ---- ++ ++ I'm using SQL 4.1. Does anyone know how to capture the ++ user's name in a form? select USERNAME into WhoAmI from <anytable> where <any condition that returns one row> let <screen field> = WhoAmI ++ ++ I would like to know who initially logged in the record, ++ who changed the record and who logged out the record. ++ I've have 3 columns to accomodate by don't how. ++ ++ Thanks for any advice. ++ ++ Kevin ++ -- Jerry M. Denman -- Director of Special Projects Sherwood Systems (a division of Sherwood Mfg Co. Inc.) jerry@sherwood.com ------------------------------------------------------------------------------ The manner in which one endures what must be endured is more important than the thing that must be endured. - DEAN ACHESON