Ahah - I missed that one Albert - thanks and I hope this does it for you, Bob!
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, December 31, 2004 12:53 PM Subject: [RBG7-L] - Re: TIME IN THOUSANDTHS > 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] >
