Paradox Community

Items in pnews.paradox-programming

Subject:Re: Text in a Query Table Field
Date:Sun, 12 Nov 2017 19:08:56 +1100
From:Robert MacMillan <macfam@bigpond.net.au>
Newsgroups:pnews.paradox-programming
What is a "getCode" instruction please and does it work in Paradox?

Thanks

On 12/11/2017 6:03 PM, Kevin Zawicki wrote:
> you must do an getCode.executeQBE()
>
> add this after that
>
> errorshow()
> what is the error(s)
>
>
>
> John Wright <john@jfwright.co.uk> 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      |
>>
>> 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