Master-Detail dosn't work with Advantage Database

shsit · Post by **shsit** » Tue 21 Feb 2012 14:13

Hi,

I'm using ADS Server 10 and Unidac compoenents version 3.5 with D2009.

I got an TUniQuery (qryMessages) and an TUniTable (tblMessageAttachement) component which I want to connect via master-detail relationship.

So I set up the qryMessages as the master source for tblMessageAttachement and give it a master and a detail field.

When I try to set up the tblMessageAttachement to connected at design time, I got the follwing error:

---------------------------
Error
---------------------------
Unknown data type.
---------------------------
OK Details >>
---------------------------

Thanks for some help!

shsit · Post by **shsit** » Wed 22 Feb 2012 08:17

Just updated to 4.1.3 and the error still occurs.

Edit: I've just replaced the TuniTable with a TuniQuery and this does work.

AlexP · Post by **AlexP** » Wed 22 Feb 2012 12:43

hello,

Please send the scripts for creating master and detail tables, and also specify the fields you use for associating these tables.