Recent content by Julio

I've been having some problems with a TOracleDataSet in QBEMode. Every time I tried to get the result of the query, I got a message like "Field 1 does not exist". After two days, I've found out the solution: the primary key field must be in the last position in the field editor. Well, ok, I've...

Finally the thing works!! I've had to turn to false the OracleSessionPool.StatementCache property as well as the TOracleDataSet.Optimize property.

I've turned all the TOracleDataSet.Optimize properties to False, as you said, but the problem continues. I've also tried setting the global Oracle.NoQueryOptimize to True and... nothing. However, I've realized that the "Access violation at address 00000000...." error appears after a while...

We have a DOA application running on Citrix with no problems related with it. The only problem we have is with the Oracle 9.2.0.8 client. It seems that there are some TOracleDataSet and TOracleQuery properties that don't work well enought due an Oracle client bug. See the next thread for more...

What I meant above was if I have to modify this TOracleSessionPool property to false as well or just the TOracleDataSet.Optimize.

Yes, I've been reading about this solution it the topics, meanwhile. But the DOA help says that the TOracleDataSet.Optimize property is overriden when the TOracleSessionPool.Statementcache is set to true. Is this alright or I didn't understand anything? Thank you, Marco.

Hi there. First of all, I'll say I am using Delphi 6, DOA 4.0.7.1 and Oracle 9.2.0.8.0 I've been having some problems running my application on Citrix. Randomly, I get the message EAccessViolation: Access violation at address 00000000. Read of address 00000000 and the program shutdown. At...

This is a new thread for an old issue. Please, excuse me on insisting about it, but I'm a bit desperate. http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=1;t=002376 1. When I first record datasets A and B, and then I record dataset C, everything goes fine, because ID_B...

Hello Marco. Please, let me insist on this issue again. I think I didn't understand well enough your last question. Anyway, I

Thank you, I'll try it. Although I find using DOA without any other component is very easy, I realize that TClientDataSet and TDataSetProvider components give you more posibilities. Next project I'll use this method, because my actual project is too big to change all the data modules.

Yes, yesterday night I was thinking about it and this morning I've tried it, but doesn't work. I don't know how to connect the TOracleDataSet to TClientDataSet. The procedure Assing doesn't go with TOracleDataSet. Using TVirtualTable is simpler than Delphi's component. The only inconvenient I...

You

Thank you for your advice.I

Sure, my English is not good enough, but I

I