FiveTech Support Forums

How can I run this command
Would I like to update and then get the result of this update

LOCAL cQry := 'update slbdactg set contador = contador + 1 WHERE campo = BCOAGECC ;’
cQry += 'select contador from slbdactg WHERE campo = BCOAGECC '

       oQry  := TDolphinQry:New(cQry,::nServer)

Error description: Error MYSQL/1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'select contador from slbdactg WHERE campo = BCOAGECC' at line 1

que quieres hacer...un UPDATE basado en un SELECT o hacer un SELECt de un UPDATE? ya que la logica cambia y debes separarlos con parentesis ( ), sea el SELECT o el UPDATE, saludos...

revisa esto...

http://www.damianculotta.com.ar/2009/08 ... -en-mysql/