|Subject:||Re: Text in a Query Table Field
|Date:||Tue, 14 Nov 2017 08:37:21 +1300
|From:||Bob Eccles <firstname.lastname@example.org>
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 |
> 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?
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.