[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(!)