Subject: | |
From: | |
Reply To: | |
Date: | Tue, 30 Mar 2004 12:04:43 +0200 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Hi
Could someone explain this to me. I must be missing something.
I am accessing a table where there is some missing dates in a character
field (HISTORY-DT). I wrote a simple check to see if the first character
was blank, yet the report found nothing. I know there are definitely
records in the table that correspond to the select I used. How can the
following not be working:
> access history
> define d-test char*1 = history-dt[1:1]
> choose rec-loc "VANDAM"
> REP REC-LOC HISTORY-DT D-TEST
> GO
2004/03/30 Virgin Express PAGE
1
Rec History D-TEST
Loc Dt
VANDAM 01
VANDAM 02
> SEL IF D-TEST EQ " "
> GO
Records selected: 0
> SEL IF D-TEST EQ ""
> GO
Records selected: 0
>
HISTORY TYPE SCALE SCALE DEC PICTURE
* REC-LOC CHAR X(8)
ARC-NUMBER CHAR X(10)
BOOKING-AGENT CHAR X(6)
RECEIVED CHAR X(16)
HISTORY-CODE CHAR X(2)
HISTORY-TEXT CHAR X(64)
HISTORY-DT CHAR X(14)
D-TEST CHAR X(1)
==================================
This message contains confidential information and is intended solely for
the use of the individual or entity to whom it is addressed. If you are not
the named addressee you should not disseminate, distribute or copy this
email. Please inform the sender immediately if you have received this e-mail
by mistake and delete this email from your system. Email transmission cannot
be guaranteed to be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or be incomplete. The
sender therefore does not accept liability for any errors or omissions in
the contents of this message, which arise as a result of email transmission.
If verification is required please request a hard copy version. No contracts
may be concluded on behalf of Virgin Express SA/NV by means of email
communication. Finally, the recipient should check this e-mail and any
attachments for the presence of viruses. The company accepts no liability
for any damage caused by any virus transmitted by this email.
==================================
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|