Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert not inserting no more
Message
From
25/08/2014 08:51:18
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
23/08/2014 05:42:52
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows NT
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01606233
Message ID:
01606345
Views:
110
>>>>Your explanation doesn't make sense to me, I suggest you spend some more time and fix whatever is wrong in your code.
>>>
>>>Nick Mason reminded us that insert won't work when you're at eof() in the current alias. That's explanation enough to me.
>>
>>That's incorrect information from Nick, SQL commands behaves differently from xBase commands.
>
>I've already done my head scratching last night, thanks... had a case where a "blank fields for {condition} in {alias}" invariably blanked only the first two records out of five. And a different alias would be selected. Can't find any active timers. Eventually got it to work by rewriting it into a scan for - blank - endscan loop.

Any indexes on the table? If the replace "moves" a record to the end of the table in the current order, the BLANK will stop since it reaches the end, (IIRC)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform