[RBG7-L] - RE: TIME IN THOUSANDTHS

[Oma Cox]

Title: Message

Bob,

 

Hope your holidays have been well!  I checked your issue here and here are my results.

 

First the value in the column is correct if you do a select into a var. or select to display value after it is inserted into the field from the form.

 

I did setup a form I used the insert command to test this issue!

 

Doing an edit on the same column this is were the problems comes in.  There is a issue with the displaying of the value and I've passed this on to RBTI for review.

 

I use time stamp for transactions and events logs but I don't edit that value or display except on reports or selects.  That's why i've not noticed this issue! 

 

Here are the example code and test results:

 

--test.rmd

connect concomp

set var vtime time = null
show var

SET TIME SEQUENCE HHMMSS
SET TIME FORMAT HH:MM:SS

create temporary table test1 (testtime time)

set var vtime = .#time

insert into test1 values(.vtime)

show var

select all from test1

edit all from test1

disconnect

 

Results:

SET TIME SEQUENCE HHMMSS
SET TIME FORMAT HH:MM:SS.S
select command shows
10:04:42.2
edit command shows
10:04:42.42

SET TIME SEQUENCE HHMMSS
SET TIME FORMAT HH:MM:SS.SS
select command shows
10:08:08.25
edit command shows
10:08:08.08

SET TIME SEQUENCE HHMMSS
SET TIME FORMAT HH:MM:SS.SSS
select command shows
10:09:47.062
edit command shows
10:09:47.000

SET TIME SEQUENCE HHMMSSS
SET TIME FORMAT HH:MM:SS.S
select command shows
10:13:01.8
edit command shows
10:13:01.1

SET TIME SEQUENCE HHMMSSSS
SET TIME FORMAT HH:MM:SS.SS
select command shows
10:15:14.40
edit command shows
10:15:14.14

SET TIME SEQUENCE HHMMSSSSS
SET TIME FORMAT HH:MM:SS.SSS
select command shows
10:17:25.828
edit command shows
10:17:25.000

 

Best regards,

Oma Cox

-----Original Message-----
From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, December 31, 2004 6:54 AM
To: RBG7-L Mailing List
Subject: [RBG7-L] - TIME IN THOUSANDTHS

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.