Create new table from another table values

What version of Pervasive are you using? What is your goal for this process? Rather than create a new table, you might want to consider a VIEW.
To answer the question, you can use the SELECT INTO syntax. For example:
The statement above will create a temporary table called #mytmptbl and insert records that match the restriction (f1 < 100).

The same statement can be made into a VIEW and reused easier:
and then used with:



Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

I am using Pervasive 11.

Since I am having problems converting with Access, the purpose is to create a new table with only part of the table. I can then use this new table, or give it to my helper to create some crystal report when I am too busy.

I just do not want them to connect directly to the master database.

Rather than create a new table, why not figure out why the queries aren't running properly. Creating a new table will only add to the complexity.

The syntax I posted will work in v11 however it will only create a new PSQL table. It won't create an Access table.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

I will check the queries in Crystal report, but It would be nice if the query worked the same against Pervasive and Access.