I need to insert multiple records into an existing focus file. Does anyone have some simple code that can do that? Your help is greatly appreciated.

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

This might work

FILEDEF FILENAME DISK apppath/filename.ftm ( APPEND

If it is a FOCUS file, as opposed to a HOLD file, you will need to use MODIFY to insert records:

MODIFY FILE ...
 FREEFORM key1_name key2_name key3_name field1_name field2_name field3_name etc.
 MATCH key1_name key2_name key3_name etc.
  ON MATCH REJECT
  ON NOMATCH INCLUDE
 DATA
key1_value,key2_value,key3_value,field1_value,field2_value,field3_value,$
key1_value,key2_value,key3_value,field1_value,field2_value,field3_value,$
key1_value,key2_value,key3_value,field1_value,field2_value,field3_value,$
END

If you want to use a Form to enter multiple rows, check out Maintain.

quote:

check out Maintain

If you have Developer Studio or a licence.


Dan's suggestion is the simplest way to go.

Thanks for your help. I had to switch to a hotter task and have not been able to get back to this procedure. You can consider this topic closed. I will get back to this and will then try to use your suggestions.