Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter sweet CursorAdapter
Message
From
29/11/2002 11:24:11
Emanuele Bonin
EB Soluzioni Informatiche
Tezze S/B, Italy
 
 
To
29/11/2002 10:20:37
Emanuele Bonin
EB Soluzioni Informatiche
Tezze S/B, Italy
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00728167
Message ID:
00728178
Views:
11
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform