Pass through queries - CurrentUser() function?

  • Thread starter Thread starter Ling
  • Start date Start date
L

Ling

Does pass through queries support currentuser()?
seems not but I have a query which should only show the
records that were created by the current user
E.g.: Sam created Quotation No 10, he can only view
Quotation No 10 as he is the creator.

Any ideas?

Thanx..

Ling
 
Since pass-through queries run on the server, they cannot interact with any
functions on the client.

One way around this would be to dynamically alter the SQL in the query
before you run it: change it so that it has the current user information as
a literal (not a function), and then run the query. It's also possible that
your server might have a built-in function that could be used.
 
Back
Top