topic-39317

Posts: 555

Joined: Wed Jul 31, 2013 01:14 PM

DELETESQL exist?
Posted: Mon Aug 31, 2020 03:51 PM

Hi, I want to delete a registro cumpliendo una condicion.

codcli := "2001"

csql := oCon:DELETEsql( "clientes" , , , {{ "numercli" , codcli }} )

Thanks.

Dario Fernandez

FWH 2501, Harbour, MVS2022 Community, MySql & MariaDB, Dbf/Cdx VSCode.

Maldonado - Uruguay

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: DELETESQL exist?
Posted: Tue Sep 01, 2020 11:35 AM

We did not provide a method for delete.
Please use:

oCn:Execute( "DELETE FROM `clientes` WHERE `numercli` = ?", { codcli } )

Regards

G. N. Rao.

Hyderabad, India

Posts: 555

Joined: Wed Jul 31, 2013 01:14 PM

Re: DELETESQL exist?
Posted: Tue Sep 01, 2020 05:28 PM

Gracias Rao, muy amable.

Saludos.

Dario Fernandez

FWH 2501, Harbour, MVS2022 Community, MySql & MariaDB, Dbf/Cdx VSCode.

Maldonado - Uruguay

FiveTech Support Forums