> is it possible to update data that originates from a "query" > rather than a "table" tag (in dbforms-config.xml) if that > query does a JOIN of sorts? In the bookstore example's > dbforms-config.xml I see a query with a LEFT JOIN, but I > couldn't get anything like it to work with inserts/updates. > No normally not. JDBFORMS only craete sql statement for the queries. And joined tables are normally not updateable/insertable in most sql implementations.
If you create an view from your joined tabled it could be possible that you can write and insert/update/delete trigger for this view. Regards, Henner ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
