Odd Timestamp default problem - the default works when my insert statement is short, a
longer one however does not work.
In Case 1 the timestamp column named "recordcreated" works fine...
In Case 2 it does not .... why? The only difference is the number of columns specified
in the insert statement.
Question 1: Is this a known bug or am I doing something erroneous?
Question 2: If it is a bug - is there a workaround? I guess I could specify the column
and use timestamp) in my insert statement.
This works....
Case 1:
Insert into Customers (cust_name) values ("Jerry")
//
Select cust_name, recordcreated from customers
// I get the following
Jerry, 2004-05-27 21:11:24.48200
Case 2:
Insert into Customers (Cust_no, cust_Name, cust_address1, cust_address2,
cust_address3,
cust_state_prov,cust_zip_code,cust_contact,cust_tel_no,cust_fax_no,cust_territory,cust_tel_ext,source,sortkey1,sortkey2,contact_search_key,recordcreated)
values ( '105','Kelleys','','','','','','','','','','','','','','Jerry' ||' ' || ''
|| ' ' || '',timestamp)
//
Select cust_name, recordcreated from customers
// I get the following --- The recordcreated field is just empty it doesn't show a ?
in Sql Studio
Jerry,
---------------------------------
Post your free ad now! Yahoo! Canada Personals
