create table dbase IV  
Author Message
Augustin Calin

PostPosted: Visual FoxPro General, create table dbase IV Top


I have to create -- ar runtime -- some dbf in dbase IV format. I am using Visual C# and System.Data.OleDb (I tried also System.Data.Odbc).

My approach is like this:

1/ create oledbconnection with connection string Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\somefolder;Extended Properties=dBASE IV;

2/ create oledbcommand object and setting the commendtext: create table tablename(columnname numeric(13,3)) and perform executenonquery.

The file is created but the column is not exactly as I wanted; instead it's numeric(20,5).

My question is: how to create a numeric data type column exactly the precision and width I specify

Thank you for your time,

Augustin Calin

Visual FoxPro1