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/
