Groups > Borland > Borland Delphi migration > Re: Assign method does not work from TMemo.Lines to NText field




Assign method does not work from TMemo.Lines to NText field

Assign method does not work from TMemo.Lines to NText field
Fri, 17 Aug 2007 10:08:12 -070
I am migrating from D5 Enterprise to D2006 Enterprise.

My application uses SQL server (2005) through a TADOTable.

In Delphi 5, if I use the assign method to copy the lines from a TMemo 
object into a SQL NText field, it works perfectly. An example expression 
would be:

ADOTable.FieldByName('TestField').Assign(Memo.Lines);

Where "TestField" is defined as NText in SQL Server.

In D2006, this assigns absolute jibberish to the NText field.

I have applied all D2006 updates and hot fixes through #13....but the assign 
method still does not work.

Richard Stephens 

Post Reply
Re: Assign method does not work from TMemo.Lines to NText field
Fri, 17 Aug 2007 11:26:17 -070
I found that if I create a TDBMemo field and point it to my TADOTable 
"TestField" NText field, that the following will work:

DBMemo.Lines := Memo.Lines;

However....I believe that I should have been able to continue to use the 
assign method:

ADOTable.FieldByName('TestField').Assign(Memo.Lines);

...as I did before in D5.


Richard

Post Reply
about | contact