I have been working in xbase for over 20 years with just the DBF tables and am now trying to move to the SQL world. Most SQL stuff I can do with no problem but this one has me stumped. Most of our data is setup as two tables. ie An invoice header table such as IVINVT and an invoice line table (IVINVTLN). When the user edits the lines we use a SQL to gather all the lines into a cursor and put it in grid for display/edit and then have always used a scan / endscan to write the records back to the line table. There can be more or less lines in the cursor than are in the origial table when the user saves it. What SQL syntax would I use to write the lines back if I am using MS SQL, MySql, Firebird, etc? (We are still evaluating which SQL engine to use.) Would I have to write each rec back one at a time or is there one command that will update the database, updating existing records, adding new records and deleting exra records?
TIA