RE: Setting "DEFAULT VALUE" with SQL

Hi Jim, What you are trying to do is not implemented in 4D's SQL engine, I don't even think you can specify a default value for an Integer field with the regular DB4D engine either. Here is the 4D documentation for ALTER TABLE: http://livedoc.4d.com/4Dv15/help/Command/en/page18448.html ^ There

Setting "DEFAULT VALUE" with SQL

!) I checked and the DEFAULT reserved work exists in 4D's SQL (but maybe it is only valid in a Select?). Cheers and thanks Jim Labos - infobase ----- Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/Setting-DEFA