LOCAL lcStrConn as String LOCAL lnHandle as Integer LOCAL lcSQLBatch as String lcStrConn = "Driver={SQL Server}; Server=(local); Database=Northwind; UID=sa; PWD=;" lnHandle = SQLSTRINGCONNECT(lcStrConn) IF lnHandle < 1 MESSAGEBOX("Could not connect to the database") RETURN .F. ENDIF *-- The following statement will cause no updates TEXT TO lcSQLBatch TEXTMERGE NOSHOW UPDATE Customers SET CompanyName = 'Will not update' WHERE CustomerID = 'NONEXISTENT'; SELECT @@rowcount as RowsUpdated ENDTEXT SQLEXEC(lnHandle, lcSQLBatch, "curResult") MESSAGEBOX("Rows Updated: " + TRANSFORM(curResult.RowsUpdated)) SQLDISCONNECT(lnHandle)