Page 1 of 1

Procedure with VarBinary(Max) parameter not working

Posted: Wed 22 Apr 2009 18:36
by ghn.henrique
Hi there,

I'm trying to use a procedure that simply inserts a new row into a table with a VarBinary(Max) column in it. The procedure has a parameter with the same data type.

I create it, put a TSQLStoredProc into my form, load the procedure's params, load the data using .LoadFromFile(..., ftBlog) (tried with SetBlobData as well) and call ExecProc.

When I check out, the field has "0x0000000" in it.

Then I replaced the procedure for a simple INSERT statement (within a TSQLQuery). It works with no problems.

I'm using the last version of devart, downloaded today (for it has just been bought).

Thanks,
Henrique

Posted: Thu 23 Apr 2009 08:36
by Dimon
Please, try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com, including a script to create and fill table.