Focal Point
[closed]MODIFY/UPDATE: how to wrap a line when there are too many fields to update?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9877008576

April 27, 2015, 02:33 PM
bug
[closed]MODIFY/UPDATE: how to wrap a line when there are too many fields to update?
I use MODIFY/ON MATCH UPDATE to update about 30 fields. If I simply wrap the code into 2nd line webfocus thinks it's a subcommand and error out:


MODIFY FILE TABLE_A
FIXFORM FROM TEMP_FOC_A
MATCH KEY1 KEY2
ON MATCH UPDATE   FILED1 FILED2 FILED3 FILED4 FILED5 FILED6 FILED7 FILED8
                  FILED11 FILED12 FILED13 FILED14 FILED15 FILED16 FILED17 FILED18
ON NOMATCH INCLUDE
DATA ON TEMP_FOC_A
END

0 ERROR AT OR NEAR LINE    214  IN PROCEDURE XXXXXX
 (FOC401) THE MODIFY SUBCOMMAND IS NOT RECOGNIZED: FIELD11
 BYPASSING TO END OF COMMAND

This message has been edited. Last edited by: bug,


7.66 and 7.704
System: Windows / AIX / Linux
Output: Mostly HTML, with some PDF, Excel and Lotus(!)
April 27, 2015, 02:40 PM
David Briars
It would be:
...
ON MATCH UPDATE   FILED1 FILED2 FILED3 FILED4 FILED5 FILED6 FILED7 FILED8
ON MATCH UPDATE   FILED11 FILED12 FILED13 FILED14 FILED15 FILED16 FILED17 FILED18
...  

April 27, 2015, 02:49 PM
bug
quote:
Originally posted by David Briars:
It would be:
...
ON MATCH UPDATE   FILED1 FILED2 FILED3 FILED4 FILED5 FILED6 FILED7 FILED8
ON MATCH UPDATE   FILED11 FILED12 FILED13 FILED14 FILED15 FILED16 FILED17 FILED18
...  


This is quick! Thanks David!


7.66 and 7.704
System: Windows / AIX / Linux
Output: Mostly HTML, with some PDF, Excel and Lotus(!)