Update read only column

Dev Shed Forums Sponsor:

Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!

March 24th, 2008, 10:09 AM

rhogan

Registered User

Join Date: May 2007

Posts: 3

Time spent in forums: 39 m 59 sec
Reputation Power: 0

Update read only column

Hello all,
I'm trying to convert an existing Firebird database web site to .net 2.0. I have install FirebirdClient 2.0.1.0 and can read the Firebird database just fine. However, when I try and update the database with the existing stored procedures I'm getting this error:
FirebirdSql.Data.FirebirdClient.FbException: attempted update of read-only column ---> FirebirdSql.Data.Common.IscException: Exception of type 'FirebirdSql.Data.Common.IscException' was thrown.

Can anyone tell me why this could be happening?

Thanks in advance.
Bob

March 24th, 2008, 10:37 AM

pabloj

Modding: Oracle MsSQL Firebird

Dev Shed God 6th Plane (7500 - 7999 posts)

Join Date: Jun 2001

Location: Outside US

Posts: 7,711

Time spent in forums: 2 Months 2 Weeks 6 Days 4 h 53 m 59 sec
Reputation Power: 259

Start reading here

__________________
My blog about OpenSource Databases
PDF tutorials about OSS databases, DBMonster ...
Please contribute to Open Source Development, fill bug reports!!!
Developer Shed eSupport
Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK)
An introduction to database normalization
Natural or Surrogate key
Custom ordering for your results
Correlated and uncorrelated subqueries
Don't turn your outer joins into inner joins

March 24th, 2008, 12:42 PM

rhogan

Registered User

Join Date: May 2007

Posts: 3

Time spent in forums: 39 m 59 sec
Reputation Power: 0

Quote:

Originally Posted by pabloj

Start reading here

Thank you for replying quickly. The stored procedure is a simple one, no calculations and no triggers. The procedure is below:

Code:

BEGIN
ID=0;
EMAILADDRESS = DOLOWER(:EMAILADDRESS);
IF (EXISTS (SELECT SE.EMAILADDRESS,SC.WEBPASSWORD FROM STAKEHOLDEREMAIL SE, stakeholdercontact SC
    WHERE SE.STAKEHOLDERID = :STAKEHOLDERID AND SC.contactid = SE.contactid AND SC.stakeholderid = :STAKEHOLDERID
    AND SE.EMAILADDRESS=:EMAILADDRESS AND SC.WEBPASSWORD = :OLDPASSWORD)) THEN
         BEGIN
               IF ((:CONTACTID = 0) OR (CONTACTID IS NULL)) THEN
               BEGIN
                    FOR SELECT SE.contactid FROM STAKEHOLDEREMAIL SE, stakeholdercontact SC WHERE SE.STAKEHOLDERID = :STAKEHOLDERID AND SC.contactid = SE.contactid AND SC.stakeholderid = :STAKEHOLDERID  AND SE.EMAILADDRESS=:EMAILADDRESS AND SC.WEBPASSWORD = :OLDPASSWORD INTO :CONTACTID do
                       VAR_DUMMY=0;
                    ID=2;
               END
               update STAKEHOLDERCONTACT SET WEBPASSWORD = :WEBPASSWORD, 
                                             CHANGEDBY = 'WEB' WHERE STAKEHOLDERID = :STAKEHOLDERID AND CONTACTID = :CONTACTID;
          
               ID=1;
         END
ELSE
ID=0;    /* Bad User Name*/
SUSPEND;
END

March 24th, 2008, 12:49 PM