Devart Forums

Is there any way to set comma as the default delimiter character when exporting to a CSV file? It is inconvenient to have to tweak this setting every time.

I see the same request has been addressed in other Devart products (MySQL, SQL Server), can we please have the same feature in Oracle?

Thank you,
Garrett Schiff

Thanks, I look forward to getting that fixed.

Greetings DevArt gurus,

I recently upgraded from an old licensed dbForge to the latest one in order to stay compatible when my employer migrated from Oracle 12 to 19. While my procurement team was handling the purchase, I downloaded the Trial of Profession edition and used it for 30 days. On day 31 it reverted to a Free edition, then my procurement guys supplied the license and my installation was again restored to Professional edition.

After it was restored, I am noticing a small but annoying problem with date formatting. I have in Options/Data Editor/Formatting:

DateTime - G - General date/time (long time)
example: 12/22/2016 12:20:59 PM

However in my data grid, there is an extra space before the year digits. I searched the forum and see this problem was reported years ago in this thread, below. It was not happening to me during my 30 day trial, so I am confused how the issue was introduced after entering my license key.

Please point me to a way to get the date formatting correct in the grid again!

Thanks,
Garrett Schiff

TWarburton3198 wrote: ↑Tue 10 Nov 2020 19:22 Hello Alexa and Dzhanhira.

I've installed the custom version and it has eliminated the quotation mark issue. Thank you very much for that.

But I do note an issue that may be specific to this customer version. When data of a data type of 'Date' is displayed in the Data Editor section, there appears to be an empty space between the second forward slash and the year value. Instead of a date of 11/1/2020, I am seeing 11/1/ 2020 . This is true for all date data fields I see, as well as a copy and paste of that field.

I do not recall this from an earlier version.
Thanks Tim

Thank you Alex, I will attempt this today.

Alex,

I've been using the 3.9 trial successfully and my employer purchased the full product. They were given an installation package for the licensed version.

Do I have to re-install again to replace the trial? Or is there any way to just enter the license key to end the trial and activate the registered version?

If I have to re-install again, will I lose all my preferences and database connections setup?

Thanks,
Garrett Schiff

Thank you Alexander, understood. I will try out 3.9 to verify it resolves my stability issues before purchasing the upgrade.

One final question... can I safely install the 3.9 Trial in parallel to my existing 3.6, or will it overwrite it?

Hi Alexa, thank you for the speedy response.

My license was purchased some years ago and I am out of the 1-year support/upgrade period.

Before I approach my supervisors to spend the money for the current version... can you confirm whether the behavior I am describing is a known defect in v3.6.389 that is corrected in the current release? I would not wish to spend the money on the upgrade only to learn that the problem remains.

Also, is there any pricing break for existing users upgrading to the latest version?

Thanks,
Garrett Schiff

Frequently when I double-click a view to review or edit it, the dbForge Studio UI completely freezes and never returns. I have to kill the task and restart it.

Is this a known bug? Is there any way to prevent this?

I am using version 3.6.389.

Please advise,
Garrett Schiff

I recently did something that caused the Output and Error List panes to totally disappear from my UI when using the SQL editor. I can't recall if it was the result of dragging then around or closing them with an 'x', but the end result is that I can't get them to come back. When I select them from the View menu, nothing happens.

Has anyone experienced this? Do you know how to fix it, or how to reset my window/pane configuration back to a default state so I can see them again?

Thanks,
Garrett Schiff

I use dbForge to do a lot of data browsing, often copying the query results into MS Excel.

I would like to suppress the transfer of the string "(null)" into Excel when I copy data. In fact, I don't really want to see it in the query results in dbForge, I would prefer to see empty cells for null values.

I searched the options but could not find any way to change the default behavior.

Is there a way to get my nulls to appear as empty?


Thanks,
Garrett Schiff

I have answered my own question. I found the "Show All Objects" button a few minutes after posting my question. I knew it had to be there somewhere!

I am a new user still learning the dbForge UI. I connect to Oracle using my developer account, and in the Database Explorer tree I can only see objects in my own schema.

I am not interested in the objects in my personal schema, I am interested in browsing the tables and objects in our application schema which resides on the same database instance, and to which I have selected privileges granted.

On other tools I have used (SQL Navigator), there are separate tree nodes for "My Schema" and "Other Schemas", and by expanding the Other Schemas node, I can see the objects I an interested in.

How can I do the same in dbForge?

Never mind, I think I got it. I found out I can set my NLS_DATE_FORMAT environment variable in Windows, and then my Oracle client will honor that preference in most applications, including DBForge.

New user question....

When I query: select * from table_name where create_date > '20-May-2012 17:00:00'

I get: ORA-01830 - Date format picture ends before converting entire input string

I have set my dbForge Data Editor Formatting options to:
Date = dd-MMM-yyyy
DateTime = dd-MMM-yyyy HH:mm:ss

Is the date/time syntax that I must use in my query dictated by my server, or my Oracle client, or my OS? Can I override that so dbForge accepts my preferred date/time format?