As you already figured it out, the problem was unseen trailing spaces in a key field. I am showing your solution here for the benefit of others.

You fixed it using:
"Select brand_cd, RTRIM(prod_code), prod_desc, comments from DataTable"

Mark.




------------
Frank Kwong at 8/5/00 7:26:54 AM

Use Orcale all the time (8.0.5). No such problem. ASP-db is a pass through. If SQL command fails, it'll be mostly a databse set up problem like security, data type etc. Anyway. post code using scott/tiger/EMP and break it for me so I can fix it.
Also, see whether you can get the asp-DB-designer so you do not need to type any code. It is very easy to debug...

Frank





------------
Doug at 8/3/00 12:07:47 PM

I have a problem with asp-db. Sometimes the update will work, but most of the time it doesnot.
I am running an NT 4.0 Server, IIS4 and connecting to an Oracle 8.0.5 database .
The add will work. I have been through the checklist of things Major Micro has sent me.
Has anybody had this problem?
Does anybody develop in interdev, and use Oracle for the database?
Any help would be great.