hallo,
I work with Delphi6, Midas, DOA 3.4.6.
the facts :
- I make a data request with more than one table
- the primkey of the first table doesn't
identify each record uniquely ( just a
normal join with two tables)
- the appserver says correctly 14 records
- my client gets only 2 records. after setting an
index on my clientdataset, all records appear.
a similar problem has been posted here already.
i could solve the problem in my special case by
swapping the order of the tables in the from
clause, but this can't be a real solution,
especialy because i have a lot of old code here.
any comments or hints ?

thanx for answers, and merry christmas.

osti

Version 4.0 allows you to control whether or not the key fields are transferred to the client. In 3.4 you have to specify the key preserved table in the UpdatingTable proprty, or you need to speficy the UniqueFields.