Hi,
I am evaluating UniDac for this project. I am using D7.
This project has a rather unusual update.
1) I must select from a view
2) I must insert and update a table
3) the delete is in fact an update. Records never get deleted.
For example:
Select from VW_Customer
Insert > Insert into tb_customer ( ) values ( Update tb_customer set
Delete > Update tb_customer set sys$sts = 2 where ID = :ID
With this i mind, I tried every possible combination in order to update/Insert TB_CustOrder
select> Select from vw_custorder where Cust_FK = :Cust_ID
I have to write myself the where part. If I use the properties MasterFields and DetailFields, the where is built, but the record are not shown [:-(]
insert> insert into tb_CustOrder ( ) values ( next value for gen_CustOrder, :Cust_FK , )
No matter what I place in :Cust_FK, I always get an error.
When using :Cust_FK I get the following error :
---------------------------
validation error for column @1, value "@2"'.
---------------------------
When using :Cust_ID I get the following error :
---------------------------
Not found field corresponding parameter Cust_ID.
When using the :Cust_FK parameters, the SQLmonitors shows a value for the parameter Cust_FK.
The MasterSource is set. And the SQL for insert, update, delete are generated dynamically.
I am using FB2.1 and just downloaded your Trial.
Can you help me? What am I missing?
TIA,
Clément