Search code examples
databaseopenedgeinsert-updateprogress-4gl

Open Edge Progress database update query

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?

Solution

  • You first need to access a record:

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

    or

    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.