Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot update the table
Message
From
18/04/2002 17:07:38
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00644937
Message ID:
00646625
Views:
16
>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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform