Kirk :
yes.
if I remember the subtable syntax correctly....
Execute formula("x_text:=[table]subtable1.subtable2.fieldname")
Lee
I am not sure that this will work, but if it does it might make your
life easier...
have 1 method (which will likely have to be hard coded) to get pointers
to all the sub-subtable fields
populate the pointers into an inter process pointer array.
Then you can loop over them to extract data
Get pointers to sub_subtable_fields
array pointer(<>Sub_sub_Field_Pointers;number_of_Sub_sub_Table_Fields)
execute
formula("<>Sub_sub_Field_Pointers{1}:=->[table]subtable1.subtable2.field_1_name")
execute
formula("<>Sub_sub_Field_Pointers{1}:=->[table]subtable1.subtable2.field_2_name")
execute
formula("<>Sub_sub_Field_Pointers{1}:=->[table]subtable1.subtable2.field_3_name")
....
then for data extraction:
For($i;1;number of records in sub-subtable)
For($ii;1;size of array(<> Sub_sub_Field_Pointers))
Text_variable :=Text_variable + utility_convert_to_Text(<>
Sub_sub_Field_Pointers{$ii})
end for
end for
send packet(Text_variable)
On Fri, 13 Oct 2017 10:48:16 -0700, Kirk Brooks via 4D_Tech wrote:
> Tim,
> On Fri, Oct 13, 2017 at 8:50 AM, Tim Nevels via 4D_Tech <
> [email protected]> wrote:
>
>> If I remember correctly, the 2004 method editor will show sub-subtable
>> field references, but as soon as you edit a line with the reference (or
>> maybe even retokenize the whole method) it drops the sub-subtable
>> references. So you have to replace all these lines of code with EXECUTE
>> commands. And you’ll have to write all the sub-subtable conversion code as
>> a series of EXECUTE commands for every line with a sub-subtable reference.
>
>
> Really interesting hack. I'm trying to visualize this - "So you have to
> replace all these lines of code with EXECUTE commands." Do you mean
> opening the structure in 2004 will show the names of the sub-subtable
> fields so you can then write the code using that name and run it with
> EXECUTE and not choke?
>
> --
> Kirk Brooks
> San Francisco, CA
> =======================
>
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
>
> *- Edmund Burke*
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> FAQ: http://lists.4d.com/faqnug.html
> Archive: http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub: mailto:[email protected]
> **********************************************************************
---------------
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
