>Im running the following code:
>
>Dim myConn As New System.Data.Odbc.OdbcConnection("Driver={Microsoft dBASE Driver (*.dbf)};Dbq=c:\")
>
>Dim myCmd As New System.Data.Odbc.OdbcCommand("CREATE TABLE test (filename varchar(240) Unique)", myConn)
>
>myConn.Open()
>myCmd.ExecuteNonQuery()
>
>
>And it errors out because it can only index a field up to 100 length. In foxpro 9, unique fields can be indexed up to 240 length. I really need this field to be above 200 length and be indexed. Is there any workaround?
Is there a reason you're not using the VFP9 OLEDB provider?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up