Yes, Kevin; Multiples are treated as sub-files imbeded in the entities they were created under. Word Processing fields have much the same structure as a multiple, except that there are no other subordinate multiples or word-processing fields under each word processing field.
Oh, by the way, the zero node of the word processing field closely follows the structure of a multiple; ^^<last ien>^<line count>^<date last modified> But in a word processing field, the last ien and the line count just happen to be the same value in a word processing field. ----- Original Message ----- From: "Kevin Toppenberg" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, January 30, 2005 6:41 AM Subject: Re: [Hardhats-members] Template Question > Aren't multiples treated in fileman as subfiles? > Don't the functions that would work with a separate > file also work with the subfile number? And if they > don't then that would be an area of completion that > would be needed in fileman. > > Kevi > > --- Greg Kreis <[EMAIL PROTECTED]> wrote: > > > This is a good example of the danger of multiples in > > FM. They can create > > non-normalized databases, forcing folks to stand on > > their head to get > > some results. It is much easier, when reporting, to > > deal with files > > that have pointers that link the records. Having > > said that, these > > pointed files can be a pain in templates for > > editing. > > > > Bob Beckley wrote: > > > > >Greg, > > > > > >I finally ended up with this, and it seems to do > > the trick when I tie it to > > >a print-type menu option. I want to report just > > instances of where one > > >sub-field equals another sub-sub-field. Any > > additional comments are > > >certainly welcome. > > > > > >TST>D Q^DI > > > > > >VA FileMan 22.0 > > > > > >Select OPTION: PRINT FILE ENTRIES > > > > > >OUTPUT FROM WHAT FILE: PRINT TEMPLATE// 458 TIME & > > ATTENDANCE RECORDS > > > (281 > > entries) > > >SORT BY: PAY PERIOD// > > >START WITH PAY PERIOD: FIRST// 04-12 > > >GO TO PAY PERIOD: LAST// 04-12 > > > WITHIN PAY PERIOD, SORT BY: 1 EMPLOYEE > > (multiple) > > > EMPLOYEE SUB-FIELD: 10 DAY # (multiple) > > > DAY # SUB-FIELD: APP. SUPERVISOR=TIMEKEEPER > > POSTING > > > WITHIN APP. SUPERVISOR=TIMEKEEPER POSTING, SORT > > BY: > > >STORE IN 'SORT' TEMPLATE: ZZBBSEARCH1 > > > Are you adding 'ZZBBSEARCH1' as a new SORT > > TEMPLATE? No// Y (Yes) > > >DESCRIPTION: > > > No existing text > > > Edit? NO// YES > > > > > >==[ WRAP ]==[ INSERT ]=============< DESCRIPTION > > > > > > > > >>===========[ <PF1>H=Help ]==== > > >> > > >> > > >Search template for APP. SUPERVISOR = TIMEKEEPER > > POSTING fields in T&A > > >file. > > > > > > ><=======T=======T=======T=======T=======T=======T=======T=======T=======T>= = > > >==== > > > > > >SHOULD TEMPLATE USER BE ASKED 'FROM'-'TO' RANGE FOR > > 'PAY PERIOD'? NO// y > > >YES > > >FIRST PRINT FIELD: .01 PAY PERIOD > > >THEN PRINT FIELD: 1 EMPLOYEE (multiple) > > > THEN PRINT EMPLOYEE SUB-FIELD: 2 APP. SUPERVISOR > > > THEN PRINT EMPLOYEE SUB-FIELD: 10 DAY # > > (multiple) > > > THEN PRINT DAY # SUB-FIELD: 102 TIMEKEEPER > > POSTING > > > THEN PRINT DAY # SUB-FIELD: > > > THEN PRINT EMPLOYEE SUB-FIELD: > > >THEN PRINT FIELD: > > >Heading: TIME & ATTENDANCE RECORDS LIST Replace > > ... With T&A Check > > > Replace > > > T&A Check > > >STORE PRINT LOGIC IN TEMPLATE: ZZBBPRINT1 > > > Are you adding 'ZZBBPRINT1' as a new PRINT > > TEMPLATE? No// Y (Yes) > > >START AT PAGE: 1// > > >DEVICE: > > > > > >-----Original Message----- > > >From: [EMAIL PROTECTED] > > > >[mailto:[EMAIL PROTECTED] > > Behalf Of Greg > > >Kreis > > >Sent: Saturday, January 29, 2005 4:24 PM > > >To: [email protected] > > >Subject: Re: [Hardhats-members] Template Question > > > > > > > > >Why not create a computed field that figures out if > > the condition exists > > >and then sets its value (S X=...) to what you want > > to print? Here is a > > >general form for the code. > > > > > >S X="" S:<condition> X=<sub-field retrieval code>_" > > "_<sub-sub-field > > >retrieval code> > > > > > >In the code for <condition>, <sub-field> and > > <sub-sub-field> you can > > >refer to the variables D1 for the sub-field record > > number and D2 for the > > >sub-sub-field record number. > > > > > >The above approach means you need to create this > > field in the > > >sub-sub-file so that when it is accessed, the > > values of D1 and D2 exist. > > >But, is that what you want? For instance, aren't > > you going to have to > > >go through all the sub-sub-file records to compare > > their field to > > >sub-field? I am not quite sure I understand a > > database situation where > > >this makes sense. Can you give some more details? > > > > > >Bob Beckley wrote: > > > > > > > > > > > >>I think I figured it out, all you late risers. :) > > Almost . . . > > >> > > >>I drilled down to the lower sub-field and entered > > a boolean expression > > >>(which used both sub-fields), which returns 0 or 1 > > in X. Then, at the next > > >>prompt, I can work with X. Now I just need to > > figure out how to suppress > > >>the printing of the 0's and print only the 1's. > > If I mess with the boolean > > >>at all, it doesn't like it (I get ?? back.). > > Right now I have > > >>SUB-FIELD=SUB-FIELD for the boolean, and when I > > try something like I > > >>(SUB-FIELD=SUB-FIELD)=1 W "MORE INFO", it blows > > up. Any ideas. Thanks > > >>again in advance. > > >> > > >>-----Original Message----- > > >>From: [EMAIL PROTECTED] > > > >>[mailto:[EMAIL PROTECTED] > > Behalf Of Bob > > >>Beckley > > >>Sent: Saturday, January 29, 2005 6:22 AM > > >>To: [email protected] > > >>Subject: [Hardhats-members] Template Question > > >> > > >> > > >>I'm building a print template and want to compare > > the values of two > > >>sub-fields in the same file. One sub-field is one > > level down in "multiple > > >>A", while the other is two levels down in > > "multiple A." If they are the > > >>same, I want to print both fields; if different, > > then print nothing. The > > >>problem lies in knowing what to write at the "AND > > THEN FIELD:" prompt. If > > >>this were pointer-related instead of > > sub-field-related, I would write > > >>something like (A:B=A:C:D) and then do something > > with the return value of 0 > > >>or 1. I guess what I'm asking is what syntax do I > > use to define and > > >>evaluate sub-fields within a print template. > > Thanks in advance for any > > >>light you can shed on this. > > >> > > >> > > >> > > >> > > > >>------------------------------------------------------- > > >>This SF.Net email is sponsored by: IntelliVIEW -- > > Interactive Reporting > > >>Tool for open source databases. Create drag-&-drop > > reports. Save time > > >>by over 75%! Publish reports on the web. Export to > > DOC, XLS, RTF, etc. > > >>Download a FREE copy at > > http://www.intelliview.com/go/osdn_nl > > >>_______________________________________________ > > >>Hardhats-members mailing list > > >>[email protected] > > > >>https://lists.sourceforge.net/lists/listinfo/hardhats-members > > >> > > >> > > >> > > >> > > > >>------------------------------------------------------- > > >>This SF.Net email is sponsored by: IntelliVIEW -- > > Interactive Reporting > > >>Tool for open source databases. Create drag-&-drop > > reports. > === message truncated === > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting > Tool for open source databases. Create drag-&-drop reports. Save time > by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. > Download a FREE copy at http://www.intelliview.com/go/osdn_nl > _______________________________________________ > Hardhats-members mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/hardhats-members > > ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ Hardhats-members mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hardhats-members
