Quotation marks with recent version update

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
TWarburton3198
Posts: 3
Joined: Thu 06 Feb 2020 16:18

Quotation marks with recent version update

Post by TWarburton3198 » Tue 13 Oct 2020 16:07

With the installation of a recent version (4.2.34), any kind of copy/paste from the Data Editor section now surrounds each data field with quotation marks (" "), regardless of the data type.

Is there a setting to disable this 'feature'? This is causing quite a number of extra key strokes (to remove the quotes) when using the result data.

alexa

Re: Quotation marks with recent version update

Post by alexa » Wed 14 Oct 2020 12:46

We will prepare a custom build with the fix for you and will send it as soon as possible.

mooman858
Posts: 10
Joined: Wed 30 Jan 2019 17:03

Re: Quotation marks with recent version update

Post by mooman858 » Wed 21 Oct 2020 14:57

I would like to chime in that I also have the same problem with the Standard Edition v4.2.34.

glendorian
Posts: 3
Joined: Tue 18 Jun 2019 14:23

Re: Quotation marks with recent version update

Post by glendorian » Mon 26 Oct 2020 06:17

Hello! I have the same issue, please help. Studio version is 4.2.34.

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: Quotation marks with recent version update

Post by dzhanhira » Thu 29 Oct 2020 15:54

We prepared a custom build for you: dbForge Studio for Oracle 4.2.34
Here is the link: https://download.devart.com/dbforgeoracle42_custom.exe

TWarburton3198
Posts: 3
Joined: Thu 06 Feb 2020 16:18

Re: Quotation marks with recent version update

Post by TWarburton3198 » 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

mooman858
Posts: 10
Joined: Wed 30 Jan 2019 17:03

Re: Quotation marks with recent version update

Post by mooman858 » Tue 10 Nov 2020 19:53

I agree with TWarburton3198 post above.

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: Quotation marks with recent version update

Post by dzhanhira » Wed 11 Nov 2020 08:26

The space was always present for convenience, but if the space gets in the way, you can manually specify the desired date format in MainMenu-> Tools-> Options-> DataEditor-> Formatting.

See the attached screenshot.
https://prnt.sc/vh90rh

NicholasCameron
Posts: 2
Joined: Wed 11 Nov 2020 13:40

Re: Quotation marks with recent version update

Post by NicholasCameron » Wed 11 Nov 2020 13:47

glendorian wrote: Mon 26 Oct 2020 06:17 Hello! I have the same issue, please help. Studio version is 4.2.34.
Same here! Glad it wasn't just me getting flummoxed by this!

NicholasCameron
Posts: 2
Joined: Wed 11 Nov 2020 13:40

Re: Quotation marks with recent version update

Post by NicholasCameron » Wed 11 Nov 2020 13:49

dzhanhira wrote: Thu 29 Oct 2020 15:54 We prepared a custom build for you: dbForge Studio for Oracle 4.2.34
Here is the link: Total Restore review
Sorry, commented too soon; didn't see you'd posted a fix immediately underneath! Thanks for the help!
Last edited by NicholasCameron on Mon 16 Nov 2020 21:45, edited 2 times in total.

TWarburton3198
Posts: 3
Joined: Thu 06 Feb 2020 16:18

Re: Quotation marks with recent version update

Post by TWarburton3198 » Wed 11 Nov 2020 14:35

Good morning Dzhanhira,

I will admit, I can not imagine at all what convenience having the extra space there provides, but it must be important to someone.

I followed your instructions, and I do see the formatting options for different data type, including the DateTime. I've have tried to adjust it to different settings, and it does not appear to make an impact. The space is still present within the Data Editor, although, it does not look like is should be when you look at the sample input on the formatting screen.

Thanks
Tim

TomF
Posts: 1
Joined: Tue 24 Nov 2020 15:37

Re: Quotation marks with recent version update

Post by TomF » Tue 24 Nov 2020 15:42

Hi, I have the same issue,
also the issue from here:
viewtopic.php?f=22&t=42343

but unfortunately the fixed version is 64 bit and I'm using the 32 bit version. :-/

can you please add 32 bit custom version which will include this fix?

gschiff
Posts: 14
Joined: Wed 23 May 2012 00:50

Old date format problem resurfacing in v4.4.49?

Post by gschiff » Wed 06 Apr 2022 22:50

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

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: Quotation marks with recent version update

Post by dzhanhira » Wed 13 Apr 2022 11:10

Hi there,

Kindly note that we already have created a request to fix it, so the fix should be included in one of the next versions.

Once the fixed version is released, we will inform you.

gschiff
Posts: 14
Joined: Wed 23 May 2012 00:50

Re: Quotation marks with recent version update

Post by gschiff » Mon 18 Apr 2022 15:16

Thanks, I look forward to getting that fixed.

Post Reply