>Thanks Naomi. That was the last bit of help I needed to get it to run. And the follow-on code also works to deliver the temp cursor back to the page. Just one more thing I need. Do you know how to format the following line so it will display the number as currency? AND my temp cursor is delivering all the deleted rows. SET DELETED is off in the SP but I still get the deleted rows. Do you know how to fix that?
>
>RetVal += "<td>" + oReader("priorpmt").ToString.Trim + "</td>"
>
>
>>Yes,
>>
>>cast(myField as N(10,2) NULL) as MyNewField, cast(myExistingField as C(10) NULL) as myField
>>
>>>Yes, that's what I had before I started trying to troubleshoot this other problem :)
>>>
>>>Which in reference to all I can say is groan, dumb, dumb, dumb, 50 lashes for me. There is of course 2 databases. A real one and a testing one, and of course I was editing one and running the other. Sorry about that. So now that I have that resolved, I have a new problem. CAn you create a cursor via a SELECT that will allow nulls? as in
SET DELETE must be ON to get rid of deleted records.
About formatting - I'm not yet sure - I believe ToString() has overloads allowing formatting or you can probably look at String.Format()
If it's not broken, fix it until it is.
My Blog