Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter sweet CursorAdapter
Message
From
29/11/2002 11:43:16
Emanuele Bonin
EB Soluzioni Informatiche
Tezze S/B, Italy
 
 
To
29/11/2002 11:24:11
Emanuele Bonin
EB Soluzioni Informatiche
Tezze S/B, Italy
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00728167
Message ID:
00728182
Views:
12
Hi Emanuele ... 8-)

I sovled the problem for MS SQL Server.
Infact reading again the BOL i discovered that using UPDATE to update an Image field, SQL server initialize the image pointer and preserve at least one page of data to store the effective datas.

So i added the lines reported below to my code where i force the use of WRITETEXT command to update image field.

The other solution to store on images field is the use of odbc API more elegant, more general (server independent) ..... but more complicated.

Have a nice week End!

TEXT TO o.UpdateCmd NOSHOW TEXTMERGE
DECLARE @ptrval binary(16)
UPDATE Images
SET Picture=NULL
WHERE Id_Images=?OLDVAL('id_images','images')

SELECT @ptrval = TEXTPTR(picture)
FROM images
WHERE id_images = ?OLDVAL('id_images','images')

WRITETEXT images.picture @ptrval ?images.picture

ENDTEXT
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform