I found that IDEA is the best tool for DB work if switching from QMF I've found so far.
But I have some open questions:
- How to use the query parameters? It seems that you can specify some placeholders in your queries and supply values for them -- as I understood the docs. But I'm to stupid to find out how you can specify them in the statement. Can someone help me out?
- What is the best way in IDEA to store statements for reuse? The history is not the best place because you cannot name the statements in any way and searching for the correct query is cumbersome.
Thanks in advance!