Recent content by planas

Hello, We used a dataset with this query : select rowid,col1 alias1,col2 alias2 from my_table But when we try to use refreshrecord method DOA doesn't refresh the current record because you make a : select * from my_table and don't use the select list (rowid,col1 alias1,col2 alias2) so the...

Hello, We need this functionnality now. So we decided to implement it in our component. We need to understand where you store lobs in memory. Whitch private attribute contains lob pointer ? Is it WorkBlobs ? JP

Hello, I agree with you. Another solution is to set a savepoint before locking and then after cancel execute a rollback to this savepoint. JP

Hello, I use an oracle dataset with these properties : - CommitOnPost False - LockingMode lmLockImmediate So when i edit the oracle dataset a lock is set. But if i cancel it the lock is always here. JP

Hello, RefreshRecord does not refresh LOB of the current record. We try to make the refresh in OnApplyRecord. But if we tried to set the new clob value in the dataset we need to make an edit and a post of the dataset. But if we edit the dataset DOA generate a new update statement at the next...

Hello, You've forgotten to add the OracleLogon.dfm file in the doa34d6.dpk. Then, when i compile my project with only DOA dcu file, it missed OracleLogon.dfm... Could you verify the delphi packet project named doa34d6.dpk ? Thanks.

You are right. In the last test, we forgot begin/end. Now all is ok. Thanks. JP

Hello I see a method CompareFieldToField in OracleDataset. This method is never used. Is it usefull to keep it ? JP

Hello RefreshRecord does not refresh LOB of the current record. How to do this ? JP

The variable is declared at design time. It is declared as CLOB. And the error is always the same... JP

Trying what you tell us in your post, now we have the following error : ORA-01036: illegal variable name/number JP

Hello, Executing the following code we have this error : 'Error LOB Variable :LOB_COLUMN cannot be nil' procedure TForm1.btn1Click(Sender: TObject); var LOB: TLOBLocator; Buffer: array[0..99] of char; begin // begin // ... (PL/SQL) ... //select lob_column //into :lob_column from...

Hello In the VCL, a lot of components (like TMemo) inherits from a TCustom class (like TCustomMemo). Why : because, the properties are not published in TCustomMemo and they are published in TMemo. I think it could be a good idea to do the same, in TOracleDataset. A TCustomOracleDataset allow...

Hello I want to derive from the TOracleDataset. It could be a good idea to do virtual procedure for you events (like DoAfterEdit in TDataset) : I would find very usefull : DoApplyRecord. Jean-Pierre

Hello This code raise an exception (invalid handle). var MonClob_in: TLOBLocator; begin MonClob_in := TLOBLocator.Create(orases1, otCLOB); MonClob_in.AsString:='test'; end; My problem is i have a procedure in a package that need a string. I don't use Varchar2 because it's limited to...