This shows you the differences between two versions of the page.
dev:sql:functions:user [2009/12/05 00:52] tdo created |
dev:sql:functions:user [2016/06/28 22:38] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{page>:top_add&nofooter&noeditbtn}} | ||
- | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
- | ====== Omnidex SQL Function: USER ====== | ||
- | {{page>:sql_bar&nofooter&noeditbtn}} | ||
- | ===== Description ===== | ||
- | The USER, CURRENT_USER, SESSION_USER functions return the current user of Omnidex as entered when first connected to the current open environment. If no user was entered, the user of "DEFAULT" is returned. The return data type is a C STRING maximum length 32. | ||
- | These functions are identical. | ||
- | ===== Syntax ===== | ||
- | USER | ||
- | ===== Example ===== | ||
- | ==== Example 1 ==== | ||
- | select company, user from customers where company='dynamic' | ||
- | |||
- | Dynamic Information Systems Corporation, DEFAULT | ||
- | ... | ||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} |