Try this on you Test Company!!!!
 
Use your Pervasive Control Panel
 
     To move all items from Blank Location to The Proper Location run the following query
      UPDATE BKICLOC SET BKIC_LOC_CODE = 'The Proper Location' WHERE LENGTH(BKIC_LOC_CODE) = 0  
Or
      To move all items from wrong location to The Proper Location run the following query
      UPDATE BKICLOC SET BKIC_LOC_CODE = 'The Proper Location' WHERE BKIC_LOC_CODE = 'Wrong Location'  
 
These queries will move all items from on location to another
 
Or
 
     To move some items from one location to another location run the following query
      UPDATE BKICLOC SET BKIC_LOC_CODE = 'The Proper Location' WHERE BKIC_LOC_PROD  = 'ABC%'  
 
This query will move all items that start with ABC from on location to another
 
Then  
 
On DBA Run SM-J-C use: Y-Y-N-B.  
 
This utility will "consolidate" UHO with the same location
 
 
 
 
Kelloggs
 
 

One more silly question. I am aware how to create and manipulate test companies in DBA but how do I specify a company in the Pervasive Control Center? There is only the "DEMODATA" and our company database.
 
Thanks.