Sibylle Koczian wrote: > First the old record requires editing: filling in one field. Then the > database can calculate most of the values for the new record (needs the > value from the field just filled). There is only one field in the new > record that may get a value entered by the user (myself, anyway) at this > point. So in the meantime I've thought of doing it like this: controls > bound to the child table, showing the old record, one or two of them > editable. A textbox without data binding for the value I may want to > pass to the new record. A button and a method which saves the old record > and calls a stored procedure in the database with the right parameters, > including the value in the textbox. This stored procedure inserts the > new record. After all this, a requery(). > > There is no bizobj method for calling a stored procedure, is there? So I > suppose I'd best use a TempCursor for that? > > Thank you, > Sibylle >
There are two types of stored procedures in Firebird. Executable procedures and selectable procedures. For executable procedures see: http://firebirdsql.org/refdocs/langrefupd20-execproc.html A selectable stored procedure can be used like a select from a table. http://firebirdsql.org/refdocs/langrefupd20-select.html I would use a temp cursor for a executable procedure. In case of a selectable procedure using a bizobj would make more sense. Uwe _______________________________________________ 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]
