Jean,
A note. Fox2x tables do not know anything about .null. values. If you'd say execute a command like:
insert into myTable (f1) values ('somevalue')
and your table has more than 1 field it would error. VFPOLEDB supports 'set null off' command. Execute that early in your code. ie:
OleDbCommand cmd = cn.CreateCommand();
cmd.CommandText = "set null off"; // set deleted is also supported
cmd.ExecuteNonQuery();
Cetin
>Yes ! I did found that message #
1032287 afther I posted this thread.
>Thak you!
>
>>>I am looking for a white paper thawt Cathi wrote 2 years ago about VFPOLEDB.
>>>
>>>And Yes it Fox2x files.
>>>
>>>>>I need to access old .DBF file from ASP.NET to display many reports.
>>>>>
>>>>>What is the best way to do this?
>>>>>Table must be open in share.
>>>>
>>>>Jean,
>>>>VFPOLEDB works with old dbf files too (I think you meant fox2x files).
>>>>Cetin
>>
>>I have no idea where you might find it. For a sample check Message #
1032287>>You might either use a dbc if one exists or simply specify the fullpath to the folder where your dbf(s) is (include a backslash as the last char in path).
>>Cetin