Charlie, The lesson in this is that you should never expect a computed column to retain its original value. Since it is computed each time the row is touched, it is subject to change.
There's no way to reload unloaded data without the value changing. You can unload AS ASCII and, I think, get the value as it is, but if you try to reload that data you'll get "excess data values ignored." If what you're trying to do is record the user who created a row, then use a stored procedure as an after insert trigger to accomplish the task. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Parks Sent: Thursday, March 20, 2008 3:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Setting default for a column to the current user When I load the table with previously unloaded data the computed column becomes what the value currently is instead of what the value was before the unload. Is there a way around this? I would prefer the column's value be the current user upon creation of the row but have custom say when the value should be changed. As well as being able to unload and reload a table and keep the originial value instead of it being changed to the user that is reloading the table. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Minyo II Posted At: Thursday, March 20, 2008 1:11 PM Posted To: RB7-L Conversation: [RBASE-L] - Re: Setting default for a column to the current user Subject: [RBASE-L] - Re: Setting default for a column to the current user At 11:51 AM 3/20/2008, you wrote: >What is the correct syntax to set a column's default to the current user? > >When I try something like this >CREATE TABLE `Test` (`Editor` TEXT (3) DEFAULT '(CVAL('user'))') > >I get this >-ERROR- Default length must be no longer than 60 chars (2791) Charlie, Use a computed column rather than using a computed value as a column default. And, "Editor" is a RESERVED WORD. Try something like: CREATE TABLE `Test1` (`TblEdtr`= (CVAL('USER')) TEXT (50), TextCol TEXT (6)) Do you want the R:BASE user or the network user? For the network user, use (CVAL('NETUSER')). John
