I added a new varchar based column to a table. Values for this new column for all new records are populated via my powerbuilder app. the powerbuilder app when saving the datawindow that has this new column calls a stored procedure that processes some data from the table I have modified but not necesaarrily the column I have added to the table. All this works fine, the problem I encounter when I take the values from one of the columns in this table that existed before my changes and copy that data to my new column. As soon as I do that and I try to bring data for this individual in my app the stored procedure that works fine suddenly goes into lala land and hangs. I cannot understand why, I have tried to recompile the procedure, made the new column so there are no null values in it, nothing works. Can someone help please?
asked 10 Jan '12, 08:41