Board index » delphi » TTable, TQuery, TStoredProc with Blob field on MS SQL Server

TTable, TQuery, TStoredProc with Blob field on MS SQL Server

Hi,

I'm using Builder 5, BDE+SQL Links, and MS SQL Server 7
I have trouble when I try to read a Blob field (which contains a file) using
TQuery or TStoredProc, but it works with TTable.
The issue is that with TQuery or TStoredProc, the blob (wich I copy to a
FileStream), is limited in size (and so truncated) depending of the Blob
Size of my BDE Alias. But with TTable, there's no problem. As far as I work
on SQL Server, I try to get rid of all TTable component (otherwise I get
into other issues).
Is it a bug, or a BDE limit, or something else?
Must I really use ADO?
Is there some solution?
In a word: HELP

--
Sylvain

 

Re:TTable, TQuery, TStoredProc with Blob field on MS SQL Server


Hi again,

As suggested by John Pierce in another thread, I tried to use a TQuery with
RequestLive set to True, but it didn't change anything.

--
Sylvain
sylvain cochepain <s.cochep...@silog.fr> a crit dans le message :
3a377a94$1_1@dnews...

Quote
> Hi,

> I'm using Builder 5, BDE+SQL Links, and MS SQL Server 7
> I have trouble when I try to read a Blob field (which contains a file)
using
> TQuery or TStoredProc, but it works with TTable.
> The issue is that with TQuery or TStoredProc, the blob (wich I copy to a
> FileStream), is limited in size (and so truncated) depending of the Blob
> Size of my BDE Alias. But with TTable, there's no problem. As far as I
work
> on SQL Server, I try to get rid of all TTable component (otherwise I get
> into other issues).
> Is it a bug, or a BDE limit, or something else?
> Must I really use ADO?
> Is there some solution?
> In a word: HELP

> --
> Sylvain

Other Threads