DELETESQL exist?

Post Reply
D.Fernandez
Posts: 392
Joined: Wed Jul 31, 2013 1:14 pm
Location: Maldonado - Uruguay
Contact:

DELETESQL exist?

Post by D.Fernandez »

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

codcli := "2001"

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

Thanks.
Dario Fernandez
FWH, Harbour, BCC, MySql & MariaDB, tData, Dbf/Cdx
VSCode.
Maldonado - Uruguay
User avatar
nageswaragunupudi
Posts: 8017
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Contact:

Re: DELETESQL exist?

Post by nageswaragunupudi »

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

Code: Select all

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

G. N. Rao.
Hyderabad, India
D.Fernandez
Posts: 392
Joined: Wed Jul 31, 2013 1:14 pm
Location: Maldonado - Uruguay
Contact:

Re: DELETESQL exist?

Post by D.Fernandez »

Gracias Rao, muy amable.

Saludos.
Dario Fernandez
FWH, Harbour, BCC, MySql & MariaDB, tData, Dbf/Cdx
VSCode.
Maldonado - Uruguay
Post Reply