Re: New Era Compilation Error

In article <62kfgl$lp7@cssun.mathcs.emory.edu>, Syed <sas@mastic.gov.my> writes >Hi guys, > >I am developing a master detail application using New Era >superview/supertable. I have encountered a compilation error as follows: > >-4408 There is a quoted string that is too long in the above line." > >Upon checking the error i found out that the join in the SelectJoinPart >property of SuperTable is longer >than 80 characters, this is due to the primary key of the main(master) >table consist of 4 columns as such the details table aslo have to be >joined with those 4 columns. > >The content of the Selectjoinpart (property in the inspector) is as >follow > >project.min_code = dir_expenses_item.min_code AND project.proj_serial = >dir_expenses_item.proj_serial AND project.ri_code = >dir_expenses_item.ri_code AND project.sec_code = >dir_expenses_item.sec_code AND dir_expenses_item.dct_code = >direct_cost_type.dct_code > >How do i solve this problem? > Make the long clauses variables VARIABLE selfrom char(*) = "propval, outer charcon st, outer charcon ty, outer charcon tn,"|| " outer charcon us, outer charcon sl, outer charcon rg, outer charcon sv,"|| " outer surveyor, outer crmast sup, outer crmast agt" and use CALL SuperTable.selectJoinPart.setValueStr(selfrom) -- Mike Ripley