Problem when inserting/appending
Posted: Sun 25 Mar 2007 01:25
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
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