[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
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
a
anonymous
said
about 8 years ago
[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
Hans Bergsten
said
about 8 years ago
[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
anonymous