Here-String Case

Support for all customers who have purchased a PrimalScript product license. This forum does not offer a response time guarantee.
Forum rules
DO NOT POST SUBSCRIPTION NUMBERS, LICENSE KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
User avatar
jonathan.gose@outlook.com
Posts: 3
Joined: Sun Mar 03, 2013 12:41 pm

Here-String Case

Post by jonathan.gose@outlook.com » Thu Sep 20, 2018 9:04 am

Sapien PrimalScript 2018 x64 7.4.116.0
Windows 10 1803 x64

Experiencing an issue with the contents of here-strings having their case shifted (causing issues as they are being utilized for SQL statements). When I initially copy the associated SQL statement from SSMS the casing remains intact. If I happen to review or highlight the SQL statement afterwards PrimalScript will randomly adjust character casing. Fortunately, I caught this as the DB I'm updating is case sensitive and would not appreciate the changes. Once PrimalScript changes the case I'm unable to revert to it's original unless I copy the entire query back and do not interact with it. Not sure if disabling auto case correction will resolve the issue as I'd very much like to keep it enabled.

Thanks
Jonathan
Attachments
insert-preselect.jpg
insert-preselect.jpg (30.16 KiB) Viewed 485 times
insert-posteselect.jpg
insert-posteselect.jpg (32.91 KiB) Viewed 485 times

User avatar
davidc
Posts: 5439
Joined: Thu Aug 18, 2011 4:56 am

Re: Here-String Case

Post by davidc » Thu Sep 20, 2018 11:07 am

I have been unable to reproduce this issue on my end. Any specific steps you can provide will be useful.
As for the auto case correction option, I don't think it is the cause because that feature is triggered by the PrimalSense window when a selection is made.

Since you mention it happens while selecting the text, I wonder if it is the case of an accidental keyboard combo press? For example, if you press [Ctrl + U] it will convert the selection to lowercase.
David
SAPIEN Technologies, Inc.

User avatar
Alexander Riedel
Posts: 6671
Joined: Tue May 29, 2007 4:43 pm

Re: Here-String Case

Post by Alexander Riedel » Thu Sep 20, 2018 12:08 pm

Can you please attach an actual file with the content in question? or email it to support@sapien.com
Alexander Riedel
SAPIEN Technologies, Inc.

User avatar
jonathan.gose@outlook.com
Posts: 3
Joined: Sun Mar 03, 2013 12:41 pm

Re: Here-String Case

Post by jonathan.gose@outlook.com » Fri Sep 21, 2018 1:08 pm

Attached, removed some items at the top as they contain internal information. I am able to replicate this behavior any time I select any part of the various here strings. Simply highlighting will change the case on select and where (not relevant but concerning) and highlighting the portion with the 'R' or double clicking on it will change it to 'r'.

Thanks for looking into this.
Attachments
sample_forReview.ps1
(18.08 KiB) Downloaded 23 times

User avatar
mxtrinidad
Site Admin
Posts: 212
Joined: Sun Mar 03, 2013 12:42 pm

Re: Here-String Case

Post by mxtrinidad » Fri Sep 21, 2018 2:27 pm

Thank you for providing the sample code.

I saw that highlighting line 277, containing the 'R', will change to 'r' automatically.
We'll look into it!

User avatar
Alexander Riedel
Posts: 6671
Joined: Tue May 29, 2007 4:43 pm

Re: Here-String Case

Post by Alexander Riedel » Fri Sep 21, 2018 10:22 pm

I am not getting that with the latest service build, so please check again after you update. Thanks for the file.
Alexander Riedel
SAPIEN Technologies, Inc.

User avatar
jonathan.gose@outlook.com
Posts: 3
Joined: Sun Mar 03, 2013 12:41 pm

Re: Here-String Case

Post by jonathan.gose@outlook.com » Mon Sep 24, 2018 11:48 am

Experiencing the same issue with 7.4.117.0. Please let me know.

Thanks
Jonathan

User avatar
Alexander Riedel
Posts: 6671
Joined: Tue May 29, 2007 4:43 pm

Re: Here-String Case

Post by Alexander Riedel » Mon Oct 08, 2018 5:21 am

Can you please try 118 and see if that fixes the issue. I cannot replicate this here.
If the issue persists I am going to give it another look.
Alexander Riedel
SAPIEN Technologies, Inc.