[Stackoverflow] [Progress OpenEdge ABL] Create new row with datagridview and probindingsource

[JulesVerne]

I want to use a datagridview to create a new entry in a database table. Becouse of triggers it is not possible to use autoUpdate of my probindingsource (and it is intended only for rapid prototyping). I dont know what i have to do in what order. My probindingsource is bound to a query.

    CREATE QUERY hQuery.
    hQuery:SET-BUFFERS(BUFFER bfJob:HANDLE).
    cQuery = "FOR EACH bfJob NO-LOCK WHERE bfJob.user_id = " + STRING(ct:getUserID()) + " BY dStep".
    hQuery:QUERY-PREPARE(cQuery).
    THIS-OBJECT:pbsJob:HANDLE = hQuery.
    dgvJob:REFRESH().

I think i need CreateRow and RowLeave events to handle this transaction. I hope someone can give me an easy example to solve my problem.

Continue reading...