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

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

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