I have a database, containing the usual file, field and index .DDF files,
as well as a load of .BTR tables.

I have Pervasive.SQL 2000i, but when I access the database, the only the
file, field and index tables appear.

Looking in the file.ddf file with Pervasive.SQL 2000i, the tables (.BTR)
are not listed. Looking at it with Notepad, the tables are listed, but
dont show up in Pervasive.SQL 2000i.

How can I get the tables to appear?

I have never heard of files being in the DDF not showing up as part of
the database.  The flip side to that is that just because you can see
them in there with Notepad does not mean that they are still in there.
Internally records are marked as free, not physically overwritten in
the data file so... there may not be but 3 records in the file (even
though the others are still "in the file".  Use Butil -stat on
file.ddf to get a record count.

The other possibility is the "database" that you are looking at does
not in fact point at the DDFs you are looking at.  In the Pervasive
Control Center, PCC, do a right-click on the database and select
properties.  See exactly which Name Database is selected.  Then in PCC
right click on "Configuration" and select "Maintain Named Database".
Select the database name and see what directory it is point to.  If it
is not the correct one you can change it here.

Leonard

On Thu, 29 Jul 2004 06:36:59 -0400, "matttcattt"
<matttcattt@yahoo.co.uk> wrote:

>I have a database, containing the usual file, field and index .DDF files,
>as well as a load of .BTR tables.
>
>I have Pervasive.SQL 2000i, but when I access the database, the only the
>file, field and index tables appear.
>
>Looking in the file.ddf file with Pervasive.SQL 2000i, the tables (.BTR)
>are not listed. Looking at it with Notepad, the tables are listed, but
>dont show up in Pervasive.SQL 2000i.
>
>How can I get the tables to appear?

There are many causes of "Error in assignment" messages:
1) Trying to insert a numeric value into a string field -- you must enclose
strings in single-quotes.
2) Trying to insert a string into a numeric field.
3) Using some combinations of Locale with European numeric formats (, instead
of .).
4) Having string columns exceeding the maximum of 254 characters
And more...  See if any of these relate to your query...
 Goldstar Software Inc.
 Building on Btrieve(R) for the Future(SM)
 Bill Bach
 BillBach@goldstarsoftware.com
 http://www.goldstarsoftware.com
 *** Pervasive.SQL Service & Support Classes ***
 Chicago: August, 2004: See our web site for details!


matttcattt wrote:

> I have found the problem. The tables, unlike the DDFs had full filenames,
> and so Pervasive.SQL 2000i wasn't looking in the database folder for the
> tables. Moving the database to a correctly names folder alows access to
> the files. :D
>
> However, I now get the following error when opeing one of the tables:
> "ODBC Error: SQLSTATE = 22005, Native error code = 0 Error in assignment".
> A Google search doesn't bring up anything useful (not to me at least). Any
> help?

I have found the problem. The tables, unlike the DDFs had full filenames,
and so Pervasive.SQL 2000i wasn't looking in the database folder for the
tables. Moving the database to a correctly names folder alows access to
the files. :D

However, I now get the following error when opeing one of the tables:
"ODBC Error: SQLSTATE = 22005, Native error code = 0 Error in assignment".
A Google search doesn't bring up anything useful (not to me at least). Any
help?

I am not running any query, just trying to open the table and view the data
by double clicking on the table's icon in Pervasive.SQL 2000i.

An import into Access (2000) also fails with the same, "Error in
assignment" message.

"matttcattt" <matttcattt@yahoo.co.uk> wrote in message news:<aea6e548e041c4fd76de58b89a954670@localhost.talkaboutdatabases.com>...
> I am not running any query, just trying to open the table and view the data
> by double clicking on the table's icon in Pervasive.SQL 2000i.
> 
> An import into Access (2000) also fails with the same, "Error in
> assignment" message.

Matt, when you use DDFs you are using the relational interface and
that requires a query to return any data. Opening a table is basically
a "select * from table_name". Also Access uses SQL queries to return
data, so yes, you are doing a query even if you aren't typing it out
yourself.

It seems likely that your DDFs are incomplete and have other problems
as well. Since that is metadata created by the application vendor that
created the application the first place to start is to go back to them
or any group that knows about DDFs for this application and get the
latests and best DDFs. Even then the DDF format may be many years old
and incompete. Fixing or creating DDFs for existing data is a tedious
and often expensive job, but it can be done. The main thing is to
discover how much work it will entail and whether it is worth it to
your business.

John R. Rothgeb
Database Technology Consultant
johnr@rothgeb.net

I realise I am using an SQL query, I meant that I wasn't specifying any
criteria for a query, simply displaying all records.

Then the last item might apply -- you have a string field longer than 254
characters?
 Goldstar Software Inc.
 Building on Btrieve(R) for the Future(SM)
 Bill Bach
 BillBach@goldstarsoftware.com
 http://www.goldstarsoftware.com
 *** Pervasive.SQL Service & Support Classes ***
 Chicago: August, 2004: See our web site for details!


matttcattt wrote:

> I realise I am using an SQL query, I meant that I wasn't specifying any
> criteria for a query, simply displaying all records.

I doubt it, but I cannot check for obvious reasons. :(