Dev: Visual Studio – ASP.NET – C#

using System.Data.Odbc

ConnectionString = “DBQ=<file location>;Driver={Microsoft dBase Driver (*.dbf)};”

This works:
SQL: “SELECT UNIQUE_ID, NAME, USR1128 FROM wfhm.dbf”

This returns an error:
SQL: “DELETE FROM wfhm.dbf WHERE UNIQUE_ID = ‘xxxxxx’”

Error message says: “Too many fields defined”

*I understand that there is a 255 limit on fields, however I’m trying to delete a record, and get the same error.

**I even tried linking tables in access 2000 and then using OleDb; same error

Anyone?


Brian Sausser, MCP
(858) 229-6129

__________________
Brian Sausser, MCP
(858) 229-6129

hi there..

did you try: SQL: “DELETE * FROM wfhm.dbf WHERE UNIQUE_ID = ‘xxxxxx’”??


HTH

Gonzalo

sorry I did'nt see the subsequent post. what is the content of the dbf? your delete from statement should work in a one-to-one scenario.

Another idea.. maybe the delete do something that return more than 255 fields?? I found some things about that after a google search...

can you do the delete if you select the fields by hand???

HTH

Gonzalo

;;;can you do the delete if you select the fields by hand???
no

sql = "DELETE FROM tbleName WHERE ID=" & request.form("id") & ";"


FYI dont forget trailing semi colons

Wind is your friend
Matt

Thanks for all the ideas, however they did not work.

I did try every suggestion on the sql statement itself to no avail, and even tried changing the Command Execute Type:

cmdSel.ExecuteNonQuery();
cmdSel.ExecuteScalar();
cmdSel.ExecuteReader();

each return the same error: too many fields defined.

Any other ideas?
Brian

Brian Sausser, MCP
(858) 229-6129

AFAIK, .dbf files are read-only as of version 2.1 of MDAC when you use the dBase Driver. It wouldn't surprise me if the error you get is due to this driver issue.

Either get a third-party driver or use the FoxPro driver, as explained in this article: http://support.microsoft.com/kb/q238431/

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.