Start a new topic

Export SQL Statement out of the navigation tab

[This topic is migrated from our old forums. The original author name has been removed]

servus! many times i use the navigator. It would be nice if it is posible to export the underlain sql join statement into a new command tab. bye for now Edited by: johannes on 19.05.2015 09:44

[This reply is migrated from our old forums.]

Re: Export SQL Statement out of the navigation tab
Hi Johannes, Unless I misunderstand the question, the Navigator does not use a JOIN to produce the grids. It is using a pure SELECT with the key values from the selected cells in the grid from which you start the navigation. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Re: Export SQL Statement out of the navigation tab
it is possible to export the whole navigation graph into a select query. result from the attachment:-> SELECT * FROM Job t1 INNER JOIN JobTeil t2 ON t1.Id = t2.JobId
[This reply is migrated from our old forums.]

Re: Export SQL Statement out of the navigation tab
Hi, DbVisualizer doesn't use a JOIN like that. It uses a plain SELECT on the target table with a WHERE clause made up from the elected key values. Best Regards, Hans