troubleshooting Question

Parameterized View - Can we open multiple instances using aliases?

Avatar of mjacobs2929
mjacobs2929 asked on
FoxPro
2 Comments1 Solution400 ViewsLast Modified:
I have a parameterized view (called ACCOUNT_PRICESET) which works as advertised.

However, in one of my routines, I open the view and use it update other versions of the same view.

(if it helps to understand, the first view is the Price Rules for a head office and we need to create a copy of that set of rules for each subsidiary account assigned to that head office. Why? Because the subsidiaries are allowed to modify some of the rules but their starting point is what the head office negotiated)

The parameter is simply the Account Reference (PRICESETS.ACCREF=?startit.current_accref is the SQL code). So I open the head office view with the parameter set to the head office account ref. Then I change "startit.current_accref" to one of the subsidiary accounts  and use the following command

USE VIZBIZ!ACCOUNT_PRICESET AGAIN IN 0 ALIAS SUBACCOUNT

expecting a new small view consisting, this time, of the subsidiary's price set records.

Instead, what I'm getting is another copy of the Head Office records, despite the change in parameters.

This is, I think, the first time I've tried opening a parameterized view while there is already one open, so perhaps I'm breaking some rule I don't know about or, perhaps there is a procedure that will accomplish what I need in some other way.

I could, for example, set up an identical view with a different name, just for this purpose, which would be simple enough, but I'd like to understand why I can't do it as above...

Suggestions?
ASKER CERTIFIED SOLUTION
Pavel Celba
All in One

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros