Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating database and tables in project using sql
Message
From
22/05/1999 12:00:13
 
 
To
22/05/1999 08:50:50
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00221709
Message ID:
00221750
Views:
12
>That seems to be what is happening, is there a way to access the project manager using sql?

1. Not the project manager via Sql. The project manager is in VFP6.0 an object with methods and properties, it'a all open to you.

2. Over SQL you may access directly the table where information regarding all the components (database, forms, prgs, bmps ...) is stored. The pjx file is a normal fox table and the accompanying pjt file is the memo file. So:

USE myproject.pjx
BROWSE

or in SQL

SELECT * FROM MYPROJECT.PJX

Be very carefull because you must now what you are doing, it's an easy way to make your project "kaputt".

3. Better approach:

- create one new project (project manager dialogue)
- create one new database in the project (project manager dialogue)
- you may close the project manager.
- open database myproj
- now all your sql
- close databases
- modify datbase xxxxx - you'll get de database designer, a nice
grafical overview over your database.

Have fun.
Vlad-Georg
Previous
Reply
Map
View

Click here to load this message in the networking platform