Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INDEX ON failed if SET DELETED OFF in buffering
Message
From
03/01/2001 08:34:14
 
 
To
03/01/2001 08:11:59
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00458829
Message ID:
00458862
Views:
14
Hi!

I never had this before. Something might be wrong with indexes (try to reindex databases and tables). I tested this in my framework where I use this very oftenly with SET DELETED OFF and it works. I use VFP 6 SP3.

Note also that I used non-compound indexes using following variant of the INDEX command:

index on &c___Expr tag (m.tmpTagName) of (m.tmpTagName) additive

This creates separate index file that is easy for maintenance and does not cause extra problems when application crashed.

>Hi,
> I have REM the statement CURSORSETPRO("BUFFERING", 5) in my form, set form.buffermode = 0, and form.datasession = 2 (private).
> It still cause the same error if i SET DELETED OFF. I work fine if I SET DELETED ON my my form.
>
>Any ideas?
>
>Thank you
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Reply
Map
View

Click here to load this message in the networking platform