Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

ASP and ORACLE BLOB question

I am getting an error

Error Type:
Microsoft Cursor Engine (0x80004005)
Key column information is insufficient or incorrect. Too many rows were affected by update.

In an ASP page,  on this line it is trying to assign a value to a variable from ORACLE database
and the datatype of column is BLOB.

Its urgent could anyone please reply.

Thanks
0
Preetexpexc
Asked:
Preetexpexc
  • 3
1 Solution
 
ramesh12Commented:
This kind of error usually occurs when you try to update duplicate records.

Finrst find in your table if you have duplicate records
0
 
PreetexpexcAuthor Commented:
Hi Ramesh,
0
 
PreetexpexcAuthor Commented:
Hi Ramesh,
     I already tried that.
     Its just one row.
     like this
     strqry = select one, two from table where fields = ABC (this 'fields ' is Primary Key)
     objrs.open strQry, objConn, adOpenDynamic, adLockPessimistic, adCmdText
     then extract these two values in two variables.(one variable is NUMBER and two variable is   BLOB).ONE Number is incremented by 1 and BLOB is extracted to a variable and nothing else done
then

objRS.UPDATE ----- This is where I get the error

All Help would be appreciated.

Thanks
 
0
 
PreetexpexcAuthor Commented:
OK........ I found the answer all I had to do was select the primary_key of the table in select statement and it works.

Thanks doe everyone's help
0
 
PashaModCommented:
PAQed, with points refunded (100)

PashaMod
Community Support Moderator
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now