Recent content by nboodram

Thanks for your support, as always! Natalie

Hello, Are there any code examples that show how to cancel a query that the database server is taking a long time to execute (select operation)? Thanks, Natalie

Hello, If I set my TOracleSession's IntegerPrecision property to -8, will that pull all numeric fields in as float? Natalie

I am having the same problem. Where is this method that is referred to? (GetConstraints)

More information: the problem only occurs when there is a primary key on the parent table, the parent table is listed first in the FROM clause of the SQL, and there is an ORDER BY on the parent field. Please note that a sample project has been sent to support@allroundautomations.com that...

Hello, I am using DOA in a multi-tier setup: hooking up a TDataSetProvider to the TOracleDataset and passing the data to a TClientDataSet. I have a situation where a particular sql in the TOracleDataset is causing the clientdataset to hide some records. The SQL joins several tables and has an...

I seem to remember reading at one point that the updates were applied in the order that they were done in the client datasets. Is it possible for you to make the third nested dataset a child of one of the others since it has dependencies on them? This way the relationship is clear to Delphi...

Try taking a look at the following FAQ: http://www.allroundautomations.com/ubb/Forum1/HTML/000002.html Natalie

I tried that when I saw your post and it does not work for me. I get an error on the TOracleDataset "Cannot perform this operation on a closed dataset." We would not want to use ResolveToDataset as a permanent solution, either, because of the extra overhead. Natalie

Further information: If the client datasets start off with no parent records and the parent is appended and then the child appended, the error does not happen. If the parent has at least one record and a new parent is appended and then the child appended, the error happens. Hopefully that helps...

I was having the same problem in the IDE this morning with the "not all variables bound" and then the "Index out of bounds (0)" errors. If I can create steps to easily reproduce, I will send them. Natalie

Hello, I have a parent-child-grandchild setup using TOracleDatasets on the back end and TClientDatasets on the client end. If I have just parent and child, my updates work fine. When I add the grandchild, the update on the child table loses its primary key field in the "insert" statement and...

Perfect, thanks. Sometimes the answer is right there in front of your face!

One other comment that I forgot in my earlier post-- when using MasterSource and MasterFields, does the client side access the data through the DataSetField property of the clientdataset? This is used throughout our code and would be a pain to have to change it.