Hi,
I'm trying to store word documents in a sybase table, by loading them from an Access frontend.
I understand that they need to be stored as data type image.
My intention was to pass the document from its converted state where it is stored in a Access frontend table in an field of datatype OLE, to the backend as type image using a stored procedure, but then read that you can't use the datatype 'image' in an SP. If this is the case then how does one go about it?
The nearest thing I have found on the Sybase Support page is tellimg me to look at a script called 'instpix2' which is good example of how one goes about inserting images but I can't find it so am still stumped.....
Any help would be appreciated.
Thanks
I'm trying to store word documents in a sybase table, by loading them from an Access frontend.
I understand that they need to be stored as data type image.
My intention was to pass the document from its converted state where it is stored in a Access frontend table in an field of datatype OLE, to the backend as type image using a stored procedure, but then read that you can't use the datatype 'image' in an SP. If this is the case then how does one go about it?
The nearest thing I have found on the Sybase Support page is tellimg me to look at a script called 'instpix2' which is good example of how one goes about inserting images but I can't find it so am still stumped.....
Any help would be appreciated.
Thanks