Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am looking for an idea how best to do this:
- I have built a report that shall be usable in either of two plants with two separate databases:
=> The user types the name of the one or the other plant and a variable is consequently filled (inside a SWITCH...CASE... statement) with one of two file_path_variables which again lead to the file_path of the qvd_file for the corresp. database.
So far, that's working fine.
<=> In one plant, the primary data_loading script is slightly different: The table in question is there called >>Receiving_Header<< whereas in the other load_script, it is called >>Rcv_Hdr<< - and the fields are all qualified, so I cannot use the same LOAD for both databases.
Now, a possible solution would be to use another SWITCH...CASE statement and write two different LOADs depending on the plant that the report is being run for.
My question is: Is there an easier solution that wouldn't require me to write two separate LOAD statements?
Thanks a lot!
Best regards,
DataNibbler
Hi Marcus,
the idea of assimilating the two load_scripts is good - but it would be just too much effort to adjust all the apps "further down" which happen to use qvd_files from both plants.
The plants have separate databases, that is why we have separate load_scripts.
Okay, I guess I'll just have to adapt my script and use two separate LOADs for the different plants.
Best regards,
DataNibbler
Hi DataNibbler,
a solution might be to remove the differences between those loadings (you might need some additionally step to adjust othe rparts in your environment and/or to store these qvd's twice - one time not qualified and another with qualifying).
Beside your differences in the load-script it might be an alternative approach to load in general both plants and the differentiating between them happens per selection (maybe with triggers) or per section access.
- Marcus
Hi Marcus,
the idea of assimilating the two load_scripts is good - but it would be just too much effort to adjust all the apps "further down" which happen to use qvd_files from both plants.
The plants have separate databases, that is why we have separate load_scripts.
Okay, I guess I'll just have to adapt my script and use two separate LOADs for the different plants.
Best regards,
DataNibbler