... UPDATE, MySql provides UPSERT: To insert if the primary key is not found and update if the primary is found, We can do UPSERT using either of the methods: oCn:Upsert( table, [aFieldNames], aValues)// oroCn:Insert( table, [aFieldNames], aValues, .T. ) // .T. indicates ...