Problem MEMO fields MS SQL 7

adapt

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Problem MEMO fields MS SQL 7

I can't seem to get more then 254 bytes into a memo field. I am using MS-SQL
server 7
and a statement like:

Q1.ParamaByname('MEMO').AsString := Memo1.Text;
with this statement i'am trying to copy the contents of a memo to the
sqldatabase.

ad...@xs4all.nl

M.H. Avegaar

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem MEMO fields MS SQL 7

Have you tried:

Q1.ParamByName('MEMO').AsMemo := Memo1.Text;

"adapt" <ad...@xs4all.nl> schreef in bericht
news:8o37e0$6qg$1@news1.xs4all.nl...

Quote

> I can't seem to get more then 254 bytes into a memo field. I am using
MS-SQL
> server 7
> and a statement like:

> Q1.ParamaByname('MEMO').AsString := Memo1.Text;
> with this statement i'am trying to copy the contents of a memo to the
> sqldatabase.

> ad...@xs4all.nl

M.H. Avegaar

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem MEMO fields MS SQL 7

Have you tried:

Q1.ParamByName('MEMO').AsMemo := Memo1.Text;

"adapt" <ad...@xs4all.nl> schreef in bericht
news:8o37e0$6qg$1@news1.xs4all.nl...

Quote

> I can't seem to get more then 254 bytes into a memo field. I am using
MS-SQL
> server 7
> and a statement like:

> Q1.ParamaByname('MEMO').AsString := Memo1.Text;
> with this statement i'am trying to copy the contents of a memo to the
> sqldatabase.

> ad...@xs4all.nl

Other Threads

1. Problem Memo fields MS SQL 7

2. Memo fields in Delphi and Text fields in MS SQL 6.5

3. MS SQL Server memo-field and Delphi 2

4. MS SQL Server and Memo fields

5. TQuery, MS SQL, and BLOB memo fields...

6. Memo field in MS-SQL

7. MS SQL 7 and memo fields

8. Memo Fields in MS SQL 6.5

9. MS-SQL Memo / Text Fields

10. MS SQL and memo fields