DELETESQL exist?

DELETESQL exist?

Postby D.Fernandez » Mon Aug 31, 2020 3:51 pm

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

codcli := "2001"

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

Thanks.
Dario Fernandez
FWH 22.12, Harbour, MVS2022 Community, BCC, MySql & MariaDB, Dbf/Cdx VSCode.
Maldonado - Uruguay
D.Fernandez
 
Posts: 455
Joined: Wed Jul 31, 2013 1:14 pm
Location: Maldonado - Uruguay

Re: DELETESQL exist?

Postby nageswaragunupudi » Tue Sep 01, 2020 11:35 am

We did not provide a method for delete.
Please use:
Code: Select all  Expand view

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

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10326
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: DELETESQL exist?

Postby D.Fernandez » Tue Sep 01, 2020 5:28 pm

Gracias Rao, muy amable.

Saludos.
Dario Fernandez
FWH 22.12, Harbour, MVS2022 Community, BCC, MySql & MariaDB, Dbf/Cdx VSCode.
Maldonado - Uruguay
D.Fernandez
 
Posts: 455
Joined: Wed Jul 31, 2013 1:14 pm
Location: Maldonado - Uruguay


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 128 guests