12 results found
-
BUG VIEW SUMMARY ROW COUNT
dbforge-mysql
There's a bug in summry view of tables.
In summary view = 2039 rows count
In retreive table data = 2657 row.This bug is UNACCEPTABLE....
3 votes -
Change of variables by continue handler not recognized by debugger
I use continue handler to handle the end of row in a cursor in an stored proc. While debugging the debugger does not recognize when the handler fires an changes a variable. The debugger-value-tooltip for that variable still displays the old, unchanged value after the the handler fired.
3 votesUnfortunately, we can not fix the issue for technical reasons.
Workaround:
Please use BEGIN…END block around the handler statement.
For example:
DECLARE CONTINUE HANDLER FOR NOT FOUND
BEGIN
SET l_nomore = 1;
END; -
The data view goes into edit mode when you click on a date value (and shows the date chooser) even when the table is in read-only mode.
The data view goes into edit mode when you click on a date value (and shows the date chooser) even when the table is in read-only mode. Date columns should behave like all other columns in read-only mode; that is, the date chooser should not come up at all.
3 votesSuch behavior is by design. The field stays in the read only mode despite the date picker pops up.
-
remove @@last_insert_id global variable
Your autocomplete for mysql includes a global variable @@lastinsertid -- AFAIK, no such global exists; it's a function call, so it should fill with lastinsertid() instead.
3 votesThis can be both server system variable or function. For details, please refer to http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
-
Russian text did not correctly displayed in database/tables with latin1 charset
Database and table have latin1 charset but nor in manual nor in charset autodetect mode russian text did not correctly displayed
2 votes -
Problem when opening SQL file having utf8 without BOM
When opening sql file containing Cyrillic symbols and being in the utf8 encoding without BOM, the encoding is determined as win1251 and it seems to be not possible to change it.
1 voteYou would need to select the ‘Unicode – (UTF8)’ encoding in the ‘Encoding’ dropdown menu of the ‘Open File’ dialog.
-
fix automatic change schema when open SQL file
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 voteWhen you open an existing SQL document, it’s assigned to the database that is currently selected in Database Explorer. You can redefine it in the ‘Database’ drop-down menu on the ‘SQL’ toolbar.
-
Date fields can revert to NULL when adding new rows
When adding a new row that contains date fields the fields are defaulted to today's date/time. However when you tab through those fields they revert to NULL unless so specifically select a date using the picker or re-type it in.
1 votePlease note that once you click the ‘Refresh’ button on the toolbar of Data Editor, the correct data will be displayed instead of the NULL value.
-
Import fails with message "unknown error occurred when reading from data source"
Trying to import from FileMaker pro db via ODBC driver. ODBC driver tests fine on ODBC Options screen, but returns error "unknown error occurred when reading from data source" on the Destination Table screen.
1 voteThis is the issue of Microsoft .NET Framework since it doesn’t work with the ODBC driver under x64.
-
Perfecta!
Muy buena ! Me encanta...
1 vote -
Count of records not changed when filtered
When a table if filtered the value of displayed records at the bottom ("Record x of y") is not changed.
1 voteThis is by design.
The overall amount of the records returned by the query doesn’t change despite the initial records set returned by the query is filtered.
-
0 votes
Please note that dbForge SQL Complete formats the whole CREATE PROCEDURE statement the selected part of text belongs to. Such behavior has advantages as separate statements get indented inside a CREATE PROCEDURE statement. Though, this behavior will be reconsidered and may be changed in future product versions.
Also, you can vote for the following suggestion on our UserVoice forum: http://devart.uservoice.com/forums/87893-sql-complete/suggestions/3738223-make-format-selection-to-format-what-is-actually-s
We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.
- Don't see your idea?