Adm2

[lord_icon]

OpenEdge 10 / Windows
How do I configure my SDO (query) to use 2 tables?
I have a Smart Data Viewer with my Order header details (reading from the order table in the db) / I have another Smart Data Viewer with my Order Line details (reading from the order line table in the db) I wish to have a Smart ToolBar that will table IO to both Objects / tables. How do I achieve this?

 

[joey.jeremiah]

> How do I configure my SDO (query) to use 2 tables?

> I wish to have a Smart ToolBar that will table IO to both Objects /
> tables. How do I achieve this?

I don't have alot of time, so I'll make it short.

Those are 2 diff questions, maybe you could clarify what program your trying to write and we could explain what would be the convention setup in that case.

For your first question usually there is an updateable full SDO for one table and vice versa a table only has one updateable SDO. Ofourse there are usually reference fields ( joins ) for descriptions etc. that are not updateable and the join is many-to-one.

For the second, very generally you could use anyone of the standard toolbars that come with adm and dynamics or create your own. And simply connect that single toolbar to many objects in a mutipage folder. The toolbar and menu will change it's state according to the selected page and will only effect that page.

Finally, there are tons of example in the docs. From what I remember on those specific cases, take a look at the adm and smartobjects doc, there's a chapter that's an introduction to SDO's. And the advanced dynamics doc, the chapter on advanced ui features talks about using a single toolbar with multipage folders.

HTH, got to run, bye