David, Shouldn't your sequence match your format? Help says: SET TIME HH:MM:SS (time sequence and format) SET TIME SEQUENCE HHMMSS (time sequence) SET TIME FORMAT HH:MM:SS (time format) So, should you SET TIME HH:MM AP ??? ~Claudine :)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of David M. Blocker Sent: Friday, November 29, 2002 4:21 AM To: [EMAIL PROTECTED] Subject: Time format/Sequence challenge? I have found what looks to me like a "challenge" , but before I post to RDCC I want to run it by the list: In BOTH 7.0 and latest 6.5++ patch: Here is a row in a table called RTEHIST: VID is INTEGER DateAssign is DATE RAssignNo is INTEGER TimeAssign is TIME Time settings: FORMAT HH:MM AP SEQUENCE HHMMSS VID DateAssign RAssignNo TimeAssign 31 07/10/02 21 12:18 AM And here are 4 variables defined in a program: vRAssignNo INTEGER = 21 vHDateAssign DATE = 07/10/02 VHVID INTEGER = 31 vHTimeAssign TIME = 12:18 AM The following SELECT in a program or the R> prompt says: "no rows satisfy the WHERE clause": SELECT * FROM RTEHIST WHERE RassignNo = .vRAssignNo AND VID = .vHVID AND DateAssign = .vHDateAssign and TimeAssign = .vHTimeAssign Testing reveals that the problem is the TimeAssign = .vHTimeAssign part of the clause. If I replace the vHTimeAssign with the literal value, I get the same error. If I change the TIME FORMAT to HH:MM:SS, the SELECT works. Earlier rows in the table all had TimeAssign set to noon (12:00 PM) and the program (a cursor loop through the table) correctly found the row. I checked other rows ahead in the table with times NOT set to noon and get the same problem. Am I misunderstanding the way time sequence / format interact, or is this a "challenge:"??? David Blocker ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
