472 results found
-
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 -
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 -
MLM software developers in Utah
MLM Software Developers in Utah offer cutting-edge solutions for network marketing businesses. With tailored software, comprehensive features, and round-the-clock support, we empower MLM enterprises to thrive. Maximize efficiency and scalability while ensuring top-notch security with our expertly crafted solutions. Partner with us to elevate your MLM business to new heights. https://www.mlmsoftwarecompany.in/mlm-software-company-Utah/
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 -
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
- Don't see your idea?