Help - Need to Update DBase IV File/Table

  • Thread starter Thread starter Joey
  • Start date Start date
J

Joey

Hello,

I have been trying for the last hour or so to figure out a way to
update a DBase IV table. I have done this in the past with no problem.
However, this time the table has no primary key and no index. It only
has ten rows. The problem here is...how do I access each row, since
there is no unique identifier per row. I have tried loading the whole
table into a dataset...but that doesn't work because I can't get the
UpdateCommand and associated parameter(s) to work properly. I have
tried the Microsoft DBase driver and also the Jet (w/extended
properties) driver...No luck.

Does anyone have any information on how to get this done? It has to be
possible! I am using C#.
 
¤ Hello,
¤
¤ I have been trying for the last hour or so to figure out a way to
¤ update a DBase IV table. I have done this in the past with no problem.
¤ However, this time the table has no primary key and no index. It only
¤ has ten rows. The problem here is...how do I access each row, since
¤ there is no unique identifier per row. I have tried loading the whole
¤ table into a dataset...but that doesn't work because I can't get the
¤ UpdateCommand and associated parameter(s) to work properly. I have
¤ tried the Microsoft DBase driver and also the Jet (w/extended
¤ properties) driver...No luck.
¤
¤ Does anyone have any information on how to get this done? It has to be
¤ possible! I am using C#.

You may want to check the following MS KB article:

http://support.microsoft.com/kb/230125/EN-US/

I can't recall whether a unique index is required but that may be another issue.

You may be able to use the Visual FoxPro OLEDB provider as well:

http://msdn.microsoft.com/library/d...ccessingvisualfoxprodatainvisualstudionet.asp
http://www.microsoft.com/downloads/...58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top