Article ID	2359
Article Title	HOWTO: Get Pervasive Control Center to display newly created tables
Article URL	http://www.dataaccess.com/kbasepublic/KBPrint.asp?ArticleID=2359
KBase Category	Pervasive.SQL
Date Created	02/27/2008
Last Edit Date	02/27/2008

Article Text
QUESTION:
I already have a database in PCC and would like to see there the table I converted using Database Builder.  

The table was created (the new ".int" and ".btr" files were in the data directory of the workspace), the DDF files have been modified, and I was able to edit the tables using DataFlex and through DFBROWSE, but the tables were not displayed in PCC right away.

I created one specific table on Friday, and only on Monday it showed up in the PCC -- and is editable using the PCC. No problem.

Is there something I can do to force PCC to see it immediately?  I tried "refreshing", but that didn't seem to help.  I suppose I could reload the Pervasive Engine on the server, but that seems like a lot of trouble to make the table appear.  

ANSWER:
Apparently PCC will not pick up the change immediately in some situations.

You can try closing and reopening PCC, or creating a table (doing conversion) while PCC is not running to see if that way PCC will read the new information when you open it.

Since refreshing does not work in this case, you may try deleting the database (do NOT delete the tables etc, just remove the database from PCC) and re-creating the database. The DDF files will be read at that point.

Also, as you already pointed out, you may try to restart the services - or even the server (as other users have done) - so the engines get to read the new information stored in the DDFs.

One last thing you can try is to clear the memory cache used by PCC and then start PCC. In a command window, use the following command:
pcc -clean.  

If you want to clean the cache without starting PCC, for example, from your custom install, run the following command:

pcc -application com.pervasive.core.RCPNullApplication -clean -nosplash  




Contributed By:
Marcia Booth
Company: Data Access Worldwide
Web Site: http://www.dataaccess.com


Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2024 Data Access Corporation. All rights reserved.

The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply.