[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