BorlandTalk.com

Benedikt Geltenpoth · Guest

Hi,

I'm using a Sybase11.9.2 Enterprise Server with BDE 5.2.0.2 and running into
problems when I try to insert or update a text field in the database. The
text is stored in a String and I'm assigning the content dynaically in a
standard TQuery parameter:

Query.sql.Clear;
Query.sql.Add(' INSERT INTO titles_comments
(title_id,comment_id,title_comment) ');
Query.sql.Add(' VALUES
('+IntToStr(NewTitleId)+','+IntToStr(Self.FItems[Index].CommentId)+',:Commen
tText)');

Query.params.ParamByName('CommentText').asstring:=FItems[Index].CommentText;

That works as long as the length of the String is smaller 256 chars, but I
write garbage if the string is longer.

Question:
Is that a general problem of the BDE?
Is there a workaround for that?

Any help is welcome,

TIA