Is there a problem with a Per Relationship to the same BO?

[BLOMASKY]

I have orders that are optionally linked to other orders in a 1 to 1 relationship. That seems to work fine. Looking at the SQL tables, all is good. The problem is, that I have a process that is called from a query (which uses OrderLines as input). Here is the code:

FIND OrderLines WHERE OrderLines = OrderLines.ps_LinkToContractorOrderLine
DISPLAY MESSAGE SEARCH_COUNT


I always get a ZERO. Nothing is found. Am I doing something wrong?

Thanks
Bruce

[PointsWell]

I have orders that are optionally linked to other orders in a 1 to 1 relationship. That seems to work fine. Looking at the SQL tables, all is good. The problem is, that I have a process that is called from a query (which uses OrderLines as input). Here is the code:

FIND OrderLines WHERE OrderLines = OrderLines.ps_LinkToContractorOrderLine
DISPLAY MESSAGE SEARCH_COUNT


I always get a ZERO. Nothing is found. Am I doing something wrong?

Thanks
Bruce

My first impression is that this will not return anything because there’s no differentiator between what you are looking for and what you are comparing against.

How does the query get initiated? Can you differentiate ThisOrderLines.

[BLOMASKY]

I have orders that are optionally linked to other orders in a 1 to 1 relationship. That seems to work fine. Looking at the SQL tables, all is good. The problem is, that I have a process that is called from a query (which uses OrderLines as input). Here is the code:

FIND OrderLines WHERE OrderLines = OrderLines.ps_LinkToContractorOrderLine
DISPLAY MESSAGE SEARCH_COUNT


I always get a ZERO. Nothing is found. Am I doing something wrong?

Thanks
Bruce

My first impression is that this will not return anything because there’s no differentiator between what you are looking for and what you are comparing against.

How does the query get initiated? Can you differentiate ThisOrderLines.

[PointsWell]

Did you mean to post? There was no new content.

[BLOMASKY]

Humm, the forum hates, me, after I try to post a msg, it tells me to LOG IN again and throw out what I posted.

Jaymer gave me the correct answer...

FIND OrderLines WHERE ... = ThisOrderLines.....

Bruce

[customaware]

I have orders that are optionally linked to other orders in a 1 to 1 relationship. That seems to work fine. Looking at the SQL tables, all is good. The problem is, that I have a process that is called from a query (which uses OrderLines as input). Here is the code:

FIND OrderLines WHERE OrderLines = OrderLines.ps_LinkToContractorOrderLine
DISPLAY MESSAGE SEARCH_COUNT


I always get a ZERO. Nothing is found. Am I doing something wrong?

Thanks
Bruce

Did you try....

FIND OrderLines WHERE OrderLines = ThisOrderLines.ps_LinkToContractorOrderLine
DISPLAY MESSAGE SEARCH_COUNT