Board index » delphi » Create DBF with ADO and Create Table statement

Create DBF with ADO and Create Table statement

How does one create a DBF table using a "create table" statement via ADO?
Any help is much appreciated.
 

Re:Create DBF with ADO and Create Table statement


1- Put a ADOCONNECTION on your FORM
2- In ConnectionString Definition choose JETOLEDB Provider
3- In the Advanced Properties of Connection String (ALL) double click on
Extended Properties and Put     dBase IV        or dBase 5.0
4- You have to put the directory of your DB in the Connection tab

5- Put a ADOQUERY on your FORM
6- For his SQL Property put for example:

CREATE TABLE MYTABLE (

NAME CHAR(30),

Passwd CHAR(10),

TEL integer,

JOB CHAR(100),

)

7- To create the table you have to call
 ADOQUERY1.EXECSQL;

"J O Holloway" <jhollo...@pinncorp.com> a crit dans le message de news:
3e95c77...@newsgroups.borland.com...

Quote
> How does one create a DBF table using a "create table" statement via ADO?
> Any help is much appreciated.

Other Threads