On Fri, 15 Oct 2010, Leonardo M. Ramé wrote:
On 2010-10-15 14:24:48 +0200, Michael Van Canneyt wrote:
After removing the TSqlQuery and TSQLTransaction components from my app,
a new question came to my mind, in the case of complex inserts/updates
that involves more than one database table, is it possible to use
transactions?.
Hm. Not if you use the TSQLDBWebDataProvider. To do that, you would
have to use TSQLSuery and a regular TWebDataProvider, and hook into
the Before/after post events of the TSQLQuery.
But I'm certainly open for suggestions for improvements.
Michael.
Well, It's not an issue at all, I could create a stored procedure in
charge of receiveing the params from the dataprovider, then adapt them to
their respective tables. It's not an issue because I usually work with
Firebird and PostgreSql, and they have stored procedures.
I ask this because I'm thinking of adding a new layer of abstraction by
letting the TFPWebProviderDataModule load a configuration from, say, an
XML file with the list of Providers and its Select, Insert, Update, and
Delete statements, like this:
Aha !! I have this on my todo list as well :-)
Only I wasn't going to use XML, but .INI format.
In fact the file format is irrelevant; I planned to do it in 2 levels:
TFileWebDataProvider
+- TIniFileWebdataProvider
I was going to put it in a separate component, but make the
TFPWebProviderDataModule aware of this component. Gives more
options.
Michael.
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
