Hello.
As you may have read from a previous post, I'm having a problem with data being cut off at 32000 bytes using the following code.
SELECTBLOB pic
INTO :lbPicBlob
FROM etc...
BLOB lbPicBlob only contains the first 32000 bytes. This is not a code issue, as it works with Sybase, not is it a SQL Server issue as it works with SQL Server, while ODBC is the interface. It is only an issue with SQL Server when ADO.NET is the interface.
Is there a way to read in data in chunks in Powerbuilder. I know it can be done with files, but is it possible to read in data from a table in PB? Something other than SELECTBLOB?
As you may have read from a previous post, I'm having a problem with data being cut off at 32000 bytes using the following code.
SELECTBLOB pic
INTO :lbPicBlob
FROM etc...
BLOB lbPicBlob only contains the first 32000 bytes. This is not a code issue, as it works with Sybase, not is it a SQL Server issue as it works with SQL Server, while ODBC is the interface. It is only an issue with SQL Server when ADO.NET is the interface.
Is there a way to read in data in chunks in Powerbuilder. I know it can be done with files, but is it possible to read in data from a table in PB? Something other than SELECTBLOB?