Problem when inserting/appending

[DCast]

Hello,

I have the following scenario:

qQuery:
Select * From tbl_table t, sys_table s Where (s.nr = t.sys)

tbl_table:
nr INTEGER pk,
sys INTEGER not null,
filler varchar

sys_table:
nr pk,
filler varchar

Now here's my problem, when i try to add a record to qQuery, it keeps failing with the following message i know that this is a required field in sys_table, but i'm doing exactly the same with your MySQLDAC and that is doing what i want.

What i want is, the main table (tbl_table) to be updated.

Is this possible in ODAC too?

i'm i overlooking something?

Thx.

/Michael

[Plash]

You should change the SQL property value to the following:

Code: Select all

SELECT t.*, s.filter FROM tbl_table t, sys_table s
WHERE (s.nr = t.sys)