[Stackoverflow] [Progress OpenEdge ABL] how to insert the field values in the connected openedge database when table and column names are given

Status
Not open for further replies.
A

Anusha Rallabhandi

Guest
#1
I've retrieved the field names of a table by giving the table name directly (INS_TEST is the name of my table). I used columns _Field-Name, _Data-Type of the _Field system table and retrieved the field names and their data types.

I want to use the retrieved field names and insert field values into those fields.

FOR EACH _File WHERE _File-Name = "INS_TEST":

FOR EACH _Field WHERE _File-Recid = RECID(_File):
DISPLAY _Field._Field-Name.
DISPLAY _Field._Data-Type.
ASSIGN _File._File-Name._Field._Field-Name = 1 WHEN (_Field._Data-Type EQ "INTEGER").
END.


END.

But the ASSIGN statement gives an error. Suggestions please!

Continue reading...
 
Status
Not open for further replies.
Top