Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weird scenario with INSERT
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01410932
Message ID:
01411213
Views:
28
I've had some weird behavior issues in the past (not exactly this one) and I've all but cured them by adding reccount() before my insert commands. Like:

select mytable
=reccount()
insert into mytable (fields) values (values)


Does that have any effect for you?

You don't, by chance, have the same table open multiple times under multiple aliases do you?
Brandon Harker
Sebae Data Solutions
Previous
Reply
Map
View

Click here to load this message in the networking platform