Subject: | Re: Text in a Query Table Field
| Date: | Sun, 12 Nov 2017 15:15:24 +0100
| From: | "Anders Jonsson" <anders.jonssonREMOVE@THISorrspelet.se>
| Newsgroups: | pnews.paradox-programming
|
I'm curious too, I have never seen getCode() in OPAL.
As to Johns question, I don't really understand it. There is no variable in
the description field and I can't see any delete code.
Can you please explain more in detail and show the complete code.
Anders
"Robert MacMillan" skrev i meddelandet
news:5a080199$1@pnews.thedbcommunity.com...
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?
>
|