Bernie, Check the database settings for TIME SEQUENCE The keyword SEQ (sequence) sets the DATA ENTRY sequence such as HHMMSS while the keyword FOR (format) sets the DISPLAY FORMAT. Have Fun! Very Best Regards, Razzak. At 06:36 PM 7/19/2001 -0400, Bernie Lis wrote: >loading a comma delimited file into a table >where the time column contains: >time is set to hh:mm:ss >value is 7:24:00 loads ok >value is 724 get col tmord must be a valid >time ; sqlcode <> 0, row not loaded >value is 0724 loads ok >set time to hhmm and value is 724 get same error >set time to hmm and get garbage > >What's a poor soul to do when some of the rows >have a 3 digit time?
