Page 1 of 1
Functions With SQL
Posted: Sun 08 Oct 2006 00:09
by khh
Can I use delphi function or custom function in SQL statement is TmyQuery?
Posted: Mon 09 Oct 2006 10:30
by Antaeus
It is impossible to use Delphi functions inside SQL statement. You can create your own function on the MySQL Server and then use it in SQL statements. Please see
this topic of MySQL Server Reference Manual for details.
Posted: Mon 09 Oct 2006 12:31
by khh
Is there any event (Before Post) that I can use to run functions against fields and manipulate it before be saved?
Posted: Mon 09 Oct 2006 12:47
by Antaeus
Yes, please see description of TDataSet class in Delphi Help.