Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursorAdapter sweet CursorAdapter
Message
De
29/11/2002 11:24:11
Emanuele Bonin
EB Soluzioni Informatiche
Tezze S/B, Italie
 
 
À
29/11/2002 10:20:37
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:
00728178
Vues:
12
News on my problem!

I've tried to substitute the line

REPLACE Picture WITH FILETOSTR(cImageFile)

with

REPLACE Picture WITH LEFT(FILETOSTR(cImageFile), 8000)

and the update don't emit error.

So the maximun limit is 8000 bytes ...

In the BOL of SQL Server where there is specified that for text, ntext and image you can use the UPTDATEXT, WRITETEXT ecc... (more quick because not logged) but there is no limitations about using UPDATE against image fields, so the update should'nt be in error!? or i haven't Understand the BOL ? Someone can help me ?

The Part of BOL that i'm not sure is the following:
----------------------------------------------------------------------
Note The UPDATE statement is logged. If you are replacing or modifying large blocks of text, ntext, or image data, use the WRITETEXT or UPDATETEXT statement instead of the UPDATE statement. The WRITETEXT and UPDATETEXT statements (by default) are not logged.
----------------------------------------------------------------------


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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform