Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
Need special characters as default value in memo field |
Thu, Jan 28 2010 3:56 PM | Permanent Link |
Michael Eubanks | I am trying to put special characters (CR + LF) as default values for a field, I am using code like this but it is not working:
s := 'Alter Table [My Table] redefine Comments memo default ''Line1: '' + #10 + #13 + ''Line2: '''; Qry.SQL.Text := s; Qry.ExecSQL; Using DBISAM 4.26 b3 Thanks Michael Eubanks |
Thu, Jan 28 2010 4:35 PM | Permanent Link |
Michael Eubanks | It does not seem that you can set a default value on memo fields. Michael Michael Eubanks wrote: I am trying to put special characters (CR + LF) as default values for a field, I am using code like this but it is not working: s := 'Alter Table [My Table] redefine Comments memo default ''Line1: '' + #10 + #13 + ''Line2: '''; Qry.SQL.Text := s; Qry.ExecSQL; Using DBISAM 4.26 b3 Thanks Michael Eubanks |
Fri, Jan 29 2010 10:53 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< It does not seem that you can set a default value on memo fields. >> No, you cannot. You also cannot use expressions with concatenation as default values, only simple constants and certain functions. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |