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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Parameter Function 2
CurrentUser issue 2
Pass Through Query - not returning rows 1
Switch Function 5
Like "* " and function to pass parameters into a query 4
pass through query variables 8
Question on Pass-through Query 4
Using pass-through query results in forms 0

Top