General information
Category:
Coding, syntax & commands
Each element of the array specifies the ascii code for each element of the binary string.
So, in this case, you would need to loop through the array in a manner like this:
var = ""
For x = 1 To Alen(lachunk,1)
var = var + char(lachunk(x))
Next x
Of course in VB, you don't need to go through this additional step..< s >.. And, there may be a way to avoid this step in VFP. However, I am not aware of such a method using OLE-DB. If however, you use SPT (SQL Pass Through, the data comes back in a VFP cursor in the correct manner, obviating the need to do any further post-processing...
>Dear all,
>
>I would like to know if it is possible to return image datatype(binary) as binary data into a VFP variable. I have a sample below but it always return as numeric into an array.
>
>Regards,
>Kueh
>
>Local lcChunk,lnChunkSize, laChunk
>
>
>odata=createobject("adodb.connection")
>
>
>** Good connection
>oData.Open("provider=sqloledb;trusted_connection=yes; ;
>persist security info=False;user id=sa;data source=sqlserver; ;
>initial catalog=northwind;network library=dbmssocn;packet size=32767")
>
>
>oRs=createobject("adodb.recordset")
>
>
>oRs.open("select * from employees ",oData,,,)
>laChunk = Space(0)
>
>
>laChunk = oRs.fields("photos").getchunk(10000)
>
>? lachunk
>disp memo like lachunk
>
>
>
>
>oRs.Close
>oData.Close
>
>
>Release all
>
>Return
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only