Gustav Brock
Gustav at cactus.dk
Thu Feb 22 09:06:03 CST 2007
Hi Rusty You could add a field for a user-id, session-id, timer value or just a random GUID which is set automatically by the app to identify the user or call, and then filter on that. /gustav >>> rusty.hammond at cpiqpc.com 22-02-2007 15:54:19 >>> Shamil, Your earlier example of using a parameter table is interesting but you mention it doesn't work well in a multi-user environment, how would you get around the multi-user issue? Jim/Eric, I dynamically update the pass-through query as the link Eric gave suggests but I haven't run into any stability issues using this method (that I'm aware of). Have you seen any specific issues that you can point me to that I need to look out for? I'm using this in an app for our company that gathers data from other databases to produce invoices to our clients. This app is used by most of our more than 400 in-house users. Granted they won't all be running the reports that use the pass-through. Thanks, Rusty