Using Paradox Tables in C#

[Bob]

I'll try this again, see if anyone has a response....

Anyone done a DELETE or UPDATE on Paradox tables in C#?
I can read the stuff, but I can't delete records.

I tried using ExecuteNonQuery and it choked. Then I tried
using an Odbc data adapter. It didn't give an error, but it
also didn't change anything.

thanks,
-bob

 

[Chris R. Timmons]

I'll try this again, see if anyone has a response....

Anyone done a DELETE or UPDATE on Paradox tables in C#?
I can read the stuff, but I can't delete records.

I tried using ExecuteNonQuery and it choked. Then I tried
using an Odbc data adapter. It didn't give an error, but it
also didn't change anything.

Bob,

What do you mean when you write ExecuteNonQuery "choked"? Did you
get an error message?

Which ODBC driver are you using (file name, version #, etc.)? If you
are using the Paradox ODBC driver that comes with the MS Jet drivers,
realize that it has some documented limitations (see the help file at
C:\WINDOWS\system32\odbcjet.hlp). See the help file sections "DELETE
Statement Limitations" and "INSERT Statement Limitations".

 

[Bob]

Thanks Chirs. I'll try this Monday and see what I
come up with.

Thanks Again,
-bob