This is running on a DB2 database…
I have a controller that saves a model, calls a stored procedure that updates columns in the row that just got saved and then I do a refresh to update the model with the updated data. Yii gives me an error:
CDbCommand failed to execute the SQL statement: Conversion error on variable or parameter *N. SQLCODE=-302. The SQL statement executed was: SELECT * FROM WTCWSTOOL.TXP010 t WHERE t.TXHROWID=’’‘78’’’ FETCH FIRST 1 ROWS ONLY
I think it has something to do with the rowid being enclosed in quotes because it is defined as a 15,0 numeric column in the database. Any idea how to tell Yii to use the rowid as numeric instead of character?