06-02-2011 4:48 PM
Does anyone knows how to remove tables from SQVI Quick Viewer once the join's already created?
It was inserted 3 tables (LFA1, LFB1 and LFM1) so I just need to remove the last one from there.
I've tried many threads in the forum but most of them has no helpful answer and some others are too old and outdated.
Some of the suggestions says to just re-create it. But, is it really the only solution?
Thanks in advance.
Rafael.
06-02-2011 6:07 PM
Goto SQVI Quick viewer in change mode, when in Basic mode - Click on the "Data Source" tab and click on "Change Join" to navigate to Quick viewer design screen ( graphical ). Select the LFM1 table window and click "Delete" ( or Edit-> Delete table ).
06-02-2011 6:07 PM
Goto SQVI Quick viewer in change mode, when in Basic mode - Click on the "Data Source" tab and click on "Change Join" to navigate to Quick viewer design screen ( graphical ). Select the LFM1 table window and click "Delete" ( or Edit-> Delete table ).
06-02-2011 6:53 PM
Thanks for answering Suman.
This is the most suggestive and basic solution and this was what I tried first.
I have no success doing in this way so I decided to open this thread.
Any other suggestion?
06-02-2011 7:08 PM
Can you tell whats the issue you are facing executing the suggested procedure? Also the data source you are using.
Edited by: Suman Jagu on Jun 2, 2011 2:11 PM
06-02-2011 7:16 PM
It shows: "Tables of the joins can no longer be deleted in QuickViewer".
01-14-2020 2:43 PM
06-02-2011 8:20 PM
Hi rvsilvax,
what reason ever: It's not possible. No way, re-create a new one. Will take you less time than finding out why it does not work with the table deletion.
@Suman Jagu: On what release did you have success?
Regards,
Clemens
06-02-2011 9:01 PM
06-02-2011 9:30 PM
Clemens, thanks for your answer.
I got the same conclusion, just wanted to rise up a question here to make sure it was indeed impossible.
Thank you Suman!
06-03-2011 8:27 AM
Hi Suman,
thank you. Congratulations. Your 4.70 Enterprise is different.
Regards,
Clemens
07-05-2016 7:44 PM
I know this is old , but I have a workaround for this problem: right click on the link to the table you don't want anymore and set it to "left outer join". This will make the table rather irrelevant on your selection, as if you had eliminated it.
01-14-2020 2:41 PM
02-24-2023 11:16 AM