List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:March 13 2001 9:13pm
Subject:Re: Setting a specific default value on a field
View as plain text  
>>>>> "JSB" == Jamie S Buchanan <jsb@stripped> writes:

JSB> More specifically, I have two DateTime fields (A and B), in my creation
JSB> script I want to set the default value of B to the value of A so that
JSB> when I write a new record to the table the position of B can be left

what's wrong with

 INSERT INTO goo (A,B) VALUES (NOW(),A)



-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/
Thread
Setting a specific default value on a fieldJamie S Buchanan9 Mar
  • Re: Setting a specific default value on a fieldPeter Skipworth9 Mar
  • Re: Setting a specific default value on a fieldGerald L. Clark9 Mar
  • Re: Setting a specific default value on a fieldVivek Khera13 Mar