460 results found
-
I work much with large procedures and in there I have a lot of nested BEGIN END and IF END IF statements. It's sometimes not easy to keep th
I work much with large procedures and in there I have a lot of nested BEGIN END and IF END IF statements.
It's sometimes not easy to keep the overview.
A helpful feature would be to fade out or fade in code groups like BEGIN END and/or IF END IF.
In some situation you already have this but only on the highest level (stored procedures first BEGIN).1 vote -
I suggest you to add dividing line
I suggest you to add dividing line to connection browser. It's will be useful to divide projects on groups, if i have many similar projects.
1 vote -
output window
1) meanwhile the execution of SQL script file if I click on some other window, ant then return in output window...the output windows shows the first output...and not the (more usefull) last one.
2) please fix it! I have more than one schema. I select the first one. Open a SQL file...launch it. Ok. I open a second SQL file...THE SCHEMA CHANGE without show me the change and dbForge run the SQL script on the second schema!!! Damn it!
1 vote -
Ability to indent table name in FROM clause but have JOINS on same level as FROM
I like for format my SQL like this...
----SELECT
--------1
----FROM
--------apple AS a
----INNER JOIN
--------banana AS b
------------ON a.FruitID = b.FruitID
----LEFT OUTER JOIN
--------lemon AS l
------------ON l.FruitID = l.FruitID
----WHERE
...But the closest I can get it to do automatically is this....
----SELECT
--------1
----FROM
----apple AS a
----INNER JOIN
--------banana AS b
------------ON a.FruitID = b.FruitID
----LEFT OUTER JOIN
--------lemon AS l
------------ON l.FruitID = l.FruitID
----WHEREHow can I get the table name in the FROM clause to indent one level further?
1 vote -
I want "Edit Parametes"-Window not modal, but as a dockable window, because I often modify params, and I want to see sql-code AND Params.?
I want "Edit Parametes"-Window not modal, but as a dockable window, because I often modify params, and I want to see SQL-Code AND Params at a look
1 vote -
User defined tokens/data types.
Define mydatatype=varchar(10) is substituted throughout schema. So, Long/Lat, PostCode, Zipcode, USRN, Employee # or whatever remains consistent throughout.I wouldn't have to refer to other table defs to maintain consistency.
1 vote -
Add a reload/revert to saved file function
So that if a saved SQL query is being edited, it may be reset to what is currently saved on disk.
1 vote -
implement resuming updates necessary for slow links.
When using a slow link connection breaks occur. While pumping begins anew. Spooled file updates will eliminate the numerous repetitions and extra traffic.
1 vote -
Recognising parameters in 'design SQL' mode
When editing a stored procedure, the 'design SQL' mode is very useful to visualise and modify the design of the statement - except when the stored procedure contains a parameter. 'Design SQL' does not recognise the parameter for what it is and instead tries to interpret as a reserved SQL word and kicks out an 'unknown identifier' error. Would be great if the 'design SQL' editor would recognise the parameters and not kick out the error.
1 vote -
code completion of correlated subqueries and where exists ( .. )
Hi
Love DbForge but I find I'm always writing this sort of queryUPDATE
client
SET
client.foo = 0
WHERE EXISTS
(
SELECT
1
FROM
clientRegion
WHERE
clientRegion.clientId = client.id AND ....
)
it would be ideal if dbforge could recommend some completions for the correlated portion inside the ( ) based on fk's in the same way it does for joins.1 vote -
Stop using database name while drag and drop
when i drag&drop a table to an edit tab, i always get the database with it, like:
SELECT
*
FROM mydatabase.usersbut i want
SELECT
*
FROM usersvery often i use the sql in my code, so i always have to remove the database names
from all the selects, thats very annoying,1 vote -
Add a "Copy Column" feature.
I suggest that the currently selected object be available to Copy.
Pressing Alt+Insert launches and pre-populates the Column Properties dialog box with the column that currently has focus, but the name field is null, and the Save process doesn't overwrite.
But you know this. Awesome work. I like it.
1 vote -
Return the bulk insert on export
Please add the bulk-insert format when exporting data into SQL.
1 vote -
BUG: When Copy & Paste As New Record string values are cut off after NON-Iso characters. Just like ä ö ü. even if it is defined as UTF-8
BUG: When Copy & Paste As New Record string values are cut off after NON-Iso characters. Just like ä ö ü. even if it is defined as UTF-8
1 vote -
Can't edit view after deleting of column
When a view references a table nad/or column which got deleted you can't edit the view anymore.
I had to use phpmyadmin to edit the view just to drop the column.1 vote -
Identify commands in output window
When I run a script with lots of commands and that takes hours to run, the output only shows the file name and the execution time. Providing some information about each command that has run or is running would be very helpful.
1 vote -
Add "flatten query" option
It'd be great if there was an option that was basically the reverse of "Format Current Statement" that collapsed the query down to a one line statement (basically remove all newlines and carriage returns that were inserted during a format). This option would be helpful when copying a query back to another IDE for coding.
1 vote -
Display progress bar for data import/export process
How about a simple progress bar or indicator showing progress of import/exports. It could be as simple as "importing record 12345/67890"
instead of a progress graphic.1 vote -
Database Name Incorrect on Restore Dialog
Right-click on Database "Foo" in object tree. Select--> Backup and Restore --> Restore Database... Dialog shows "Bar" in the Database dropdown list. The Filename text box does not default to the path used for the Backup operation.
1 vote -
Sql editor window. Move Results of "Search and replace: Bookmark All", "changed" from "indicator margin bar" to scrolbar
Sql editor window: Code navigation
Make scrollbar more useful.
use color indicators on scrollbar to mark:
- "Search and replace: Bookmark All"
- "changed code"
- highlighted vars1 vote
- Don't see your idea?