Subject Re: [IBO] KeyLinks and KeyLinksAutoDefine
Author TeamIBO
Hi Martijn,

> There's really not much to it - the problem seemed easy
> reproducable to me.

What was that about "assuming"?? ;-)

> for employee, tmpStr will turn up EMP_NO - if I select FIRST_NAME,
> there's no way that pos(tmpStr, SQLSelectStr) = 0 -> so, keylinks
> get cleared, DB_KEY gets added

> tmpStr will become ID (PK column) and Pos(tmpStr, SQLSelectStr)
> gives pos > 0 ----> no keylinks clear, no DB_KEY added --> error...

Yep that all makes sense. I was thinking this was the area of the
code most likely to be causing problems, but just by looking at it I
was not certain what was wrong. Its pretty obvious now that you point
it out with an example.

> Geoff, I hope you can reproduce the error as easy as me with the
> above DDL and we both get the error at the same position in code - I
> guess we can find a way to fix it now...

I think there may be some utility functions in IB_Parse that can help
us out in this situation. I will investigate further now that I know
how to reproduce.

Geoff Worboys - TeamIBO
Telesis Computing