Problems saving MemoText (over 255 chars) into ACCESS2000
From: David (learn2love_at_163.com)
Date: 03/12/04
- Next message: asi: "strange insufficient key column information for updating or refreshing"
- Previous message: Emile Cronje: "Re: Using TADODataset with DB2"
- Next in thread: Brian Bushay TeamB: "Re: Problems saving MemoText (over 255 chars) into ACCESS2000"
- Reply: Brian Bushay TeamB: "Re: Problems saving MemoText (over 255 chars) into ACCESS2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 12 Mar 2004 19:01:02 +0800
Hi,
I am facing the problem of saving the memo text into an Access table.
If the text in the memo is less than 255. the saving will work properly.
If the text exceeds 255 chars, the saving will get errors.
The SQL statement is:
with ADOCommand1 do
begin
commandText:='Insert into City values
(:CityFName,:CityAbbrCode,:descriptions)';
CommandType:=cmdText;
Parameters.ParamByName('CityFname').Value:=edtCityFullName.Text;
Parameters.ParamByName('CityAbbrCode').Value:=edtCityAbbrCode.Text;
Parameters.ParamByName('descriptions').Value:=memDescription.Lines.Text;
execute;
end;
**The last field "description" in Table "city" in the ACCESS is a MEMO
field.**
How could I save text into the memo field when text is over 255 chars? Help
me please.
- Next message: asi: "strange insufficient key column information for updating or refreshing"
- Previous message: Emile Cronje: "Re: Using TADODataset with DB2"
- Next in thread: Brian Bushay TeamB: "Re: Problems saving MemoText (over 255 chars) into ACCESS2000"
- Reply: Brian Bushay TeamB: "Re: Problems saving MemoText (over 255 chars) into ACCESS2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
