Is there a reason I can't get a double-quote to show in the grid?

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Is there a reason I can't get a double-quote to show in the grid?

Post by Jaymer »

Just realized this after importing some data. Thought it was mangled on import, but its an aware/Kendo display issue, it seems.

I initially saw this back in 2018 here.

If I click on the row, the double quote appears correctly in the data in the FORM.
If I save the form, I see a '"' embedded in the field.
It seems to only be a problem displaying in the GRID.

I'm on latest build 8.6

Can a few of you edit a record and enter a " in a field and see how it shows in the grid?
Have I missed a disclaimer about this somewhere that this is a limitation?
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Is there a reason I can't get a double-quote to show in the grid?

Post by Jaymer »

Form view - correct
Screen Shot 2021-10-06 at 3.54.38 PM.png
Screen Shot 2021-10-06 at 3.54.38 PM.png (33.57 KiB) Viewed 3562 times
Grid - incorrect
Screen Shot 2021-10-06 at 3.54.22 PM.png
Screen Shot 2021-10-06 at 3.54.22 PM.png (15.93 KiB) Viewed 3562 times
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
nhofkes
Posts: 94
Joined: Mon Sep 07, 2020 6:03 am
Location: Netherlands

Re: Is there a reason I can't get a double-quote to show in the grid?

Post by nhofkes »

Jaymer, I tested this and had the same result as you. I even put two quotes in a text field on the form and they displayed correctly on the form, but showed up as single quotes in the grid. It seems that the underlying data has the double quotes: when I check the data in the underlying SQL database, I can see the double quotes. So it may be a Kendo issue indeed.
Niels
(V9.0 build 3241 - MariaDB - Windows)
hpl123
Posts: 2579
Joined: Fri Feb 01, 2013 1:13 pm
Location: Scandinavia

Re: Is there a reason I can't get a double-quote to show in the grid?

Post by hpl123 »

Aware don´t like " in general so is probably related to how Aware "transfer" / parse text into the query.
Henrik (V8 Developer Ed. - Windows)
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Is there a reason I can't get a double-quote to show in the grid?

Post by Jaymer »

Reported this in a bug report. Fixed in next build.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Post Reply