>i made a formset with a data environment and grids.
>from sad experience, i decided to use sql statements
>in the second form.
>
>my problem is, they don't update at once. is it the
>buffering in the formset?
>1. tried turning it off to default data session but
>still, data does not update.
>2. with buffering on, i tried tableupdate() and still
>no bite (got an error also).
>
>i kept reading on buffering, bufermodes and cursors
>created for the form but no clue on my problem.
>
>here's a sample code :
>
>* get the current highest job_id from realcodes
>select jobid from realcodes into cursor temp
>* increment for next job id
>lnrealJobid = temp.jobid + 1
>* cursor clean up
>use in temp
>lsJobgrp = this.txtJobgrp.value
>* insert the values
>insert into job (jobid, pseudojobid, jobgrp) ;
> values (lnrealJobid,
> val(this.txtpseudoJobID.value, ;
> lsJobgrp)
>* update the real job id value
>update realcodes set jobid = lnrealJobid
>
>the update doesn't seem to take place on the realcodes
>table. this causes indexing error on next entry because
>real job id has old value, giving next entry same value
>as in the child table.
>
>many thanks in advance.


Try putting this before the select:

SELECT realcodes
GO RECNO()