Subject: | Re: Text in a Query Table Field
| Date: | Fri, 10 Nov 2017 07:44:36 -0500
| From: | "Steven Green" <greens@diamondsg.com>
| Newsgroups: | pnews.paradox-programming
|
what's the error message? did you accidently put a comma after the
CheckPlus? does the actual text include the quotes?
--
Steven Green
Myrtle Beach, South Carolina, USA
http://www.OasisTradingPost.com
Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"John Wright" wrote in message news:5a044f2d$1@pnews.thedbcommunity.com...
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?
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
|