Registros eliminados con delete

[kevin22]

Hola, mi pregunta es muy sencilla:
Como puedo saber el numero de registros que han sido eliminados mediante instruccion "delete from..."

Muchas gracias!

[henryzs]

Hola Kevin:

Para ejecutar el comando de eliminación usa el objeto ado COMMAND.

Set recordset = command.Execute( RecordsAffected)

Donde RecordsAffected es una variable de salida con los registros afectados.

RecordsAffected:
Optional. A Long variable to which the provider returns the number of records that the operation affected. The RecordsAffected parameter applies only for action queries or stored procedures. RecordsAffected does not return the number of records returned by a result-returning query or stored procedure. To obtain this information, use the RecordCount property. The Execute method will not return the correct information when used with adAsyncExecute, simply because when a command is executed asynchronously, the number of records affected may not yet be known at the time the method returns.

saludos!!

[kevin22]

Hola,

Antes de todo gracias por tu ayuda. Pero no existe otra manera (sin usar Command) para hacerlo? Gracias.