Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

User name in XI SQL Command

Status
Not open for further replies.
chelle31

chelle31

Programmer
Sep 22, 2005
1
US
I need to grab the user name of the person logged into CE and put it in my SQL Command. I need to do this because this is how we've implemented row level security. I've tried using a filter but because of the amount of data my query brings back when I need to return data for all users, it takes way too long. Does anyone have any suggestions or examples of what I can try?

Thanks!
 
Status
Not open for further replies.

Similar threads

Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
630
dgillz
dgillz
Dimitrie1
  • Locked
  • Question
string parameters in command
Replies
3
Views
638
kray4660
kray4660
Ray M
  • Locked
  • Question
Database logged in user
Replies
2
Views
689
Ray M
Ray M
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
981
LyleU
LyleU
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
598
Ivan Kok
Ivan Kok

Part and Inventory Search

Sponsor

Back
Top