Rick - the wwSql.nAffectedRecords property always returns 0 when executing a Sql DELETE command against Sql Server.

Your code in wwSql.Execute() has this:

...
This.nAffectedRecords = aCountInfo[1, 2]  &&RECCOUNT()
...

But, when executing a Sql DELETE command against Sql Server, this always evaluates to zero, instead of telling you how many records were deleted.

Here is an example of the Sql command I am passing to wwSql.Execute()

lcSql = "Delete from ScheduleItems Where PurchaseOrderItem_id In (99796, 98422, 96321)"

lnReturn = loSql.Execute(lcSql)

Then something has changed with the way the ODBC driver is returned the affected record count. The value is supposed to come back as part of the acountinfo[] array. If it's not coming from there, the call to Execute might return the right number.

+++ Rick ---

Rick - my apologies... After futher testing, I can confirm your code is all working as expected.

I'm not sure what I was experiencing when I reported this error, but I find that I cannot reproduce the error.

LOL! That's a bit odd... glad to hear it's working because that code hasn't changed in many years and if it was broken it'd mean that ODBC or the SQL ODBC driver would be broken...

+++ Rick ---