General information
Category:
Coding, syntax & commands
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
Next
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