NetTalk Central

Author Topic: Problem with Apostrophe in browse link field  (Read 3042 times)

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Problem with Apostrophe in browse link field
« on: November 05, 2014, 10:55:38 PM »
If I have a parent where the field used to restrict a child browse contains an apostrophe then the child browse displays no records. It has nothing to do with unique field identifier just a specuial
For example in the 3 filters below filter 3 doesn't work because of the apostrophe, obviously because the filter value becomes
 'BS3357 ST BENEDICT'

[2816] [st] [netTalk][thread=3] filter:FOL:Reference = 'BS3358 ST JOSEPHS SCHOOL - FOURIESBURG'
[2816] [st] [netTalk][thread=3] filter:FOL:Reference = 'BC3051 CRAVEN JAMES ROOS'
[2816] [st] [netTalk][thread=3] filter:FOL:Reference = 'BS3357 ST BENEDICT'S SCHOOL - LADYBRAND'

Is there any way short of telling the client to pull out any apostrophe from his field that I can get around this issue
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: Problem with Apostrophe in browse link field
« Reply #1 on: November 05, 2014, 11:21:20 PM »
Try using Quote() in your filter. Ref to clarion docs if unfamiliar.

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: Problem with Apostrophe in browse link field
« Reply #2 on: November 05, 2014, 11:40:26 PM »
Thanks Kevin. That works
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186