Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Access old .DBF file
Message
De
04/08/2005 15:50:41
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Versions des environnements
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01038514
Message ID:
01038698
Vues:
22
This message has been marked as a message which has helped to the initial question of the thread.
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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform