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

BLOMASKY wrote
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

PointsWell wrote
BLOMASKY wrote
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

BLOMASKY wrote
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