Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Insert Statement in Text Field

0 views
Skip to first unread message

Jose Lopez

unread,
Aug 22, 2000, 3:00:00 AM8/22/00
to
Hello Everybody,

I try to insert more then 100'000 Chars in a Text Field.
With these SQL Statement it don't Works.
Insert Into clsPublicationXML (Object, ID) Values ('xxx',11007)
xxx is a String with more then 100'000 Chars
The Error is:
Server: Msg 403, Level 16, State 1, Line 1
Invalid operator for data type. Operator equals add, type equals text.
Have Enybody an Idea how I can Insert it whitout ADO or DAO.
Directly over SQL Statements.

Many thanks for your help.

Best Regards
Software Engineer
José Lopez


Stefan Gustafsson

unread,
Aug 22, 2000, 3:00:00 AM8/22/00
to
Read about UPDATETEXT in BOL.

I believe that the maximum size of a batch is 64K or something like that so
you will have to split the string in several parts, and use UPDATETEXT to
insert each part separately.

/SG

Jose Lopez <j...@jpc.ch> wrote in message news:#0NryCBDAHA.240@cppssbbsa04...

Jose Lopez

unread,
Aug 22, 2000, 3:00:00 AM8/22/00
to

Hai Stefan Gustafsson,

Thank you for the Idea.
Here how I resolved it.

DECLARE @ptrval binary(16)
DECLARE @sVal varchar(8000)
SELECT @ptrval = TEXTPTR(Object) FROM msObject Where ID =123456789"
Select @sVal = 'PartOfObject'
UPDATETEXT msObject.Object @ptrval 0 0 @sVal

Best Regards
Software Engineer
José Lopez

"Stefan Gustafsson" <s...@meridium.se> wrote in message
news:#1p4xKBDAHA.239@cppssbbsa05...

0 new messages