Paradox Community

Items in pnews.paradox-programming

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


Copyright © 2004 thedbcommunity.com