stuntman2625
asked on
Sybase Update Image Columns
We have an urgent problem that we need to resolve and our Sybase experience is limited.
Table structures are as follows:
Table T1:
C1 numeric(18)
C2 image
C3 int
C4 varchar
Table T2:
C1 numeric(18)
C2 image
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.
Thanks
Table structures are as follows:
Table T1:
C1 numeric(18)
C2 image
C3 int
C4 varchar
Table T2:
C1 numeric(18)
C2 image
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.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Actually, I just found out my problems were as a result of using some Oracle specific syntax. But your post led me down a different path which eventually solved my problem. Thanks!
ASKER