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 |