I have a question about Magic 9 and Pervasive 8. Recently we upgraded our
program from Magic 7 to Magic 9 and also changed the database from Pervasive
7 to Pervasive 8 (We also changed from Novell to Windows2k server).
First we sometimes received a FFME #46, but could not declare ...

I don't find mention of "LIKE" in the the SQL documentation that comes
with Pervasive, but from some of the postings here it looks like maybe
you can use it -- I have 2000i SP3.  What's the definitive answer, and
if you can use it in a query, what do you use for a multiple-character

I am using win2000 server and pervasive SQL 2000i
i created a table using this script
CREATE TABLE GL2001
 (ID                   Identity,

Does anyone knows what's the best datamodelling tools that can do a reverse
engineering on Pervasive Sql databases ?
Regards,
Roland

I wrote an application in Delphi which connect to database to
Pervasive.SQL 8.5 server through ODBC. If my application disconnect from
database - memory resources which are allocated on database server are
free - so everything is ok. But if the other application (which use

I thought you could add multiple supplemental indexes with you butil or the
GUI utility... Does this work or is there any utility that allows adding
multiple supplemental indexes at one time!

I'm working with Pervasive 2000i SP4 and am trying to run the
following query, however I get a syntax error.  What's wrong?  The
nested query ran fine by itself...
Thanks so much.

Hurrah!
I'm not quite sure why is started working as I've not spent much time on
it today.
Suffice to say we can now make ADO DB connections from .Net projects to

After creating a trigger on file "FILENAME", I get the following error when
I try to re-access that file.
ODBC Error: SQLSTATE = S1000, Native error code = 0
Unable to open table: "FILENAME".

I have a pervasive 2000 db.  In this db there is a table.  I have run
into the following situation and would appreciate some help.
For the sake of simplification:
The table has three rows

Could someone please help clarify the purpose of a few Macola tables?
The tables I'm interested in are the IMLSMST and IMLSTRX tables. It
seems to deal with Serial or Lot numbers. Am I correct?
The version of Macola is Progression 7.5.103f - 32 Bit.

Hi List
I have an old dos application running on magic 5.7 with btreave in
behind. Dont ask me specifics - that is all I know so far. I need to get
the data out of this btreve file to feed them into a new windows

Using IDS to connect to server(ver 7). Simple insert-updates ok - only
using transactions. Multiple server accesses (bundled in transactions)
give error 3128. Sometimes ok but severity increases with number of
records accessed/inserted/updated.

I run a very old (1990) package of Btrieve based programs in my dental
practice using Brtieve 5.00. We run it under win 98 in a dos box
Since the year 2000 came, we have had  intermitent problems with the
different modules in the suite failing to hand over to each other but

I'd like to install the Pervasive SQL 2000 ODBC driver onto a W98 client PC,
to enable an app to use the CaptureIT database. However, I don't want to
install the whole stuff, just the ODBC drivers. We're using P.SQL 2000
Workgroup, by the way, on a Windows 2000 server.