how to fetch field values from tables

[maxpade]

hi all,

as you know i'am am a newbie here an also in programming with progress....

i have following question:

i want to fetch values from 2 tables and write them into another (third) table...

therefore i've created a sdo and a sdv for the 2 tables.
i've put the two sdv into a window so that i can navigate through the records of each table with a spin.

how can i fetch now from table A a field-value and from table B another field-value an put them in table C? how i can realize that?

all help would be appreciated.
thanks in advance
maxpade

 

[joey.jeremiah]

a dataobject can also query temp-tables. you can create a temp-table
and have the dataobject query that.

adm is very useful in some cases, but for one its very complicated
and it also throws alot of advance concepts into the mix.

i would not recommend starting out with adm.

 

[lord_icon]

dont jump in - lets refresh

Talk through your requirements - forget what you believe you know.

i want to fetch values from 2 tables and write them into another (third) table...

FIND tablename1 WHERE fieldCriteria NO-LOCK.
FIND tablename2 WHERE fieldCriteria NO-LOCK.

/* both tables are in the buffer */

ASSIGN
table3Field = tablename1.field
table3Field = tablename2.field
.
/* table3 now populated with required data*/
/* table3 can be a temptable - it is just an example to get you started */

This data can be a procedure within an object that is realized.