Hi, I am running pervasive 2000i. I have problem with this procedure
create procedure del_table (in :wtable char(10))
as begin
delete from :wtable;

I am writing an application that requires a multi-level tree structure.
I'm storing the data in a table of the form
ID  Description  ParentId
For speed, I would like to write a couple of Stored procedures that can run

Note:
All references are to DB's set to Database security model.
I've tried several different methods. Start FE and select login;
neither Master or any other user can login. Response is something like

I have two files
one file with fix records and the second with variable records.
The second file is a memo file from the fisrt.
example : Fichtrav.btr and fichtmem.btr

Has anyone run Pervasive SQL 8.5 on Linux and experienced any issues
regarding failing to handle file locks or corruption of indexes. I am
using Fedora Core 2 (kernel V2.6). To get mkded (the linux btreive
engine) to stay up I had to put this line;

Just wondering if anyone has been able to install the client from V8.5
on a Windows NT 4.0 Terminal Server box? I cannot. I get various weird
and wonderful errors when I try to
eg. one version of the client appears to install but comes up with

I am trying to dl the Btrieve trial 6.15 drivers to see if updating
will help us.  Anyone know where I can dl these drivers on a trial
basis?  I cannot find a link of Pervassive's site.
Thanks

Dear Pervasives!
We use PervasiveSQL V8 under different Environments. Windows, Novell
etc. Now we installed it on Linux (Debian and Suse) and face some
problems.

I have a btrieve file. I need to create a DDF for it. I don't even have
btreive. I would like to pay someone to do this for me.
Its one file but I will probably get 6 more to do if they likes this.

Don't know how to solve this problem and need more brain power.  .....
pausing for sarcastic remarks ....
I have a client who is getting an error 139 across all of their
clients at random times throughout the day.  I learned of this problem

I have a database +/- 2.600.000 records.
I have 5 indexes on this file.
One of them is on ProductID, another is on TransactionDate.
The file has been uploaded in order of ProductID.

Hello again,
I have the DDF files for the Btrieve DB, all I need now is to create
an ODBC data source and then copy the records to help me convert the
database (but not convert all the records, on ones that fall into a

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.

Hey, I know some stuff about them, but not much (I am only in my 2nd
day looking at Btrieve) but I can't find any info on what these files
actually are?
Thanks a lot.

I need to export records from a Btrieve DB convert them into a .txt
file.  This is easy I can use butil, but with that program there are
no options of what records to export, its all or nonw (i think i am
correct with that statement)...