Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP8 OleDB Still no Schema?
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00739094
Message ID:
00740719
Views:
24
This message has been marked as a message which has helped to the initial question of the thread.
I didn't realize that you were using older dbfs. Then you will need to manually set your primary key for the update. There is a property called PrimaryKey in the DataTable class. You will need to set this to the DataColumn that contains the unique key. Here is some sample code:
DataColumn[] myColArray = new DataColumn[1];
myColArray[0] = myTable.Columns["CustID"];
myTable.PrimaryKey = myColArray;
>Nope, Thats what I've been trying to stress. This is a foxpro dbf from the DOS days, Not A VFP DBF. The DBF has a CDX for unique collating sequences, but I dont see anyway in donet to specify which one is primary. I need to leave the dbf's alone tell dotnet which TAG in the index is the primary.
>
>Try making a database with only UNIQ indexes and you'll see the issue. You could also "COPY TO tablename TYPE FOX2X" to build it in the older format.
>
>Thanks Again,
>Mike
-----------------------------------------

Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform