AFAIK you can not create a table with varchar field with older VFPOLEDB driver. You must download and install the lastes OLE DB driver for VFP, because before VFP9 there is no such type of field.
>I have to convert a foxpro app to vb.net and Im having trouble with dbfs and this line in general:
>
>Create Table "test.dbf" (filename v(240) Unique, Date v(50) Null)
>
>
>The test.dbf is not part of a dbc. So far I have converted it to this:
>
>Dim myConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\;Extended Properties=dBASE IV;User ID=;Password=")
>
>Dim myCmd As New System.Data.OleDb.OleDbCommand("CREATE TABLE test.dbf (filename varchar(240) Unique, Date varchar(50) Null)", myConn)
>
>myConn.Open()
>myCmd.ExecuteNonQuery()
>
>
>It gives me the error "Syntax error in field definition". What is the correct syntax? Also, the unique field obviously speeds up scans alot because of the cdx index, but will vb.net automatically create this index? I need to use a table that wont require a driver that does not come with a clean install of win2k, so I figured a dbf would be the fastest.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.