Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
_TALLY returns a 0 on a INSERT command
Message
From
22/08/2007 16:26:03
 
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:
01249705
Views:
23
I try your suggestion involving intellisense and it still returns 0. I am going to compare the result in other versions now.

>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?
Greg Reichert
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform