>>>When updating a program on customer's computers I often need to programatically add new records to customer's database (FoxPro or Access).
>>>Is anywhere tool to generate SQL INSERT queries from existing records in developer's database?
>>
>>Where does the data come from? In VFP you can use APPEND FROM, for instance.
>
>Right now I have to update a VFP database from C++ application using ODBC. While adding records I need also to check if record is already present. The number of added records is small and I'm too lazy in order to write a generic procedure.
I see. Sorry, I am not aware of an existing, generic, procedure to do this.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)