working with discrete result sets using sdos

[sseguron]

Hi Folks,

We have to work, for some reasons, with sets of records (through sdos) which are not the result of a straightforward query but more a list of primary keys.
What kind of solution do we have to work with such result sets.

For ex : we need to work with 20 "item" records which have the id : 231,344,222,346,443,566,767,887,899,100,232,...

what are the means of using sdos with such discrete data sets.

temp-table sdos ? in such case, how do you implement data validation on commit ?

 

[Dries Feys]

Hello,

What you can do is make a comma separated list of different values. Let's name this list charValues

Then you make a call (eg in initializeObject) like this.

Dynamic-function('setQuerywhere':U in hanSdo,
INPUT "for each item where can-do(charValues,item.value)").
Dynamic-function('OpenQuery':U in hanSDO).

This way, you should still have some kind of acceptable speed while not using such a straight-forward way.