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
Procedure with VarBinary(Max) parameter not working
-
- Posts: 4
- Joined: Fri 27 Mar 2009 01:24