467 results found
-
scroll 'wheels' do not work
Whether used on my laptop with a touchpad or my desktop with a mouse, dbForge Studio doesn't support scrolling in any window by any means other than clicking or dragging the scroll bar. It will initially scroll for perhaps a second and then it stops.
0 votesAdminDevart (_, Devart) responded
You could try the following instructions http://www.microsoft.com/hardware/en-us/help/windows-8/how-to/mouse/use-partialscroll-mouse
-
Fix Stored Procedure Editor to accept ALTER TABLE xxx RENAME TO yyy
As of dbForge for MySQL version 8.0.40, the Stored Procedure Editor (and Schema Compare) have started to throw errors when trying to open one of our stored procedures. I have traced it down to the presence of an ALTER TABLE command within the procedure.
Here is a simple procedure that will trigger the error:
DELIMITER $$
DROP PROCEDURE IF EXISTS sp_test$$
CREATE DEFINER=
root
@localhost
PROCEDUREsp_test
()
MODIFIES SQL DATA
BEGINALTER TABLE foo RENAME TO bar;
END
$$DELIMITER ;
Specifically, if you try to open the procedure in the procedure editor, dbForge will display the error…
0 votesAdminDevart (_, Devart) responded
Could you please provide us the following information:
1. Server version.
2. Result of the following query:
SHOW CREATE PROCEDURE sp_test;You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
-
compare objects via right-clicks
compare source objects, table def & data via right-clicks (See Beyond Compare@ScooterSoftware.com)
0 votes -
table change -> view update (with preview)
When making a table change, validate all source objects / views (in case of column name change). Provide list of objects that this update affects and allow double-click to edit or view update (with preview) Beyond Compare style!
0 votes -
0 votes
-
Gutter (right margin)
Add gutter (aka right margin) for code inspections.
0 votes -
Make it understand macroses used in UniDac
It would be great if dbForge Studio for MySQL understood macroses, that are used, for instance, in UniDac, or just ignored them.
Currently, if you copy code from the TUniQuery SQL editor, you need to then edit it. Once it has passed debugging, you need to edit it once again in TUniQuery SQL editor. It's quite uncomfortable and sometimes takes much time.
Also, code formatter converts &dtstart into & dtstart (i.e adds space after ampersand (&).
0 votes -
Adapt Edit Parameters window for macroses
When there are parameters in code, dbForge Studio for MySQL automatically offers to enter them.
Adapt the Edit Parameters window for macroses as well. Users should be able to enter macroses' parameters or select an option to ignore them.
0 votes -
Put SQL into Excel Export
when doing exports in excel, it would be perfect to have the SQL (used for this export) in seperate sheet called "SQL" in the generated excel file.
it happens very often that you send an export to someone, and after a few days he needs a modification of this export. then i always have to search for the SQL i used fot this export.
if the SQL would be inside the excel, it would never get lost.currently i put it inside manually, but it would be great to have this feature "by default" or as an option at the…
0 votes -
Add ability to preserve custom code in both mapping and class files through "custom code region"
Add a feature to preserve custom code in mapping and class files through "custom code region"
0 votes -
Add "Edit View Visually" under "Edit View" on Database Explorer
When right-clicking a view in Database Explorer, add the "Edit View Visually" command under "Edit View" in the popup menu
0 votes -
When selecting 'Design SQL' command, make it possible to minimize Query Builder diagram
I don’t see how I can have a few VIEWs open simultaneously (in the designer). I’m used to having at least 5 open at a time, often 20 or more. Well, without names that’s impractical anyway. Right-Click / Design View seems to disable further exploring – I can’t minimize it. Wow! Hope I can have several instances open simultaneously.
0 votes -
Assign selected in Database Explorer database to current SQL document
When working with a SQL document, make it possible to specify the default database of the document by simply selecting it in Database Explorer (similar to Heidisql) rather than selecting it from the 'Database' dropdown menu on the 'SQL' toolbar.
0 votes -
Ability to select action when drag'n'dropping object onto SQL document
Show dialog suggesting to select an action (SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP) when drag'n'dropping object from Database Explorer onto SQL document like in EMS SQL Manager for MySQL.
0 votes -
Show up non-declared variables (i.e. @xyz) in autocomplete suggestions
A user variable (AKA:session variable) not showing in the autocomplete list. Variables defined using the DECLARE syntax show up fine but those created using the "SET @" method do not.
BEGIN
DECLARE v1 INT; SET @v2 = 1; SELECT 1 FROM users AS u WHERE
END
0 votes -
Find and Replace in object DDLs
We were thinking about getting this software for its refactoring capability, but when we tried it out, all it does is allow us to rename tables. What we want to do is change a signed integer to an unsigned integer.
0 votes -
Add alternative ways to open table and ability to open many instances of same table
Please add a switch key (SHIFT, CTRL or ALT) to the left mouse click behavior to open a table in design, text or data view with a single click.
Also please give the ability to open many istance of the same table in data view to be able to apply different conditions in the Filter Editor for the same table.0 votes -
0 votes
-
Slow Query Log and General Query Log
Make it similar to query analyzer in MONyog.
0 votes -
Make constructor understand variable with no @
Make the constructor understand a variable with no @
Currently, the constructor doesn't understand a variable having not specified @, so you need to add it manually.0 votes
- Don't see your idea?