I have figured out a way to implement Progress can-find statements into my Query.
The Problem:
I needed to query a table display results, but in order for the result to be valid, It could not exist in another table. A direct can-find or a User-defined function would have been perfect if allowed.
Solution:
Create the Query to search the DB table.
In the main-block of the smart object, you can implement your can-find.
eg. Open Query {&self-name} for each table1 no-lock.
Main Block:
on find of table1
do:
if can-find (first table2 where table2.value = table1.value)
then return error.
end.
My Browser when fired will only display results for table 1 that do not exist in table 2.
I hope this helps others as I have searched for hours trying to implement a solution to open queries without implementing the use of temp-tables.
Progress 9.1D08 ADM1.
The Problem:
I needed to query a table display results, but in order for the result to be valid, It could not exist in another table. A direct can-find or a User-defined function would have been perfect if allowed.
Solution:
Create the Query to search the DB table.
In the main-block of the smart object, you can implement your can-find.
eg. Open Query {&self-name} for each table1 no-lock.
Main Block:
on find of table1
do:
if can-find (first table2 where table2.value = table1.value)
then return error.
end.
My Browser when fired will only display results for table 1 that do not exist in table 2.
I hope this helps others as I have searched for hours trying to implement a solution to open queries without implementing the use of temp-tables.
Progress 9.1D08 ADM1.