Board index » delphi » updating Access Memo field with long strings

2006-05-24 12:49:18 AM
delphi259
Hi list, I have a problem for update a Memo field in Access with my app
I had the content recorded in a TMemo, when I make the UPDATE like
this:
dm.query_connection.sql.add('INSERT INTO Connection (Data)
VALUES (:data)');
dm.query_connection.prepare;
with dm.query_connection do
begin
params.parambyname('data').value:=memo1.text;
ExecSQL;
end;
In some cases works great but in others (long lines of text) it gave me
the error:
Error: ODBC Microsoft Access: Invalid precision value
Any idea why is this?
Its there a better way to update this table?
Thanx
Ernesto
 

On 23 May 2006 09:49:18 -0700, ernestocs666 writes:
You need to repost your message on the Borland news server to make
everybody see it and possibly answer your message.
How to post to Delphi newsgroups:
<tinyurl.com/8m5nw>
which links to
<delphi.wikicities.com/wiki/Delphi_Newsgroups>