Recent

Author Topic: Zeos Zquery before  (Read 2132 times)

k1attila1

  • Jr. Member
  • **
  • Posts: 90
Zeos Zquery before
« on: March 26, 2018, 11:12:22 am »
Hi  !


Before ZQUERY send a delete, update , insert SQL statement to the server (with .POST, .DELETE)
How can i get, read the composed SQL query (as a string) befores ZQUERY send to the server ?

Thank you Attila

GAN

  • Sr. Member
  • ****
  • Posts: 305
Re: Zeos Zquery before
« Reply #1 on: March 26, 2018, 11:14:08 pm »
Code: Pascal  [Select][+][-]
  1. var s:string;
  2. s:=ZQuery.SQL.Text;
Lazarus 2.0.8 FPC 3.0.4 Linux Mint Mate 19.3
Zeos 7.2.6 - Sqlite 3.32.3

https://gitlab.com/users/GAN__/projects

mangakissa

  • Hero Member
  • *****
  • Posts: 1101
Re: Zeos Zquery before
« Reply #2 on: March 27, 2018, 08:41:49 am »
Are you sure GAN?

ZEOS has TZsqlmonitor to log these queries. Look at this site.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

GAN

  • Sr. Member
  • ****
  • Posts: 305
Re: Zeos Zquery before
« Reply #3 on: March 27, 2018, 09:46:15 pm »
Yes, because he did not mention a log neither a TZsqlmonitor, only ZQuery and a server.
Lazarus 2.0.8 FPC 3.0.4 Linux Mint Mate 19.3
Zeos 7.2.6 - Sqlite 3.32.3

https://gitlab.com/users/GAN__/projects

 

TinyPortal © 2005-2018