I am new to Dexterity, when I was testing I found a new record in SQL has yyyyyyyyyyyyyyyyy and 2 dots on above each y. When you lookup in the 3rd party window I can see it.
Any comments appreciated
Thanks
Suneetha
*This post is locked for comments
Suneetha
Sounds like you have saved a record after using the fill command on a field or the table buffer.
As Leslie said the ÿ character is ASCII value 255 and the highest Dexterity value.
It is also the maximum SQL character value in a Binary system, BUT not in a DOCI SQL System. See KB 910129 for info on this.
How to write "Passthrough" SQL statements and "Range Where" clauses in Microsoft Great Plains Dexterityhttps://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;910129
Hope this helps
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David dot Musgrave at microsoft dot com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (