295 results found
-
Can I export the "source" of a report as php-script
To design a report with the studio and exporting it as a php-script for easy include or link.
best,
Philipp1 vote -
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 -
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 -
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 -
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 -
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 -
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 -
It would be great if it would be possible to add some description/comment for a table/relation to the layout-view (in master-detail-mode)
It would be great if it would be possible to add some description/comment for a table/relation to the layout-view (in master-detail-mode)
1 vote -
1 vote
-
Add CURRENT_TIMESTAMP tick box option for Default field in Column Properties dialogue box.
This is an extension of the feature already implemented here:
EMS' MySQL Manager software has ability to set this as a tick box option, along side the option for Update current_timetamp.
Annoying to have to type in CURRENT_TIMESTAMP into default box each time when that is the most likely default option each time you create a timestamp field.
Thanks,
Tim.1 vote -
Bring back "is not blank" quick filter in Session Manager
It used to be, until version 6.3, that in the session manager, you could filter a column for "is not blank", which made it easy to see only active sessions. Now we have to go in a dialog for that.
Either bring back the quick filter, or make the session manager save it's state so that it comes back with the same filters when you restart dbForge Studio.
1 vote -
In schema synchronization script add new columns before dropping old ones
When generating schema synchronization script, add new columns (which are existing in the Source object and are missing in the Target object) before dropping old ones (which are existing only in the Target object).
This will preserve data integrity.
1 vote
- Don't see your idea?