Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
_TALLY returns a 0 on a INSERT command
Message
 
 
To
22/08/2007 15:42:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Vista
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01249694
Message ID:
01249696
Views:
22
IIRC, There was a bug in VFP8 Intelliseense that would reset _TALLY. Try to type it w/o space so Intellisence wouldn't kick in.
INSERT INTO test VALUES ("test")
?_tally
There was also another bag with SET NOTIFY CURSOR OFF that affected _TALLY as well but it was increasing it.

>I never noticed this, but is now in the way. When I issue a INSERT command the _TALLY reports zero record affected when in fact it should be 1.
>
>
>CREATE CURSOR test (name c(10))
>INSERT INTO test VALUES ("test")
>? _tally
>
>
>Help indicates that it should return 1.
>
>Is my wrong here?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform