HP3000-L Archives

October 2017, Week 1

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
KSAMXL questions
From:
"James B. Byrne" <[log in to unmask]>
Reply To:
[log in to unmask]
Date:
Thu, 5 Oct 2017 12:50:33 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (53 lines) 
As reported earlier I am having some difficulty with extracting data
from a KSAMXL file using QTP.  Eventually I gave up trying to fix the
problem in the existing RUN and extracted the problem REQUEST code
into its own script.  However, this has not solved the problem
although it has changed the symptoms.

When I run this request in its own stand-alone QTP RUN:

REQUEST FOUR-NOTES ON CALCULATION ERRORS REPORT

ACCESS AC-NOTES ALIAS AN

DEFINE QPD-N-DTECR CHAR SIZE 8 = ASCII(DATE-CREATED OF AN,8)

DEFINE QPD-N-TMECR CHAR SIZE 6 = ASCII(TIME-CREATED OF AN,6)

SUBFILE QPCSVAN1 NODICTIONARY KEEP PORTABLE NOAPPEND SIZE 35000     &
     INCLUDE                                                        &
             QUOTE,                                                 &
             NOTE-TYPE OF AN,                                       &
             QDELIMQ,                                               &
             NOTE-CHAR-KEY OF AN,                                   &
             QDELIMQ,                                               &
             TEXT OF AN,                                            &
             QDELIMQ,                                               &
             USER-ID OF AN,                                         &
             QDELIMQ,                                               &
             GROUP-ID OF AN,                                        &
             QDELIMQ,                                               &
             QPD-N-DTECR,                                           &
             QDELIMQ,                                               &
             QPD-N-TMECR,                                           &
             QUOTE

I get blank lines in the subfile at records 82, 83, 165, 166, 248,
249, 331, 332, 414, 415, . . .

Any ideas as to why this is happening?

-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:[log in to unmask]
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2