Hi All

I have another problem with AursorAdapter class

I have a Table on Sql Server that have a field called Picture that is an Image Type Field.

I Want to retrieve the content (the content is the series of bytes of a BMP file) of this field through a CursorAdapter and save the content in a file Goofy.BMP.

Now i have initiated my Cursor adapter with this property:

oCursor.CursorSchema = 'Id I, Picture1 M'
oCursor.SelectCmd = 'SELECT Id , Picture1 FROM Table'

when i want to fill the cursor i use this command

oCursor.CursorFill(.T.)

So i have my cursor populated, with a series of bytes on Picture1 MEMO Field.

The problem is that any of this two series of command don't create a godd bmp files:

1)
SET NOCPTRANS TO Picture1
STRTOFILE(Picture1, 'Goofy.bmp')

2)
COPY MEMO Picture1 TO Goofy.bmp AS 0

The real size of bmp file is over 800 Bytes, but created BMPs are 767 Bytes lenght.

If i use a General field to define picture1 i can see the BMP cklicking twice on browser (but i can't save it in a file)

I think that there is a kind of conversion of picture1 from Server To Client, there is a way to retrieve the right bytes on client ??

Thanx in Advance