Create new row with datagridview and probindingsource

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-OBJECTbsJob: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...