Re: OPO: How to force update of form to show trigger results...
From: Rick Greenwald <greenie_at_interaccess.com>
Date: 1996/02/23
Message-ID: <4gk5d1$sop_at_nntp.interaccess.com>#1/1
Date: 1996/02/23
Message-ID: <4gk5d1$sop_at_nntp.interaccess.com>#1/1
Peter -
You will need to execute the Requery() method for the recordset, which I believe is undocumented for 1.04. You can get the handle of the recordset with the GetRecordset method.
You also might just want to add the record directly to the recordset with some of the recordset manager functions. This could potentially result in a lack of synchronization if your database trigger fails for some reason, but you would not have to re-execute the query and bring back data from the server.
- Rick Greenwald Co-author, Oracle Power Objects Developer's Guide.