Lookup-Fields: Fetch Only needed

Data Abstract
#1

Hello,

is there any way to fetch only the needed rows from a Look-Up-Table?

I’ve got three tables:
Table A - Master
Table B - Details (containing LookUp-Fields to Table C)

Table C - LookUp-Table

Table C is a rather big table and for most of the time it isn’t needed to choose another value in Table B - so there is no need to load the entire Table C.

However for displaying/interacting I need the rows in Table C which are referred from Table B.

Best regards,
Peter

#2

What platform (Delphi, .Net, XCode) you are using?

#3

Delphi.

#4

Hello,
Please look at “Fetch” example. It can be helpful for you.
You can find it in the following folder:
XP: "C:\Documents and Settings\All Users\Documents\RemObjects Samples\Data Abstract for Delphi\Old"
Vista,Win7: “C:\Users\Public\Documents\RemObjects Samples\Data Abstract for Delphi\Old”

#5

Hello,

I’m using version 9.4.107.1363 and I wish to achieve the same function as mentioned but in .NET platform. Do you have example?

#7

Please take a look at

topic “Eager Data Loading”