Recent content by donychao

I use a Data Module and open it before I open any form which would be maintained. The OracleSession is alive and keep connection is true in the first place. Please help me!

I use DOA 3.4.6.4, and I upgrade my ap from d5 to d6. Ever since I did it and everything went wrong after that. I open a form of my ap project, and a message shows "Not logged on" to me and all the db controls in the form lost dataset links all at once. And the nightmares started, every time I...

Why is everything went wrong since I upgraded from D5 to D6. Your DOA componet went wrong just because of different version! Why don't you ever think this once? Don't ask me to look into cause of any lock, I don't lock anything manully, not before and now neither. Just answer me why things went...

It's been OK for a long before I use D5, and the terrible things came from an upgrade to D6 and use "doa34D6.exe". (I even upgrade to today's version.) Every joined multiple tables in a main editable table yeilded this error if you try to edit any main table's field. Here is my TOracleDataset's...

I don't know why TOracleDataSet eat duplicated key errors and my users don't get what happened to their data entres? Did I miss out something to do with it? I want to let them know what happened and how should I do? ------------------

You said: ----------------------------------- The primary key column changes of the parent table cannot be cascaded by the TOracleDataSet to the foreign key columns of the child record(s). Therefore these master fields are read-only if detail records exist. -------------------------------------...

I use TOracleDataSet for over 2 years, how could I forget to include the table.rowid in the SQL.Text? This couldn't be the case. But since you said that's not about 2 or 3-tier. I will try it again to make sure what really happen, thanks a lot. ------------------

I can afford a method to solve you problem. First, add a rowid field and name it to your alias name. Then whem user double click on dbgrid, you can reference the field as your primary key. Because very record in the oracle env has a unique key call rowid. ------------------

When I use TOracleDataSet in a master-detail relationship form,the master table key field automaticlly become read-only. But sometimes I really have to change it. How should solve this problem? ------------------

I cant update records of joined tables using TOracleDataset under 3-tier infrastructure. They are read-only. I search the whole forum about 3-tier info, but there is just a few messages regarding it. Can you tell me do I have any good idea to use the TOracleDataset instead of TQuery or some...

Do I have a way to implement C/S QBE functions under 3-tier env ?

After 3 months later finally I have time to implement a LONG field to CLOB filed transfering job. Now I have a release 3.4.5, it is much later than you sugguest. And I still got a trouble Oracle Error: ------------------------------------- ORA-03127 no new operations allowed until the active...

I've posted an CLOB field Oracle Error ORA-03127 on this board which is very much like this one. I doubt that it may be owing to DOA's error. Because 1.I can see the text field in SQL*Plus very correctly. I test this problem so many times with so many methods. Finally, I figure out it always...

I want to update a CLOB field using DOA in DELPHI 5.X. I can see the text CLOB field was updated normally(I can see it in SQL*PLus), but When I opened the project in delphi or run the Application , it come to an Oracle Error ORA-03127. Can anyone tell me what happened ? Thanks /////////// Just...