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
bye, Emanuele!
In the beginning the Universe was created.
This has made a lot of people very angry and been widely regarded as a bad move.