Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Private data session updates not showing up in indexes
Message
From
20/06/1999 19:14:11
 
 
To
20/06/1999 16:18:14
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00231826
Message ID:
00231955
Views:
18
>>
>>I was able to do some more research on this after I sent my first letter. It seems to be something along the lines you are stating. I found some of my combos worked - refrencing the exact same maintenance form. So, I made every single property and method the same between one that did work and one that didn't - no effect. Then I changed the Read Only flag on my default data session ( your solution ). Some then worked but others still failed. I then examined the tables directly. Sure enough the data was there just not in the index and I noticed by cycling the Set deleted On/Off I could get the data to appear and disappear. Finaly I packed and or reindexed the files and the data appeared fine. I can't do this in the production environment as it requires exclusive access to the file which by definition I don't have.
>>A this point I am again stuck.
>>
>>Thanks
>>Terry
>
>Ok, I've read through your discussion with Evan.
>
>Have you made all of your files updatable in the default DS? That should help, but perhaps there is something else going on.

YES

>
>Do you think that some of your CDX files are still not being updated?

YES

>
>By including ".not. deleted()" in your tags you are doing the same thing as "SET DELETED ON". Therefore I assume you are running with "SET DELETED OFF". I would think you would not want to do both.

No I am running with set deleted on. This is a hold over from some primary index filters I used. If I didn't include the !deleted() part when I created new records that may have duplicated previously deleted ones the end user got index violation errors they could not understand or deal with. So, I use !deleted() on all candidate and primary indexes.

>
>If you start with a clean file (packed and reindexed) and use your update form, what is the first problem that you can notice?

When I enter a new record it does not show. I open the table with the index set and it is not there in browse but if I turn off the index it is there. Also, if I happen to create a duplicate ( as the first one didn't show ) and then pack or reindex it deletes all the tags from the one that had the duplicate on ( ie if the tag is say County and is candidate, all tags alphabetically above County are removed when I reindex - if there is a duplicate county. I have to recreate all the indexes over. ).

>
>Peter


This is getting irritating.

Terry
It is impossible to make programs idiot proof. Idiots are too cleaver.

MCP( Tcp/Ip )
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform