Helen Answered:

>Masterlinks: ANIMALPHOTO.ANIMALPHOTOANIMALID := ANIMAL.ANIMALID

This is wrong. MasterLinks is an ib_stringlist. Each entry is a
string of the form (using your example)
ANIMAL.ANIMALID=ANIMALPHOTO.ANIMALPHOTOANIMALID
i.e. detail link on the left, and an equals sign with no spaces.

You can't assign MasterLinks in code using a Delphi assignment
operator. You must use
aDataset.MasterLinks.Add('ANIMAL.ANIMALID=ANIMALPHOTO.ANIMALPHOTOANIMALI
D');

I suspect IBO is somehow parsing something out of your code but, at
best, it will have the relationship reversed because it's being told
that ANIMALPHOTO is the detail side.

Helen
Sorry Helen, a small typo.
I had : ANIMALPHOTO.ANIMALPHOTOANIMALID = ANIMAL.ANIMALID in the
masterlinks property of the IB_QueryPhotos.
I noted about the spaces, and changed it to:
ANIMALPHOTO.ANIMALPHOTOANIMALID=ANIMAL.ANIMALID
AND IT NOW WORKS!!
? Why are the spaces so important?
? Why was the query working elsewhere?
I'll go through my code and check this carefully, for more errors.
?Did you reverse the order purposefully.
The master is ANIMAL, and the child is ANIMALPHOTO.
Many thanks for your prompt answer!!
Adrian
Messages
<http://groups.yahoo.com/group/IBObjects/message/40687;_ylc=X3oDMTM1MDZh
NmdvBF9TAzk3MzU5NzE0BGdycElkAzQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEbXNnSWQD
NDA2ODgEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMTY3MjIxMDIxBHRwY0lkAzQwNjg3>
in this topic (2)
<http://groups.yahoo.com/group/IBObjects/post;_ylc=X3oDMTJwc3Y1c2xtBF9TA
zk3MzU5NzE0BGdycElkAzQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEbXNnSWQDNDA2ODgEc
2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMTY3MjIxMDIx?act=reply&messageNum=40688>
Reply (via web post) | Start
<http://groups.yahoo.com/group/IBObjects/post;_ylc=X3oDMTJkZzdyMjllBF9TA
zk3MzU5NzE0BGdycElkAzQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEc2VjA2Z0cgRzbGsDb
nRwYwRzdGltZQMxMTY3MjIxMDIx> a new topic
Messages
<http://groups.yahoo.com/group/IBObjects/messages;_ylc=X3oDMTJkbWZybHE5B
F9TAzk3MzU5NzE0BGdycElkAzQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEc2VjA2Z0cgRzb
GsDbXNncwRzdGltZQMxMTY3MjIxMDIx> | Files
<http://groups.yahoo.com/group/IBObjects/files;_ylc=X3oDMTJlMWMya2VsBF9T
Azk3MzU5NzE0BGdycElkAzQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEc2VjA2Z0cgRzbGsD
ZmlsZXMEc3RpbWUDMTE2NzIyMTAyMQ--> | Photos
<http://groups.yahoo.com/group/IBObjects/photos;_ylc=X3oDMTJkY2syb2o0BF9
TAzk3MzU5NzE0BGdycElkAzQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEc2VjA2Z0cgRzbGs
DcGhvdARzdGltZQMxMTY3MjIxMDIx> | Members
<http://groups.yahoo.com/group/IBObjects/members;_ylc=X3oDMTJkc2RyZzVuBF
9TAzk3MzU5NzE0BGdycElkAzQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEc2VjA2Z0cgRzbG
sDbWJycwRzdGltZQMxMTY3MjIxMDIx>
________________________________________________________________________
___
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
________________________________________________________________________
___
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !


<http://groups.yahoo.com/;_ylc=X3oDMTJjNWt0cTFjBF9TAzk3MzU5NzE0BGdycElkA
zQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEc2VjA2Z0cgRzbGsDZ2ZwBHN0aW1lAzExNjcyM
jEwMjE-> Yahoo! Groups
Change
<http://groups.yahoo.com/group/IBObjects/join;_ylc=X3oDMTJlZzZnZ2xrBF9TA
zk3MzU5NzE0BGdycElkAzQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEc2VjA2Z0cgRzbGsDc
3RuZ3MEc3RpbWUDMTE2NzIyMTAyMQ--> settings via the Web (Yahoo! ID
required)
Change settings via email: Switch
<mailto:IBObjects-digest@yahoogroups.com?subject=Email%20Delivery:%20Dig
est> delivery to Daily Digest | Switch
<mailto:IBObjects-traditional@yahoogroups.com?subject=Change%20Delivery%
20Format:%20Traditional> format to Traditional
Visit
<http://groups.yahoo.com/group/IBObjects;_ylc=X3oDMTJjbnJta3F0BF9TAzk3Mz
U5NzE0BGdycElkAzQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEc2VjA2Z0cgRzbGsDaHBmBH
N0aW1lAzExNjcyMjEwMjE-> Your Group | Yahoo! Groups
<http://docs.yahoo.com/info/terms/> Terms of Use | Unsubscribe
<mailto:IBObjects-unsubscribe@yahoogroups.com?subject=>
Recent Activity
* 6
New
<http://groups.yahoo.com/group/IBObjects/members;_ylc=X3oDMTJlZzIzbW42BF
9TAzk3MzU5NzE0BGdycElkAzQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEc2VjA3Z0bARzbG
sDdm1icnMEc3RpbWUDMTE2NzIyMTAyMQ--> Members
* 2
New
<http://groups.yahoo.com/group/IBObjects/files;_ylc=X3oDMTJmbGI5dmw3BF9T
Azk3MzU5NzE0BGdycElkAzQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEc2VjA3Z0bARzbGsD
dmZpbGVzBHN0aW1lAzExNjcyMjEwMjE-> Files
Visit
<http://groups.yahoo.com/group/IBObjects;_ylc=X3oDMTJkOXNhaGcyBF9TAzk3Mz
U5NzE0BGdycElkAzQwMjkzMARncnBzcElkAzE3MDUwMDcxODMEc2VjA3Z0bARzbGsDdmdocA
RzdGltZQMxMTY3MjIxMDIx> Your Group
SPONSORED LINKS
* Database
<http://groups.yahoo.com/gads;_ylc=X3oDMTJiaWc3YjlmBF9TAzk3MzU5NzE0BF9wA
zEEZ3JwSWQDNDAyOTMwBGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDc2xtb2QEc3RpbWUDMTE2N
zIyMTAyMQ--?t=ms&k=Database+marketing+software&w1=Database+marketing+sof
tware&w2=Database+management+software&w3=Real+estate+database+software&w
4=Online+database+software&w5=Customer+database+software&c=5&s=164&g=2&.
sig=g6pGF4c1NuMtpJQs2_lazA> marketing software
* Database
<http://groups.yahoo.com/gads;_ylc=X3oDMTJicnZtMGZqBF9TAzk3MzU5NzE0BF9wA
zIEZ3JwSWQDNDAyOTMwBGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDc2xtb2QEc3RpbWUDMTE2N
zIyMTAyMQ--?t=ms&k=Database+management+software&w1=Database+marketing+so
ftware&w2=Database+management+software&w3=Real+estate+database+software&
w4=Online+database+software&w5=Customer+database+software&c=5&s=164&g=2&
.sig=E1wTNw0Uv8Y3ShQBvzeOYQ> management software
* Real
<http://groups.yahoo.com/gads;_ylc=X3oDMTJiMjVrN212BF9TAzk3MzU5NzE0BF9wA
zMEZ3JwSWQDNDAyOTMwBGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDc2xtb2QEc3RpbWUDMTE2N
zIyMTAyMQ--?t=ms&k=Real+estate+database+software&w1=Database+marketing+s
oftware&w2=Database+management+software&w3=Real+estate+database+software
&w4=Online+database+software&w5=Customer+database+software&c=5&s=164&g=2
&.sig=t-Jgj0oKtm2jNkyhAzEetw> estate database software
* Online
<http://groups.yahoo.com/gads;_ylc=X3oDMTJicXR1Mjl0BF9TAzk3MzU5NzE0BF9wA
zQEZ3JwSWQDNDAyOTMwBGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDc2xtb2QEc3RpbWUDMTE2N
zIyMTAyMQ--?t=ms&k=Online+database+software&w1=Database+marketing+softwa
re&w2=Database+management+software&w3=Real+estate+database+software&w4=O
nline+database+software&w5=Customer+database+software&c=5&s=164&g=2&.sig
=bpX9JrNp1XZmlpXwYa7K-g> database software
* Customer
<http://groups.yahoo.com/gads;_ylc=X3oDMTJiYTlxNWFmBF9TAzk3MzU5NzE0BF9wA
zUEZ3JwSWQDNDAyOTMwBGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDc2xtb2QEc3RpbWUDMTE2N
zIyMTAyMQ--?t=ms&k=Customer+database+software&w1=Database+marketing+soft
ware&w2=Database+management+software&w3=Real+estate+database+software&w4
=Online+database+software&w5=Customer+database+software&c=5&s=164&g=2&.s
ig=k1eu8JZMX8p0ek_nYelHmA> database software
Career Change
Yahoo!
<http://us.ard.yahoo.com/SIG=12i3fe1fv/M=493064.9803220.10510213.8674578
/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1167228221/A=3848554/R=0/SIG=10o5t
jndh/*http:/www.hotjobs.com> HotJobs
Search Jobs
Find the right one
Search Ads
Get
<http://us.ard.yahoo.com/SIG=12iolb41n/M=493064.9803227.10510220.8674578
/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1167228221/A=3848641/R=0/SIG=1312g
85fq/*http:/searchmarketing.yahoo.com/arp/srchv2.php?o=US2003&cmp=Yahoo&
ctv=Groups2&s=Y&s2=&s3=&b=50> new customers.
List your web site
in Yahoo! Search.
Yahoo! Groups
Start
<http://groups.yahoo.com/start;_ylc=X3oDMTJuZmZrZTgxBF9TAzk3MzU5NzE0BF9w
AzMEZ3JwSWQDNDAyOTMwBGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDbmNtb2QEc2xrA2dyb3Vw
czIEc3RpbWUDMTE2NzIyMTAyMQ--> a group
in 3 easy steps.
Connect with others.
.

<http://geo.yahoo.com/serv?s=97359714/grpId=402930/grpspId=1705007183/ms
gId=40688/stime=1167221021/nc1=3848554/nc2=3848641/nc3=3>



[Non-text portions of this message have been removed]