>When you issue begin and end transaction it doesnt update the table. It updates without transaction wrapup commands. The problem is all my library uses begin and end transaction when saving records.
>
>Sergey if you like i can send to you my database for you to check my salesm1.dbf.
>
>
>the example below does not insert 20 records to salesm1.dbf if theres begin and end transaction. Please help me
>
>
>clos table all
>use salesm1
>begin trans for i = 1 to 20
> m.tseqno = tseqno +1
> appen blank
> repla tseqno with m.tseqno
>endfor
>end trans
begin trans and
for i = 1 to 20 should be on separate lines.
What does the program do instead of inserting 20 records, as expected? (Sorry, I don't have the code you sent me right here now, to test it).
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)