Which better recordet or SQL direct to insert in Multi User program to avoid any repeat numbers or conflicts ?
Printable View
Which better recordet or SQL direct to insert in Multi User program to avoid any repeat numbers or conflicts ?
Well, the recordset does get changed into an SQL statment, and it gets executed on the server. In this since, there really is no differenct. If this is referring to your previous post, listen to Thread1. That statement does everyting at once, and will avoid the duplicate invoice problem.