Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursorAdapter sweet CursorAdapter
Message
De
29/11/2002 11:43:16
Emanuele Bonin
EB Soluzioni Informatiche
Tezze S/B, Italie
 
 
À
29/11/2002 11:24:11
Emanuele Bonin
EB Soluzioni Informatiche
Tezze S/B, Italie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00728167
Message ID:
00728182
Vues:
13
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform