Recent content by wkd24154

Isn`t anybody out there? My problem still exists but I don`t get any response since one month.

The first and second table have respectively two PKs - one of them with a sequence. The third table has two PKs without a sequence.

The same.

I only declared AfterInsert-events for all three tables to set default values of not null columns.

Hello, I use the components of Doa Versions 4.0.3. I have three tables in a master-detail relationship. The first table tab1 is master of table tab2. tab2 is additional master of tab3. After I insert in all three table a record like this tab1.insert; tab2.insert; tab3.insert; and I just try...

Thanks for your reply. My mistace was this one: I create a new function to execute a sql statement. At first I set ExecSQL and if the sql text contains the select statement I set the DataSet to active.

If I use a TOracleDataSet component to select the nextvalue of a sequence I`ll only get every second number. What could be the reason (if I use a query with the same select statement it`s works)?

In my application there are 15 other programmers who make changes at the sources. So it could be that someone add a column e.g. at the second place and then I`ll don`t get the searched value. Are there any other possibilities?

Is it possible to create all Fields of a TOracleDataset select-statement at runtime? At design-time I double click on the TOracleDataset and click on the right mouse button at the open window. Then I`ll could choose "Alle Felder hinzuf

What could be the reason that QueryAllRecords := False doesn`t work?

How can I insert a record if the TOracleDataSet is in QBE mode without executing the query? If I set the QBEMode to false the query is executed and after that a new record is insert. Here a little example: with odsTest do begin if QBEMode then QBEMode := False; Insert; end;

Maybe I said it misunderstandly. I want to commit all changes of a dataset with outer join select statement. Could someone give me a simple testcase?

And how can I commit the table tab1 in the OnApplyRecord event if I use a outer join select statement like this: select tab1.rowid, tab2.rowid, tab1.id, tab2.tab1_id from tab1, tab2 where tab1.id (+) = tab2.tab1_id

It is right that I want to commit each column of the table. So I tried to create an OnApplyRecord event but it doesn`t work. The problem is, that I create the DataSet at runtime. So how can I create an OnApplyRecord trigger for this event at runtime? Could you send me a little example?

Hello everybody, how is it possible to commit cached updates if the query goes to more than one table? Here a little example: select tab1.rowid, tab2.rowid, tab1.id, tab2.tab1_id from tab1, tab2 where tab1.id = tab2.tab1_id Can someone give me a solution?