General information
Category:
Coding, syntax & commands
I answered this in your first post..
>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