I am uploading a picture from my PC and saving it to a database, using the AddPicture control.
The image is saved in an SQL field defined as varchar(max).
This is the Save command:
SavePhotoToDB.Run(
UploadedImage2.Image,
glCurrentStCode,
txtComment_1.Text
);
Notify("Picture Saved to DB");
Back();
Save SQL looks like this:
CREATE PROCEDURE [dbo].[SP_SS_SavePhotoToDB]
-- Add the parameters for the stored procedure here
@photoImage varchar(MAX),
@photoLinkID varchar(20) = '',
@comment varchar(100) = ''
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
INSERT INTO [dbo].[TBL_SS_PhotoImages]
([PhotoImage]
,[PhotoLinkID]
,[Comment]
,[Timestamp])
VALUES
(@photoImage,
@photoLinkID,
@comment,
GetDate())
SELECT SCOPE_IDENTITY()
END
GO
The actual data looks like this:
appres://blobmanager/cb639b02c97b4b308ac07a81f11cd8ae/1
When I read that back in using a flow & attempt to display it, there is nothing to see.
Why can't I see my picture?
