Page 1 of 1

Problem with defaultvalue

Posted: Mon 29 Oct 2007 21:17
by caribou
version odac 6.10.1

I've a query with

Code: Select all

 qsoin.sql.text :='SELECT  P_SOIN.*,  ZZ_FAM.LB_FAMILLE
                                FROM  P_SOIN,  ZZ_FAM
                                 WHERE
                                ZZ_FAM.CD_FAMILLE = P_SOIN.CD_FAMILLE';

qsoin.updatingtable:='P_SOIN';
qsoi.defaultvalue:=true;
I' ve a problem with

Code: Select all

qsoin.append;
The default values of the fields are not loaded ?

why? I don't understand

We did not have this problem before update ODAC[/code]

Posted: Wed 31 Oct 2007 08:21
by Plash
ODAC supports default values only for queries with one table. We'll consider possibility to support the DefaultValues option for queries with several tables in either of the next ODAC versions.