Delete many records with several conditions

[trevordevore]

[This post is an archive from the old SQL Yoga forums]

Hi,

I trying to delete many records at same time and with more of one fields conditions.

For example all the records that the NUMBER is XX and ID_CUSTOMER is YY.

I have this, but no records are deleted...

Code: Select all

put sqlrecord_createObject("DOCUMENT") into theRecordA

sqlrecord_set theRecordA, "NUMBER",gNumDoc

sqlrecord_set theRecordA, "ID_CUSTOMER",gCustomerID

sqlrecord_delete theRecordA

What is wrong?

Salut,

Josep

[trevordevore]

sqlrecord_delete only deletes records based on the value of the primary key defined for the table.

You want to use sqlquery_delete to perform a delete using arbitrary conditions.

Also, when troubleshooting it is a good idea to look at the query begin generated using the plugin. The query being generated can sometimes give you an idea of what SQL Yoga is doing behind the scenes.