TD5.1 After Select Long Varchar from SqlBase the Buffer is empty

[EWetzel]

 Posted by:  Enrico Wetzel 

I have a lot of files (jpg,pdf,bmp etc.) saved in DB (SqlBase, Long
Varchar).
Before saved, the content are compressed by SalStrCompress. Now when I read
the content with TD5.1 from DB only the first 3 bytes (> <) are OK. The
buffer length
of the content string is also OK but all other bytes are 0x00. Normal Text
Long Varchars are OK.

I must say there are a lot of Bugs in TD5.1
For me is it not possible to work with TD5.1

Enrico Wetzel

[Gambhir]

 Posted by:  Gambhir 

As a workaround in TD5.1, we need to call
Call SqlSetLongBindDatatype( , BIND_Binary ) before bind
where need to be replaced with the bind column number.

And we need to call SalStrToWideChar() after uncompressing to see the actual
bytes.

HTH
Nagaraju

[EWetzel]

 Posted by:  Enrico Wetzel 

Thank you,

but it doesn't work.

I do what you say, but after I call SalStrToWideChar the Bufferlength of the output is only 26 bytes (sDocW).

What is wrong?

[EWetzel]

 Posted by:  Enrico Wetzel 

I mustn't call SalStrToWideChar and it works.
Now I use the binary data e.g. in SalPicSetString and the Picture is shown.

Thank you

Enrico Wetzel