Procedure with VarBinary(Max) parameter not working

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
ghn.henrique
Posts: 4
Joined: Fri 27 Mar 2009 01:24

Procedure with VarBinary(Max) parameter not working

Post by ghn.henrique » Wed 22 Apr 2009 18:36

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

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 23 Apr 2009 08:36

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.

Post Reply