Ejecutar cadena en SQL EXPRESS

Ejecutar cadena en SQL EXPRESS

Postby acuellar » Thu Mar 16, 2017 9:16 pm

Hago lo siguiente
Code: Select all  Expand view

      oSQL:= "SELECT * FROM tbl_ControlAsistencia WHERE Anio=2015"
       oRs:=FW_OpenRecordSet( oCn,oSQL )
     
       cDel:="DELETE FROM tbl_ControlAsistencia WHERE CODIGO='1899' "
       
       EXECUTE( oRs,cDel )
       oRs:Requery()

    //Ubicando el registro con esto borra oRs:Delete()

 
Saludos,

Adhemar C.
User avatar
acuellar
 
Posts: 1589
Joined: Tue Oct 28, 2008 6:26 pm
Location: Santa Cruz-Bolivia

Re: Ejecutar cadena en SQL EXPRESS

Postby nageswaragunupudi » Fri Mar 17, 2017 12:53 pm

EXECUTE( oRs,cDel )


Correct:
Code: Select all  Expand view
oCn:Execute( cDel )
Regards

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

Re: Ejecutar cadena en SQL EXPRESS

Postby acuellar » Fri Mar 17, 2017 3:29 pm

Thanks Mr. Rao

Thats perfect.
Saludos,

Adhemar C.
User avatar
acuellar
 
Posts: 1589
Joined: Tue Oct 28, 2008 6:26 pm
Location: Santa Cruz-Bolivia


Return to FiveWin para Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 6 guests