473 results found
-
auto-refresh option for queries
Many times while I am coding on left monitor (perhaps a setup screen, or something that adds to a queue) I watch plsql developer in my right monitor refreshing a query every 2 seconds and if the new record appears then I know that it worked correctly otherwise I need to dig deeper into the code. With dbFordge I would constantly have to click the refresh button and if there were any parameters I'd have to see the parameter entry screen on each refresh. I use this feature regularly when tracking down bugs. It is a real convenience.
1 vote -
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 -
Ability to import several tabs from single Excel file at once
add a feature to import excel tables with several Regions because when you import the first region (or TAB) the action finishes and you have to begin again open the same file and perform the same action. I'm importing a 300 tables with 262000 records each one and is very difficult to open each file 5 times!!
1 vote -
Error when importing DBF file with field type CURRENCY
A have dbf files with FoxPro database. When i trying to import file with CURRENCY datafields I get error: "Неверный или неизвестный тип колонки DBF"
1 vote
AdminDevart
(_, Devart)
responded
Could you please provide us the CREATE definition of the table into which you are importing data and the imported .dbf file so we can reproduce this issue on our side?
-
Pop up procedure and function params on Ctrl+Space like variables
Now, when we edit function or procedure, we can insert first letters of any var, then press Ctrl+Space and see list with types, tables and procedure (or function) variables. So, please add function params (or procedure... :)
6 votes -
Add option to keep AS on same line as CREATE or ALTER statements
Is it possible to have the AS stay on the same line as CREATE or ALTER ddl statements?
For example I have
CREATE VIEW vSTuff as SELECT * From tbl which formats to
CREATE VIEW vStuff
as SELECT *
FROM tblI want
CREATE VIEW vStuff as
SELECT *
FROM tbl1 vote -
md5 function value input in the data view area
Like when you use phpmyadmin by entering the value (password) and mark the function as MD5
15 votes -
3 votesAdminDevart
(_, Devart)
responded
This can be workarounded by using the MySQL command “SOURCE”. For example, in the new SQL file, you can type the following:
SOURCE .\sqlfile1.sql;
SOURCE .\sqlfile2.sql;
…
SOURCE .\sqlfileN.sql;Here, instead of the local path .\ you can specify it explicitly as follows:
d:\folder\sqlfile.sql
-
Add support for build variables/parameters
There are times when some arbitrary string or bit of code needs to be different for separate build configurations.
For example, in a project that contains numerous cross-database queries, one might need to specify the database based on which build configuration was selected.
This could be handled by providing a way to define variables (or parameters if you prefer that term) that could be placed in the table, stored procedure, etc. scripts. The variables would be replaced by values specified for each build configuration when generating the deployment (or schema change) script.
3 votes -
Create automation engine like VBA in MSOffice and CorelDraw or plugins Interface
It would be nice to have ability to develop automation scripts or plugins to allow extensibility of dbForge Studio for MySQL.
For example, I have repeating task:
1. Create backup of database A
2. Create backup of data in table b in database B
3. Overwrite database B with backup of database A
4. truncate table b in database B
5. Write data from backup of data in table b to database B
6. Performe some data modifications in database B
(all of this to produce developers copy of database from production database)I think that performing this feature will…
9 votes -
Add "Find in Database Explorer" right-click context option everywhere
Currently, the "Find in Database Explorer" right-click context option seems to only be in "Find Object" results.
It would be great to have "Find in Database Explorer" everywhere "Go To Definition" (F12) is currently found. Add a default speed key to it as well (CTRL-F12?)
9 votes -
3 votes
-
8 votes
-
2 votes
-
Add filter to save and then use the previously introduced
Add filter to save and then use the previously introduced
8 votes -
Add option to get one ALTER statement for each db change
Currently I have "nested" statements like the following and if one column add fails the rest of the query additional fails!
ALTER TABLE cmsgewaehltemodule
CHANGE COLUMN parentid parentid INT(10) NOT NULL DEFAULT 0 AFTER id,
CHANGE COLUMN seitenid seitenid INT(10) NOT NULL DEFAULT 0 AFTER parenteintragid,
CHANGE COLUMN systemmodus systemmodus ENUM('live','staging') NOT NULL DEFAULT 'live';1 vote -
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 -
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 -
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 -
4 votes
- Don't see your idea?