Re: How to get username in SQL form.
> Kevin Johnson (kj@ix.netcom.com) wrote:
> : I'm using SQL 4.1. Does anyone know how to capture the
> : user's name in a form?
>
> select user from systables
> where 1 = 2
Yuk! Looks like the kind of nonsense Uniface would generate. Ugh!!
Definitely a sequential scan job. Avoid!
Not only that, I'm not sure it would actually return anything as the
where clause would never be true...?
Try:
select user from systables
where tabid=1
Quick, easy.
akent@cix.compulink.co.uk (Andy Kent)
-------------------------------------