Pass through queries - CurrentUser() function?

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
 
D

Douglas J. Steele

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.
 
Top