134 results found
-
Improve code completion support for OPENJSON / WITH fields
When OPENJSON along with WITH to list fields to pull from the JSON data the fields are not visible for code completion purposes. For example in the query below there is no code completion for B.* in the select list and the fields need to be entered manually.
SELECT PD.ProductDimId AS ProductDim
, [Date] = CAST(JSONVALUE(J.JSONData,'$.fields.trandate') AS DATE)
, TONumber = JSONVALUE(J.JSONData,'$.fields.tranid')
, TransactionInternalId = J.InternalId
, [Status] = JSONVALUE(J.JSONData,'$.fields.status')
, Line = B.line
, B.Quantity
, TOCurrentValueUSD = B.CurrentUSDValue
, TOLandedCostPerItem = b.LandedCostPerUnit
, FromLocation = CASE JSONVALUE(J.JSONData,'$.fields.location') WHEN 16 THEN 'In Transit/On Water' ELSE…4 votes -
Cannot describe object
List object name when an error occurs. Example a synonym on a server that is off line. Generic error says can not connect to server.
1 vote -
Option to set comma as the default delimiter for CSV export and copy functions
Currently, unless you override it, the semi-colon is used as the default delimiter for all CSV export and copy functions. It would be very helpful to be able to set the comma as the default in options.
3 votesThis can be setup in the ‘Data Export → CSV’ section of the ‘Options’ window (select ‘Tools → Options…’ from the main menu).
-
copy column data as comma seperated string
I often find myself copying a list of data from a column to be used in another where clause and manually adding the commas. It would be great I could copy a list of values from a column and paste the values separated with commas
1 voteThis can be performed by right-clicking the data grid and selecting ‘Copy Data As → CSV’ from the popup menu.
-
Update Developer Express Grids to current version
I see that you are using Developer Express Grids and controls but that you are using version 13 compared to the current version 19. Please update the grids and controls to the current version and allow users access to most of the features those grids provide.
3 votesIt’s updated to version 20.
-
It's not possible to remove object filter in scomp document
After searching for an object, if you clear the filter, data is not displayed
10 votes -
Crash when pasting tab-separated data
I have data in a text editor which is tab-separated. I copied one line from the text editor with 44 tab-separated integer values no higher than 788 to the clipboard. I then opened a table with 100 columns in edit mode, pressed insert to add a new row and pasted the copied line. The line looks fine at the moment (before sending crash report and restarting), i.e. the paste operation seams to work on the visual layer, but then the crash report showed up.
1 vote -
Change default encoding for saving script files
Default file save encoding is UTF-8. Would be nice to be able to change the default to something else, e.g. Western European (Windows) -Codepage 1252 to make it easier to work with those scripts in other tools.
1 vote -
Prevent auto format when opening stored procedure
When I open an existing stored procedure with Modify menu item, dbForge studio formatting is automatically applied. Is there a way to prevent this?
6 votes -
better copy to clipboard feature of CSV data
when i view a query result, i see all the records selected. i need a quick way to select these records and import into excel. the current copy to csv to clipboard separates the data with a semicolon. when i paste this to xls, it puts each row into cell A. i have to save the file and then import to xls and change the field separator to a semi colon.
thanks
1 voteThis is governed by the ‘Field separator’ option in the ‘Data Export → CSV’ section of the ‘Options’ window
https://snipboard.io/4OEiKT.jpg -
Return back Ctrl+Shift
That combination is used to switch between Windows languages. In the latest update dbForge awaits pressing some additional key upon Ctrl+Shift. Because of this, the first letter is not printed after pressing Ctrl+Shift.
Let combinations with Ctrl+Shift to work only when these keys are hold down.
1 vote -
Use SpaceBar to auto complete words and names
when auto complete drop-down appear, we need to use space-bar to complete the word like as visual studio or ssms.
3 votesThis can be setup as follows https://snipboard.io/uqb2m9.jpg
1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Text Editor → Code Completion → List Members’ branch.
3. Select the ‘Whitespace’ option in the ‘Commit Selection’ section.
4. Click ‘OK’. -
Fix Refresh in 5.5.369
Manual refresh appears to be broken in this version. This even includes doing an edit on a table and the script generated does not mirror the underlying table. Have repeatedly seen this.
1 vote -
Full text index sync order
When you sync the schema of a database that has a full text index in it and stored procedures that reference that index, you cannot sync the schema to an empty database in one step. You must do the tables and the index first, then the functions and procedures.
1 vote -
Implement ALT Select
You should be able to (when virtual space is enabled) hold ALT+Shift and using the up/down arrow keys, select in a vertical line. Allowing you to modify / add or remove characters on multiple lines simultaneously. Similar to how this works in notepad ++ / SSMS etc
1 voteThis feature is present in the latest product version https://www.devart.com/dbforge/sql/studio/download.html
-
Better support for 4k monitors
The scaling on 4k monitors is not very good. Most text is readable but some text like on the title bar and in code-completion dropdowns are being truncated. I have to override the high DPI scaling behavior and set it to System to make it more readable and user friendly. Of course, when I do this it makes some text like that on the start page slightly fuzzy.
17 votesIt’s fully supported in version 6.0.
-
Option to align the text in the table comparison panel
It would be nice if there is an option to visually align the text on both sides in the table comparison panel.
This would mean to align all exact lines on both sides and when the are lines which exist only on the left or the right to put an empty line on the other side.
It makes the visual comparison easier and similar to how the Diff/Compare function works in Visual Studio.
3 votes -
Setting to customize the highlight color in the table comparison panel
Currently in the differences in the table columns are highlighted with some sort of blue/green, while the column names and the DDL are also in the blue/green color space.
It is hard to easily figure out what is the difference.
It would be really helpful to be able to change the highlight to any chosen color - for myself I would choose yellow :)
3 votesThis can be setup in the ‘Text Editor → Text Compare Control’ of the ‘Options’ window (select ‘Tools → Options…’ from the main menu) https://snipboard.io/07VTfb.jpg
-
Better performance for large SQL documents
For large documents, say 100,000 lines of insert statements, shut down all language classification, lexing, parsing, etc services during a Find and Replace operation so that one isn't waiting forever for the process to complete. In my experience I waiting forever and had to kill the process. Shut down the services, perform the operation, then turn them back on.
1 vote -
bug on current sql studio.
since the new version, quite often my sql queries execute fine, however the execution timer keeps ticking away and then the connection to the db breaks. The only way to get it back is reload the query or restart forge. very annoying.
1 vote
- Don't see your idea?