SQL Related Articles: Setting columns as Read only 2004-03-19 -- Mike.gould Newsgroups: softvelocity.clarion.templates > %Key has the option %KeyAuto as an indicator that the key is > autoincrementing. > > Would it be possible to add a checkbox field to indicate that the Autoinc is > happening on the server, but does not happen on the client - ie so that ABC > does not try assign a value to that autoinc field. > This will be helpful for template developers for other languages. At this > time, I am able to bypass the problem by adding a option value IsAutoInc(1) > in the options field, but that means the programmer must remember to add it > in. If you go into the field that makes up your autoincremented number and go to the external name on the second page and put in whatever you column name with the readonly switch it will do the same thing for example if my autoincremented column is called sysid then I would put in the external name sysid | READONLY HTH's Michael Gould Printed May 7, 2024, 12:34 pm This article has been viewed/printed 35110 times. Google search has resulted in 16 hits on this article since January 25, 2004. |