QUIZ and subfiles

[RUTMJVA]

On the other hand, if you *DO* decide to stick with a subfile ...

You can import them with Minisoft ODBC.

(Don't know about other ODBC drivers.)

On 3/30/23 18:07, o.kappert at qc.aibn.com wrote:
> It has been awhile but I'll give it a go....
>
> It should not be going to a subfile.
> Create a file eq for 
> QUIZLIST=FILENAME;Rec=-132,,f,ascii;disc=1000000;save
> Then run the quiz report, should work
>
>
> Olav
>
>
>
>    ------ Original Message ------
>    From: byrnejb at harte-lyne.ca
>    To: powerh-l at lists.sowder.com
>    Sent: Thursday, March 30, 2023 4:06 PM
>    Subject: QUIZ and subfiles
>
>          I am trying to produce a CSV file from a type 642 QUIZ 
> SUBFILE.  The QUIZ
>  script compiles ok but when it is run it does not create the expected 
> output
>  file.  If I run the script without the SET SUBFILE statement in it 
> then the
>  output that appears on the terminal is what I am trying to save to a 
> file.
>
>  If I run the compiled script then all that appears to happen is that 
> the QUIZ >
>  prompt appears.
>
>  Has anyone any idea what I have tripped over?  The problem script is:
>
>  SET NOSUBFILE
>
>  ACCESS *QZART5A1
>
>  DEFINE QZD-QUOTE CHARACTER SIZE 1 = '*'
>  DEFINE QZD-DELIM CHARACTER SIZE 1 = ','
>  DEFINE QZD-QDELIMQ CHARACTER SIZE 3 = '*,*'
>
>  SORT ON QZD-NET D                                                  &
>       ON ACCOUNT-NUMBER
>
>  REPORT SUMMARY                                                     &
> QZD-QUOTE                                                   &
> ACCOUNT-NUMBER &
> QZD-QDELIMQ                                                 &
> DESCRIPTION &
> QZD-QDELIMQ                                                 &
> QZD-GROSS &
> QZD-QDELIMQ                                                 &
> QZD-NET &
> QZD-QDELIMQ                                                 &
> QZD-NET-R &
> QZD-QDELIMQ                                                 &
> QZD-COUNT &
>         QZD-QUOTE
>
>  SET SUBFILE AT ACCOUNT-NUMBER NAME QZART5A2 KEEP                   &
>      NODICTIONARY PORTABLE SIZE 9600
>
>  SET REPORT LIMIT 500000
>
>  BUILD QZART5AB
>
>
>  --
>  ***          e-Mail is NOT a SECURE channel          ***
>          Do NOT transmit sensitive data via e-Mail
>     Unencrypted messages have no legal claim to privacy
>   Do NOT open attachments nor follow links sent by e-Mail
>
>  James B. Byrne mailto:ByrneJB at Harte-Lyne.ca
>  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
>
>  --
>  = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>  Mailing list: powerh-l at lists.sowder.com
>  Subscribe: 'subscribe' in message body to 
> powerh-l-request at lists.sowder.com
>  Unsubscribe: 'unsubscribe <password>' in message body to 
> powerh-l-request at lists.sowder.com
> https://lists.sowder.com/mailman/listinfo/powerh-l
>  This list is closed, thus to post to the list you must be a subscriber.
>  Add 'site:lists.sowder.com powerh-l' to your search terms to search 
> the list archive at Google.
>
>
>

-- 
Tracy Johnson
BT







NNNN

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20230330/694f38e1/attachment-0001.html>