SQLExpress - Xb2.NET     ot4xb  
   Announcement      Free XUG Meeting Toronto/Canada (May 25, 2008)       [ More Info ... ]
sqlexpress
Memo Field
Thread Starter: Jimmy Malan Started: 11/3/2006 6:20 AM UTC
Replies: 3
11/3/2006 6:20 AM UTC
Memo Field
Reply Quote

Jimmy Malan

Hi Boris,

I tried to insert a memo field into a table with a field type of Char(2048).
No data was inserted and no error was raised..

I then assigned the memo field to a local variable with the same result.

I then assigned the memo field to a local variable using Alltrim() which
seemed to do the trick.

Is this the correct method to use ? Is there baggage in a memo field that
Sql does not like ?

Thanks

regards,

Jimmy
11/15/2006 12:01 PM UTC
Re: Memo Field
Reply Quote

Boris Borzic

"Jimmy Malan" <fst-procurement@telkomsa.net> wrote in news:sgunzqujq7obsn2.141120061035@ANDREA:

Any news on this problem?

Sorry about the delay. I have send you an email with download instructions for the new build.

Best regards,
Boris Borzic
-- news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools
11/4/2006 4:12 AM UTC
Re: Memo Field
Reply Quote

Boris Borzic

"Jimmy Malan" <fst-procurement@telkomsa.net> wrote in
news:s8n5nyk5zn5bv6o.031120060721@ANDREA:  

I tried to insert a memo field into a table with a field type of
Char(2048). No data was inserted and no error was raised..
I then assigned the memo field to a local variable with the same
result.  
I then assigned the memo field to a local variable using Alltrim()
which seemed to do the trick.
Is this the correct method to use ? Is there baggage in a memo field
that Sql does not like ?

I think the problem is in SQLExpress. It's looking for a varchar of "C" and not "M". Since memo fields retain the "M" type even after being assigned to a memvar, SQLExpress will not process this data properly.

I will send you an updated DLL by email in the next day or so for you to test.

Best regards,
Boris Borzic
-- news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools
11/14/2006 9:35 AM UTC
Re: Memo Field
Reply Quote

Jimmy Malan

Hi Boris

Any news on this problem?

regards

jimmy

"Boris Borzic" <ng-at-sqlexpress-dot-net> wrote in message
news:Xns9870EC12B5988SQLExpress@80.32.233.35...
"Jimmy Malan" <fst-procurement@telkomsa.net> wrote in
news:s8n5nyk5zn5bv6o.031120060721@ANDREA:

I tried to insert a memo field into a table with a field type of
Char(2048). No data was inserted and no error was raised..

I then assigned the memo field to a local variable with the same
result.

I then assigned the memo field to a local variable using Alltrim()
which seemed to do the trick.

Is this the correct method to use ? Is there baggage in a memo field
that Sql does not like ?

I think the problem is in SQLExpress. It's looking for a varchar of "C"
and
not "M". Since memo fields retain the "M" type even after being assigned
to
a memvar, SQLExpress will not process this data properly.

I will send you an updated DLL by email in the next day or so for you to
test.

Best regards,
Boris Borzic
-- news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools