Recent content by robert_farquhar

I have an oracledataset linked to a grid. The query returns 2 fields, the first is a code from the main table and the second is a description from a lookup table (using the code field). For browsing things are fine. My problem is when editing the code field, if the value changes I want a refresh...

The inTransaction function lets me know the curret state but it would be nice if the database connection could trigger an event when the transaction state changes. Our application is in and running but somewhere in there (a lot of code) a transaction is being held open which we cannot...

Anyone know of an easy way to trigger something which identifies that the current oracle connection has started or commited a transaction. ps does setting a savepoint start a transaction if one does not already exist.

I am having problems streaming components by writing/reading a TMemoryStream to a TBlobField on a TOracleDataSet. It works fine if a write to a TClientBlobStream and use assign to the TBlobField - weird. The code also works fine on standard BDE tables. It is almost as if there are extra...

After returning a large number of records into a oracledataset I need to be able to update one of the result rows and then remove it from the result set. If I use the standard Tdataset filter option is only gets fired when you get the records initially i.e if you update, refreshrecord etc the...