Paradox Community

Items in pnews.paradox-programming

Subject:Re: Text in a Query Table Field
Date:Mon, 13 Nov 2017 09:15:13 -0600
From:Mark Bannister <markRemove@THISinjection-moldings.com>
Newsgroups:pnews.paradox-programming
getcode was his query variable.
var
	getcode query
endvar

On 11/12/2017 2:08 AM, Robert MacMillan wrote:
> 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?
>>
Getcode


Copyright © 2004 thedbcommunity.com