DOA 4.0.5
I have a query select statement using "for update" where I want to be able to update a couple of the fields that are returned but I can't find any way to actually set the field.
I can't find anything in the help that indicates how to do this. It SEEMS to indicate that you can use the "for update" capability but there seems no way to do an assignment to a field using a query component.
Do I have to use a dataset and a data aware component in my code?
Also if there IS a way to do this, at what point would the update to the field be commited? Would transactions control this?
I have a query select statement using "for update" where I want to be able to update a couple of the fields that are returned but I can't find any way to actually set the field.
I can't find anything in the help that indicates how to do this. It SEEMS to indicate that you can use the "for update" capability but there seems no way to do an assignment to a field using a query component.
Do I have to use a dataset and a data aware component in my code?
Also if there IS a way to do this, at what point would the update to the field be commited? Would transactions control this?
