On Fri, 15 Oct 2010, ABorka wrote:
On 10/15/2010 05:40, 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
What do you think about this?
But you can do these things already, I believe.
I had multiple tables and some simple access rights to different people so my
SQL statements had to be different for everyone to get different records from
the tables.
What I did is, I started from the first demo example found in
fcl-web/examples/webdata/demo/
and created ONE action called "CRUD" that handles all the crud request from
the extjs clients. However, I am passing some additional parameters that
specifies which table is to be used and what needs to be done (Create, Read,
Update, Delete). From the session I got who is the user, so I was able to
prepare the proper SQL statements myself.
Is there any chance to put this in a kind of component that does most of the
boilerplate work ? I would imagine 2 events:
OnGetConnection = Procedure (Sender : TObject; Var AConnection :
TSQLConnection) of object;
OnGetQuery = Procedure (Sender : TObject; UpdateKind : TUpdateKind; SQL :
TStrings); of object;
Michael.
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
