Need help (again) understanding something...

[Mark L. Wise]

Explain "connected file"?

How are files connected?  I am using the default OMNIS data files, not 
SQL.  Are connected files similar to an SQL JOIN?

Mark


On 1/30/2017 12:39 PM, BILL tube wrote:
> Is it possible the account_no is in connected file ?
>
>
>> On Jan 30, 2017, at 9:32 AM, Mark L. Wise <mark at alpha2.com> wrote:
>>
>> I am in need (again) of help understanding some concepts with OMNIS7 coding.
>>
>> Here is a code snippet;
>>
>> ------------------
>> Set main file {TRANSAC}
>> Set search as calculation {ACCOUNT_NO=#S3}
>> Set current list #L2
>> Define list {TRANS_RSN,TRANS_SOR_RSN,INVOICE_NO,INV_SO}
>> Calculate TRANS_SOR_RSN as 94294
>> Build list from file on TRANS_SOR_RSN (Exact match,Use search)
>> -------------------
>>
>> What I don't understand is the use of the "Use search" modifier on the Build list from file (last line).
>>
>> The Set search as calculation line uses a variable ACCOUNT_NO which is not contained in the file TRANSAC.  How can this be used as a search limiter if this field is not in the file?
>>
>> Thanks again for any help you might give me.
>>
>> Mark
>>
>> --
>> Mark L. Wise
>>
>> Alpha II Service, Inc.
>> 1312 Epworth Ave
>> Reynoldsburg, Ohio 43068-2116
>> USA
>>
>> Office: (614) 868-5033
>> Email: mark at alpha2.com
>> WEB: www.alpha2.com
>>
>> "People do not quit playing because they grow old; they grow old because they quit playing."
>>
>> Oliver Wendell Holmes
>>
>> Titles mean nothing.  The one with a servant's heart is the leader.
>>
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>>
>>
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>

-- 
Mark L. Wise

Alpha II Service, Inc.
1312 Epworth Ave
Reynoldsburg, Ohio 43068-2116
USA

Office: (614) 868-5033
Email: mark at alpha2.com
WEB: www.alpha2.com

"People do not quit playing because they grow old; they grow old because 
they quit playing."

Oliver Wendell Holmes

Titles mean nothing.  The one with a servant's heart is the leader.

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus