FiveTech Software tech 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/