477 results found
-
Erro no atalho
Erro no atalho , como copiar e colar... ctrl+q para filtrar... f5 para execultar
1 vote -
9.2.105 Bug -- Cannot connect (SSL) to AWS Aurora MySQL
Using identical configuration and credentials, v9.2.34 (and previous versions) connects to my AWS Aurora MySQL instance over SSL. However, the v9.2.105 update does NOT connect. It returns a dialog stating "SSL connection error (2026): The server hello message uses a protocol that was not recognized."
I tried many configurations, but none worked. Uninstalled and downgraded, worked on first try. Updated to latest and repeated test, same failure.
1 vote -
bug in table edition with graphic table editor
the table designer has a BUG. A table column can have as a default value an internal server variable, in my case @@bindaddress. The correct way to add it (@@bindaddress), and it works. But when the table editor reverses a table definition, it misinterprets these defaults and saves it back wrong.
1 vote -
copy and paste
copy anda paste from view data and excel not work
1 vote -
horizontal toolbars
I see now a vertical tab instead of a horizontal tab as usual. I cannot figure out how to reset the app to its normal behavior. Also how do I enlarge the font of the stored procedures and table editor, it's too small for my old eyes.
1 vote -
select, copy and paste objects between diagrams
allow objects to be 'copied' between diagrams. I would like to be able to select a group of tables from one diagram and create a new diagram from those selected tables.
1 vote -
SQL notebook that can be global or per database. This can be helpful for storing and retrieving reusable SQL queries without saving files
SQL notebook that can be global or per database. This can be helpful for storing and retrieving reusable SQL queries without having to save and organize a bunch of .sql files in folders somewhere.
This is especially useful for complex queries for specific DBs or global generic ones. Also for sharing with a team.
Key word searching or tags would be nice as an option in it too1 vote -
Delete multiple rows
Hello,
When deleting multiple rows, the application deletes them one at the time.
If you could use a "IN" condition with the primary key, if any, the execution will be must more faster.1 vote -
view with a UDF calling an aggregate function adds quotes around the aggregate
I'm creating a view using the valid SQL:
SELECT dateAsString(MAX(a.dateStart)) AS LastDate ...
dateAsString is a UDF in my database that accepts a DATE parameter.
The query executes fine. When I save it in a view, though, dbForge changes the query text to:
dateAsString
(MAX(a.dateStart)
)Which, obviously, won't work.
Any thoughts?
0 votesAdminDevart (_, Devart) respondedCould you please provide us the following information:
1. Version of the MySQL server.
2. CREATE definition of the UDF.
3. The assembly file containing the functions called by the UDF. -
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) respondedYou 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) respondedCould 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
- Don't see your idea?