Paradox Community

Items in pnews.paradox-programming

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?


Copyright © 2004 thedbcommunity.com