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

forum.gupta.bugreport (2005-2010)
EWetzel
Germany
Posts: 271
Joined: 07 Mar 2017, 12:08
Location: Germany

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

Post by EWetzel » 16 Oct 2007, 13:56

 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

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

Post by Gambhir » 16 Oct 2007, 19:21

 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
Germany
Posts: 271
Joined: 07 Mar 2017, 12:08
Location: Germany

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

Post by EWetzel » 16 Oct 2007, 21:56

 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?

You do not have the required permissions to view the files attached to this post.

EWetzel
Germany
Posts: 271
Joined: 07 Mar 2017, 12:08
Location: Germany

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

Post by EWetzel » 17 Oct 2007, 10:04

 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

Return to “gupta.bugreport”

Who is online

Users browsing this forum: [Ccbot] and 0 guests