Sybase Update Image Columns
Posted on 2012-03-21
We have an urgent problem that we need to resolve and our Sybase experience is limited.
Table structures are as follows:
Sequence of events are as follows:
1. Application A inserts the following record into T1 (1,null,5,'junk')
2. Application B inserts the following record into T2 (1,<an jpeg image>)
3. After step #2 happens, we need a trigger on T2 to fire that will UPDATE T1.C2 with the contents of T2.C2. We have no issues getting this to work with numeric or varchar columns, but we haven't had any luck getting it to work for the image columns.
Any help would be greatly appreciated.