Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem retriving images
Message
From
28/11/2002 08:34:00
Emanuele Bonin
EB Soluzioni Informatiche
Tezze S/B, Italy
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Problem retriving images
Miscellaneous
Thread ID:
00727924
Message ID:
00727924
Views:
33
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.
Next
Reply
Map
View

Click here to load this message in the networking platform