Open Edge Progress database update query-CodePudding

I'm a beginner in Open Edge Progress database.

Is there any query to update/insert data into progress database table

my try was

ASSIGN
  TABLE.COLUMN=DATA
END

Is this correct?

CodePudding user response：

You first need to access a record:

FIND TABLE WHERE TABLE.FIELD = 42 EXCLUSIVE-LOCK.

FIND FIRST TABLE EXCLUSIVE-LOCK.

or create a record:

CREATE TABLE.

You're assign statement is missing a period (.) to terminate the statement - and you don't need an END statement unless you're opening a block somewhere.

ASSIGN TABLE.COLUMN=DATA.