Search   

Sunday, February 05, 2012

Support » Support Forum

Register  Login

 Menu  
 
    

 Welcome!  
 


Welcome to the NDO support forum!

kreis.gif Please register/login at the site if you want to post a thread. We sometimes copy support mails of common interest to the forum. They appear with anonymous sender.
kreis.gif Please post your messages in English language if possible. You can do your posts also in German, we will translate your post and our answer so that all users of the forum can read your posts.
kreis.gif The forum software requires that javascript is enabled.
kreis.gif Please do not insert licence information or licence keys in forum posts.
kreis.gif If you know a good answer to a post of another user, feel free to reply!
kreis.gif The forum is monitored. We reserve the right to remove posts we consider not to be useful for other forum users.

   Print   

      
 NDO Support Forum  
 
SearchForum Home
  NDO-Forum postings in english please, if possible.  Developing with NDO  Column length...
 Column length
 
 6/21/2006 9:52:26 PM
Gerhard
12 posts


Column length
How can I save strings with a length > 255. With ADO we defined Memo as column type. The NDO Field class contains a ColumnLength property. The default value for this property is 0, what does this mean for the real limitation. Is it possible to define with this property strings with a length of e.g. 500 characters? Or is it possible to set the Field.ColumnType to "Memo" ?
 6/22/2006 11:26:42 AM
Mirko
109 posts
5th


Re: Column length

Hi Gerhard,

working with Memo fields is somewhat tricky, because of some ADO.NET "features". Try to set the mapping info for your memo fields like that:

 Memo.gif

Unfortunately, ADO.NET needs a valid Size Property for the Parameter objects, so you have to provide a value, which is large enough for all possible cases. NDO passes the ColumnLength property as Size property to the Parameter objects.

On the other hand, the DDL (Data Definition Language) code for memo fields doesn't allow the definition of a column length. To avoid, that NDO inserts the ColumnLength value into the DDL, set IgnoreLengthInDDL to True.

That should work.

Best Regards:
Mirko

  NDO-Forum postings in english please, if possible.  Developing with NDO  Column length...
  SearchSearch  Forum HomeForum Home