You are not doing anything incorrectly, the sequence includes only seconds so that is what goes into the column. However, the RTIME function can allow you to assign thousandths of a second, so you could do it with a set of nested variables, parsing out the hours, minutes, seconds and fractions of a second, then combining them into a time value with thousandths.
(RTIME(hr,min,sec,frc)) --- [EMAIL PROTECTED] wrote: > Can someone either duplicate this or tell me what I am doing wrong? > > I have a ENTRY form, single table > In that table, the first column is called CODEX, with a time datatype. > > On before start EEP I have > Set time format HH:MM:SS.SSS > SET VARIABLE VCODEX = .#TIME > In the fom I have a variable CODEX = .VCODEX (where codex is my indexed > unique identifier column) > From the R:prompt, I can see my variable like this 08:22:33.014, showing > all minutes, seconds and thousandths. > When the form row is saved the thousandths only appear as 000. > Is this a bug or am i doing something wrong? > > TIA., Bob C. ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
