On 10/11/2017 1:51 AM, John Wright wrote:
> I have a Query as below...
>
> getCode = Query
> ANSWER: :PRIV:ANSWER.DB  ;Query = GetGroupedIndInfo
>
> :APL:IndividualStoredInfo.DB | Date and Time Stamp |
>                  | CheckPlus           |
>
> :APL:IndividualStoredInfo.DB | UniqueCode                 | Description|
>                  | CheckPlus _join1, ~UniqRef | CheckPlus  |
>
> :APL:IndividualStoredInfo.DB | Object Stored Field | Masonic Title |
>                  | CheckPlus           | CheckPlus     |
>
> :APL:IndividualStoredInfo.DB | Surname    | C Name     | Short C Name |
>                  | CheckPlus  | CheckPlus  | CheckPlus    |
>
> :APL:APLaddress.DB | UniqueCode       | Home Phone | Home Email |
>            | _join1, ~UniqRef | Check      | Check      |
>
> EndQuery
>
> In the Description Field above I have the following...
> NOT "REPLACE THIS WORDING or this record will get deleted when you leave
> this form!"
>
> This query has not been used for some time and I am sure it used to work
> ok! The query only works now if I DON'T include the NOT and the text.
>
> Any thoughts as to what is wrong with that text entry?

Hi John,

It seems to me, that the word ‘NOT’, which is a reserved word in Pdox 
queries, may be interfering with your query operation.

Since ‘NOT’ is a reserved word, I try to avoid it altogether. E.g. use 
the phrase ‘Don’t replace this wording…’, etc.

FWIW,

Regards,
Bob Eccles