471 results found
-
Notification on database errors or problems when first connected to database
When first connected to a database, show and arrange the database's problem places by severity:
- critical
- problem
- satisfactory
- excellent
Then, offer a solution to solve the problems.
1 vote -
Data comparison: mark data not matched if destination doesn't exist or is empty
When performing data comparison, test destination for existence and number of rows before comparing. If destination table doesn't exist or is empty, all data in the source can be marked as not matched, saving the time of the actual compare operation.
1 vote -
Positioning of cursor while editing
Hello,
when the editor recognizes a command it automatically adjusts the lines.
Problem ist that the cursor does not follow!
Example: You are in line 2 of your SQL command and the editor adjusts the format to 4 lines. You continue to type, but not at the end in line 4 but somewhere in the middle in line 2 of the command.Ronald
1 vote -
1 vote
-
In editor/data view screen, stop text cursor at end of row (rather than continuing onto next row)
When editing a stored proc or viewing data, right arrow moves cursor to right fields; when end of row reached, cursor automatically starts at left-most field of next row. Would appreciate ability to have cursor stop at end of row since this makes selecting data more reliable (will not inadvertently select start of next line when highlighting text).
1 vote -
1 vote
-
have find and replace while editing views, procedures, etc
have find and replace while editing views, procedures, etc
1 vote -
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 -
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
- Don't see your idea?