Hi Shawn!
1) Quick solution that would run with current dbforms:
Use interceptors, within preinterceptor you store the
hash containing the field values as a request scoped attribute.
Within postinterceptor you take these values and do whatever you need
to do.
...is possible right now
2) When Eric has completed his foreign key stuff, you might be able
to read the foreign key meta data and use one interceptor
for all tables that generates the SQL statements dynamically
accoring to the metadata information.
...Eric is currently working on that, will soon be possible
3) We already had some postings about extending interceptors. I agree
that we should do that. But as we will probably be not 100% backwards
compatible, we must be careful and try to avoid to do the same thing
2 weeks later again. Currently e.g. we do not even have the table name
available as a simple parameter.
...might be possible in near future, is just a minor extension, no
massive update
Combining 1-3 would allow to write a general interceptor that is able
to do automatic foreign key actions for one level. It would probably not
recursively call next level actions.
4) Cascading actions through multiple levels will be difficult to implement
if you don't have transaction support within your database. If the
55th action fails (because of interceptors, missing grants or whatever)
you would have to undo the 54 updates made before. If you cannot simply do a
con->rollback() you get into troubles then.
...would be more work, don't see it in near future.
5) Luca proposed a 'Pluggable events system': within dbforms config file
you specify that for some tables dbforms default events should be everridden by
something you have written.
...?
Regards
Dirk
-------------------------------------------------------
This sf.net emial is sponsored by: Influence the future of
Java(TM) technology. Join the Java Community Process(SM) (JCP(SM))
program now. http://ad.doubleclick.net/clk;4699841;7576301;v?
http://www.sun.com/javavote
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
