replacement for NOT CAN-FIND in SDO

P

Paul123

New Member
How can I filter the records in one SDO based on values that are absent from another unlinked SDO?
I have a many to many relationship between table A and table B with table C being the interfile to link the two tables. I have an input screen for table A with a button to launch a window to create links to table B by creating records in table C. The child window has SDOs and browsers for both table B and table C and the foreign fields are passed from the parent window.
There are buttons to add and remove records from table C based on the currently selected row in one or the other browser. As there is a fairly limited number of records from table B which are eligible to be linked with table A I would like to use this simple select method to add and remove records but need to keep the table B browser in sync with table C by showing only those records which are not already linked. I have been able to use the rowValues function to create a query in cases where there is only a single key field but I can't use this with tables having multiple key fields.
Any suggestions would be greatly appreciated.
thanks,
Paul
Progress v 9.1E
Windows XP
 
As you specified that table “C” provides links to table “A” and table “B”. I think you have foreign key in table “C” and primary keys in other two tables.
Now you can do one thing, Take all records which are in table “C” to temp-table and based on event (add, delete etc) update the records in temp-table for table “C”. Now on write and delete of temp-table you can find the records in table “A” and table “B” based on temp-table (table “C”) records. Here you can delete records of table “A” and “B” which are not matching with table “C” and refresh the browse for all tables.

 
Thanks. I thought it might involve temp-tables. I have not used them in the ADM before so it may take a little getting used to but no doubt an improvement on creating querries. I assume that I can use smartLinks to keep my sdo in sync with the temp-table.
 
Greetings,
You have obviously not grasped the concept of the ADM(2) and Smart Objects.
Re:I assume that I can use smartLinks to keep my sdo in sync with the temp-table.
>>You should never assume anything. To assume is to make an *** of u and me.
>A temp table is NOT real, it is a buffer of memory for data. Why would it be required to link to a temp table?
 
Please enlighten me oh Lord of the Icons. Why would one create a SDO temp-table if not to make use of smart links?

lord_icon said:
Greetings,
You have obviously not grasped the concept of the ADM(2) and Smart Objects.
Re:I assume that I can use smartLinks to keep my sdo in sync with the temp-table.
>>You should never assume anything. To assume is to make an *** of u and me.
>A temp table is NOT real, it is a buffer of memory for data. Why would it be required to link to a temp table?
Click to expand...
 
You must log in or register to reply here.
Back
Top