Focal Point
[SOLVED] Getting error with MODIFY

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

April 07, 2010, 03:17 PM
getit
[SOLVED] Getting error with MODIFY
Hi ,
I am trying to use modify to add records to a focus file.

MODIFY FILE CIPDATA
FIXFORM FROM HOLDTEMP
MATCH ASOFDATE BUSUNIT FUND AGE_GROUP
ON MATCH REJECT
ON NOMATCH INCLUDE
DATA ON CIPDATA
END

It is not inserting hte records and is giving me weired values in the error?

$é7gÇo?¢RECVR

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


App Studio Version 8202
windows Platform
SQL Server 2008/2012
April 07, 2010, 03:20 PM
GinnyJakes
Try saying DATA ON HOLDTEMP. The DATA statement is for your input transactions.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
April 07, 2010, 03:33 PM
getit
It works.
Wonderful...Thanks a lot!


App Studio Version 8202
windows Platform
SQL Server 2008/2012