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