• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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

Not open for further replies.

Anusha Rallabhandi

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").


But the ASSIGN statement gives an error. Suggestions please!

Continue reading...
Not open for further replies.