Re: How to get username in SQL form.

In an SQL form this is very difficult. In 4GL I normally use SELECT USER INTO userid FROM systables WHERE tabname="systables" and then display this to the form. If it is really essential to do this in SQL it will require BEFORE EDITADD of field CALL C routine. Malcolm Weallans Online Database Consultancy 2 Arkley Court Maidenhead Berks SL6 2YR Phone 0628-72154 Fax 0628-37463 CIX - onlinedbc