Plug-ins > FM Books Connector Online

query help


When I create a customer query using the 'FullyQualifiedName' field, this is what happens:

'John Doe' or 'Steve Smith' work just fine.

'John & Jane Doe' or 'Steve & Susie Smith' fail.

Is the '&' treated as a special character when executing the query? If so, how do I encode it so that it does not fail?

Geoffrey Gerhard:
The encoded version of & is &

I'm not sure how/whether that encoding is/should be handled by the PCQO plug-in. In the desktop version there's a function that will format the values to the TYPE QB expects, and it may do that formatting automatically when you're applying the equivalent AddFieldWithValue function. I don't see anything in the PCQO docs that address the question.

If the function doesn't do it natively, you may need to add your own Substitute for [ "&" ; "&" ] and any other reserved characters you might encounter. Note that if you're writing any returned values to an FMP record, you'll need to reverse the Substitute parameters.


Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852


[0] Message Index

Go to full version