[Lazarus] SQL parser
Michael Schnell
mschnell at lumino.de
Wed Aug 18 17:49:50 CEST 2010
Example:
There is a table called "client" that has fields "ID" and "Name"
There is a table called "Account" that has fields "ID" and "Sum"
The tables are relationally connected by the "ID" fields.
Now a "perfect SQL hiding component" would provide an easy way to create
a function that e.g. doubles "Sum" if the "Name" String contains
"Schnell" and "Sum" is greater than "0".
in a second step it would be possible to create a stored procedure from
this and finally call same from a program that is done from the same
Pascal source code with just some switch set from "local" to
"create_stored_procedure" and finally "use_stored_procedure"
Just wildly raving...
-Michael
More information about the Lazarus
mailing list