Subject: | Text in a Query Table Field
| Date: | Thu, 9 Nov 2017 12:51:27 +0000
| From: | John Wright <john@jfwright.co.uk>
| Newsgroups: | pnews.paradox-programming
|
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?
|