Icon View Incident Report

Serious Serious
Reported By: Vladan Antanasijevic
Reported On: 2/19/2008
For: Version 1.08 Build 1
# 2555 BLOB Procedure Parameters Not Working When Used As Further Parameters to Statements

My code below doesn't work.

In case = 1 I do insert and that works fine,
in case=3 it should do update. Now, all fields updates correctly except blob field with name "Slika".

I'm using
ParamByName('P_Slika').LoadFromStream(FileStream,ftBlob);

CREATE PROCEDURE Artikli_K (IN "P_PodKat" INTEGER,
IN "P_Naziv" VARCHAR(50) COLLATE ANSI,
IN "P_Slika" BLOB, IN "P_SlTip" VARCHAR(5) COLLATE ANSI,
IN "S_ID" INTEGER )
BEGIN
  DECLARE CustCursor CURSOR FOR Stmt;
  PREPARE Stmt FROM ''UPDATE Items SET PodKat=?,Naziv=?,Slika=?,SlTip=? WHERE ID=?''; 
  OPEN CustCursor;
  EXECUTE Stmt USING P_PodKat,P_Naziv,P_Slika,P_SlTip,S_ID;
  CLOSE CustCursor;
END



Resolution Resolution
Fixed Problem on 2/20/2208 in version 1.09 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image