Can anyone give me an example of how to insert and/or update multiple records in the same table simultaneously?
I have a table with three fields; ID, PartNum, Qty. The user enters PartNum and Qty data in an unbound grid UI. When the user hits "Save" I'd like to build a single SQL statement from the data in the grid and have that one statement update or insert the rows in the table as necessary. I don't wanna have to build a separate SQL statement for each row of the grid (which is the only way I know how at this moment). Any help would be appreciated. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php