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.
 

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

Switch Function 5
CurrentUser issue 2
Show all records in query if conditions is false 5
Pass Through Query - not returning rows 1
Pass through queries 1
Like "* " and function to pass parameters into a query 4
Question on Pass-through Query 4
slow append query from a pass through query 4

Back
Top