Well, it doesn't work anyway. I tried the SET TIME HH:MM AP and it gives an "invalid command" error, so why is it listed in the help files, I wonder??? ~Claudine :)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bernie Corrigan Sent: Friday, November 29, 2002 6:12 PM To: [EMAIL PROTECTED] Subject: RE: Time format/Sequence challenge? Claudine - The short answer is no. SEQUENCE is input format. FORMAT is output format. Bernie ---------------------------------------- At 12:13 PM 11/29/2002 -0600, you wrote: >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/ > ================================================ 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/
