dbTalk Databases Forums  

Re: Field not showin in relational interface.

comp.databases.btrieve comp.databases.btrieve


Discuss Re: Field not showin in relational interface. in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bill Bach
 
Posts: n/a

Default Re: Field not showin in relational interface. - 10-20-2005 , 02:55 PM






The transactional and relational interfaces are only loosely coupled.
If you add something at the Trans level, there is nothing that will
make it show up at the relational level -- you MUST alter the data
dictionary files (DDF's) for the database to add it.

If you use SQL statements to add the field to the DDF's, it should show
up almost immediately. If, however, you use some lo9w-level DDF editor
that goes around the SQL engine to make changes to the DDF's, then
you'll need to get ALL users out of that application (so that the DDF's
close) and then the new field should show up. Of course, restarting
the server or services will also work.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - November, 2005 ***
*** Chicago: Pervasive DataExchange Class - November, 2005 ***

Karl A. Sxrensen wrote:

Quote:
We are running a PSQL 9.1 database, and where adding a field to a
file trough the transactional interface, but it did not show up in
the relational interface. We thought it might have something to do
with caching, but even after 1 hour of waiting, the new field had not
shown up in the relational interface.
We could add data through the transactional interface without
problems, but when trying "Select NewField from File" from through
the relational interface, we got an error saying the field did not
exist.

Any idea ??? (seems like a bug to me)

Regards
Karl


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.