I'm considering removing the schema view from ViennaSQL and writing a separate schema browsing application. If I go ahead with this, I will add drag & drop so table and column names can be dragged from the schema view into the query editor.
Comments on this proposal are invited.
Incidentally, I will be working for Oracle Development at Thames Valley Park, Reading, UK from mid-February. I will only continue with ViennaSQL development if the management there agree (there is a potential conflict of interest -- I will be working on Oracle's tools!)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2001-02-12
Mike,
Being able to individually drag/drop table/column info into a Select would be great (we have dozens of schemas and hundreds of tables per schema - "bewildering" takes on new meaning).
Not to add to your woes, but would you consider option to drag a "template" statement (e.g. SELECT col1, col2,,,coln FROM |selected table| WHERE ..) which embeds all the column names from the selected table. The user could then delete any desired column names to achieve the SQL he/she needs. Perhaps a keyboard shortcut like ALT+D for a Delete Statement, ALT+U for an Update, ALT+S for a Select and ALT+I for an Insert. The resulting template statement could be parachuted into the Query editor pane from whence it could be saved as a "stock" sql for later use.
Food for thought.
Thanks - Hal
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
That's a very interesting idea. I had wondered if there was some way to generate the actual SQL rather than simply dragging column and table names. I had come to think it wasn't on, now I will have to think again. Thanks for the post. When I'm next ready to do some coding, I'll get in touch to discuss this further. (Life is a little busy at the moment, so I haven't been doing any work on ViennaSQL).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2001-02-12
Mike,
Another thought... I was thinking this tool could be enhanced if it could permit users to load tables visually. Currently, since no statements can end in a semi-colon, it's not possible to handle more than one SQL Statement per query. Would you contemplate permitting parsing for semi-colons and looping through in the case of multiple statements.
Or.. perhaps this idea is better left to a tool like a SQL loader...
If it were plausible, I suppose one would have to spawn off a log of how the batch of SQL's ran, in the event that one failed.
Creating and populating base tables would be great through this tool if it permitted "batch" SQL's.
Thanks - Hal
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I realise having one query per tab is a limitation. I wondered about improving on that, but I feel it would go beyond what I originally wanted from ViennaSQL -- a simple visual query tool. I'm not ruling it out, but it's on the back burner for now.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm considering removing the schema view from ViennaSQL and writing a separate schema browsing application. If I go ahead with this, I will add drag & drop so table and column names can be dragged from the schema view into the query editor.
Comments on this proposal are invited.
Incidentally, I will be working for Oracle Development at Thames Valley Park, Reading, UK from mid-February. I will only continue with ViennaSQL development if the management there agree (there is a potential conflict of interest -- I will be working on Oracle's tools!)
Mike,
Being able to individually drag/drop table/column info into a Select would be great (we have dozens of schemas and hundreds of tables per schema - "bewildering" takes on new meaning).
Not to add to your woes, but would you consider option to drag a "template" statement (e.g. SELECT col1, col2,,,coln FROM |selected table| WHERE ..) which embeds all the column names from the selected table. The user could then delete any desired column names to achieve the SQL he/she needs. Perhaps a keyboard shortcut like ALT+D for a Delete Statement, ALT+U for an Update, ALT+S for a Select and ALT+I for an Insert. The resulting template statement could be parachuted into the Query editor pane from whence it could be saved as a "stock" sql for later use.
Food for thought.
Thanks - Hal
That's a very interesting idea. I had wondered if there was some way to generate the actual SQL rather than simply dragging column and table names. I had come to think it wasn't on, now I will have to think again. Thanks for the post. When I'm next ready to do some coding, I'll get in touch to discuss this further. (Life is a little busy at the moment, so I haven't been doing any work on ViennaSQL).
Mike,
Another thought... I was thinking this tool could be enhanced if it could permit users to load tables visually. Currently, since no statements can end in a semi-colon, it's not possible to handle more than one SQL Statement per query. Would you contemplate permitting parsing for semi-colons and looping through in the case of multiple statements.
Or.. perhaps this idea is better left to a tool like a SQL loader...
If it were plausible, I suppose one would have to spawn off a log of how the batch of SQL's ran, in the event that one failed.
Creating and populating base tables would be great through this tool if it permitted "batch" SQL's.
Thanks - Hal
I realise having one query per tab is a limitation. I wondered about improving on that, but I feel it would go beyond what I originally wanted from ViennaSQL -- a simple visual query tool. I'm not ruling it out, but it's on the back burner for now.