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 12:58:00
 
 
To
19/06/1999 22:13:08
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00231826
Message ID:
00231911
Views:
13
>>I have a system running that uses data stored in a Misc_Table table. The user is presented with choices from various combo boxes loaded with data mainintained in this table. I use various index tags depending on the combo of interest - County, Intake Reason, ... I have developed a "RightClick" method that allows me to maintain the table on the fly from within other form. The right click calls a maintenance form and passes the appropriate information ie Add, Edit, General and what index .... The maintenance form is called using a PRIVATE data session ( I would like to keep it this way to preserve my sanity tracking who's on what ).
>>
>>This workes fine except I just noticed that when I add new records to the table they are not showing up in the indexes. I don't understand.
>>
>>Thanks in advance for any advice you can give
>>
>>Terry
>
>How are you updating the tables? Do you use TABLEUPDATE? Do you issue a FLUSH after? Is there any write cache on the server? If you are running Netware, are you using the latest drivers?


I use tableupdate. No flush. I am on an NT 4 SP3 server.

Below is my response to Peter. It enters the data but does not update the CDX.

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
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