How can i get through with this error,, multiple set operation generated error. Check each status value.. im using data Environment for the data source,,i would like to add new data un a table in the visual foxpro 9,,connected by the data environment,,but this error occur before the update command,,i search all over the net and i can't find the solution,,

here are the codes,,

 

 DatEnv1.rstable.open

With DatEnv1.rstable                 .AddNew                 !header = header + 1               'autonumber                 !code = txtcode.Text                 !Title = txttitle.Text                 !CurAmt = nCurAmt           'computed variable                 !CurPer = nCurPer                 !PrvAmt = nPrvAmt                 !PrvPer = nPrvPer                 !MonAmt = nMonAmt                 !MonPer = nMonPer                 .Update                            'this is the error,,dont know why                 .Requery             End With             DatEnv1.rstable.MoveNext             DatEnv1.rstable.Close

 

nEeD hELp hEre !!!,, tHnx



Software/Hardware used: