Using SQL Create Table with Dbase 7 files

Les Piotrowski

Delphi Developer

Tue, 05 Feb 2002 03:00:00 GMT

Using SQL Create Table with Dbase 7 files

I can Create Table in Access with through the (Delphi 4
C/S)DBexplorer/SQLexplorer just fine.
But the primary key does not want to work with DBase 7 (any suggestions)

create table tablename
(a char (1),b char(2),
primary key (a,b))

Should I use a constraint? Any suggestions with a sample piece of code would
be helpful
Les

Other Threads

1. Urgent problem with creating dBase tables using SQL

2. Delphi 4.0 - Creating DBase Table using Code

3. Delphi 4.0 - trouble creating DBase tables using code

4. SQL Create Table with DBase 7

5. Problem using SQL with dBase tables

6. Deleting a DBase table record in Delphi using SQL

7. BDE/Local SQL against dbase file using Delphi 5

8. using sql commands on dbase files

9. BDE 4.51 and Dbase Tables ; create table

10. Creating tables using SQL