Hello, I want to do the following, using a Firebird database (which means I can use triggers and stored procedures to my hearts content):
Main window shows records from the parent table in a grid, not editable, and some fields from one child record belonging to the currently selected parent records. One of these fields, call it ChildFieldA, contains NULL at record creation. Now this field is filled in and when the record is saved a new record is created in the same child table (creation most probably by trigger). This record has, again, NULL in ChildFieldA, but one or two other fields should be editable at this point. And it would be better to see the old record while editing the new one. So now I need controls showing two different records from the same table. I could use a grid, but would prefer separate controls. Is this possible and reasonable using one bizobj or should I better use two? In the latter case they need different values for DataSource, right? I would set UserSQL in any case, but will INSERT and UPDATE work right, if one of the bizobj classes doesn't have the table name as DataSource? Again, I'd like to set not only the SELECT statement for the bizobj, but also INSERT, UPDATE and DELETE statements explicitly. But that's something dBizobj doesn't allow, does it? Of course, at a pinch I could define a view in the database and make it updatable by triggers. Or it might even be updatable anyway if it doesn't contain a join (must look into my Firebird book). Then one of my bizobjs would use this view and the other would use the table itself. Thank you for hints, Sibylle -- Dr. Sibylle Koczian _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
