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 is no reference to the DEFAULT keyword on that page. Regarding the DEFAULT keyword in 4D's SQL engine, it is used here: http://livedoc.4d.com/4Dv15/help/Title/en/page863.html In regards to setting the default value for an integer field, * At the form level you can specify a default value: http://livedoc.4d.com/4Dv15.3/help/Title/en/page984.html#421895 * At the structure level you can set a choice list: http://livedoc.4d.com/4Dv15.4/help/Title/en/page8985.html#106282 * Also at the structure level you can write a trigger: http://livedoc.4d.com/4Dv15.4/help/Title/en/page2840.html The trigger could be something like this: Case of : (Trigger event=On Saving New Record Event) If (Is field value Null([Test_4444_0353]X0101)) [Test_4444_0353]X0101:=-999999 End if End case I hope this helps, -Tim ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
