Single Quote Causes Filter Issues

[calexander]

image.png?Filtering on an app variable that has a single quote in it ends up internally adding too many single quotes to escape it and so does not find what it should. The test app I used has an app var already initialized to a value with a single quote in it and uses the app var on startup to filter the form.

Test Table:

create table calexander/TstInvc
(
  myInvc char(24) Not Null,
  myDesc char(100) Not Null
);

insert into calexander/TstInvc
values( 'Cal''s Test Invoice', 'This is an invoice that is a test');

Test Data Source:

SELECT
  myinvc,
  mydesc,
  rrn(TSTINVC) AS rrn1
FROM
  tstinvc?

?


Tested on Valence Framework 6.3.20251117.0 and Valence Framework 6.3.20260622.0 and both have the issue.

image.png?image.png?image.png?image.png?

[Johnny Major]

Thanks for the information, and this will be fixed in the next update.