Pete,
So they still have to add new claims in the old DOS app? It would seem to me that although you can't rewrite the old "Add New" stuff, putting a function call in there right before RETURN might suffice. Write the function to add the new record to the SQL database using SQL Passthrough or whatever. That's the most efficient way; otherwise you'll be writing a service in either C# or SQL Server that will be run timely and will eat clock cycles for something that only occurs twice a year.
Sorry I don't know the architecture, but I hope this makes sense.
>Hi All, don't know where this message belongs so I'll start here. I am gradually migrating an old DOS Fox app to a C# Winforms one, most of the functionality is now in the new one except for adding new claims ( it's a liquidation app and there are very few new claims - think 2 a year ) so my client doen't want me to rewrite the "add new claims" function as it's does hideously complicated validation. What they have asked me to do, is ; periodically compare the DOS tables with the new SQL ones - and if any new records exist - pull them into SQL Server. Before I go down the wrong road - has anyone here done this sort of thing ? should I use SQL server or a C# prog to periodically check the tables ?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05