<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font size="4"><font face="monospace">On the other hand, if you <b>DO</b>
decide to stick with a subfile ...<br>
<br>
You can import them with Minisoft ODBC. <br>
<br>
(Don't know about other ODBC drivers.)<br>
</font></font><br>
<div class="moz-cite-prefix">On 3/30/23 18:07, <a class="moz-txt-link-abbreviated" href="mailto:o.kappert@qc.aibn.com">o.kappert@qc.aibn.com</a>
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:5947ed59.27522.187348f5883.Webtop.34@qc.aibn.com">It has
been awhile but I'll give it a go....
<br>
<br>
It should not be going to a subfile.
<br>
Create a file eq for
QUIZLIST=FILENAME;Rec=-132,,f,ascii;disc=1000000;save
<br>
Then run the quiz report, should work
<br>
<br>
<br>
Olav
<br>
<br>
<br>
<br>
------ Original Message ------
<br>
From: <a class="moz-txt-link-abbreviated" href="mailto:byrnejb@harte-lyne.ca">byrnejb@harte-lyne.ca</a>
<br>
To: <a class="moz-txt-link-abbreviated" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>
<br>
Sent: Thursday, March 30, 2023 4:06 PM
<br>
Subject: QUIZ and subfiles
<br>
<br>
I am trying to produce a CSV file from a type 642 QUIZ
SUBFILE. The QUIZ
<br>
script compiles ok but when it is run it does not create the
expected output
<br>
file. If I run the script without the SET SUBFILE statement in
it then the
<br>
output that appears on the terminal is what I am trying to save
to a file.
<br>
<br>
If I run the compiled script then all that appears to happen is
that the QUIZ >
<br>
prompt appears.
<br>
<br>
Has anyone any idea what I have tripped over? The problem script
is:
<br>
<br>
SET NOSUBFILE
<br>
<br>
ACCESS *QZART5A1
<br>
<br>
DEFINE QZD-QUOTE CHARACTER SIZE 1 = '*'
<br>
DEFINE QZD-DELIM CHARACTER SIZE 1 = ','
<br>
DEFINE QZD-QDELIMQ CHARACTER SIZE 3 = '*,*'
<br>
<br>
SORT ON QZD-NET
D &
<br>
ON ACCOUNT-NUMBER
<br>
<br>
REPORT
SUMMARY &
<br>
QZD-QUOTE &
<br>
ACCOUNT-NUMBER
&
<br>
QZD-QDELIMQ &
<br>
DESCRIPTION
&
<br>
QZD-QDELIMQ &
<br>
QZD-GROSS
&
<br>
QZD-QDELIMQ &
<br>
QZD-NET
&
<br>
QZD-QDELIMQ &
<br>
QZD-NET-R
&
<br>
QZD-QDELIMQ &
<br>
QZD-COUNT
&
<br>
QZD-QUOTE
<br>
<br>
SET SUBFILE AT ACCOUNT-NUMBER NAME QZART5A2
KEEP &
<br>
NODICTIONARY PORTABLE SIZE 9600
<br>
<br>
SET REPORT LIMIT 500000
<br>
<br>
BUILD QZART5AB
<br>
<br>
<br>
--
<br>
*** e-Mail is NOT a SECURE channel ***
<br>
Do NOT transmit sensitive data via e-Mail
<br>
Unencrypted messages have no legal claim to privacy
<br>
Do NOT open attachments nor follow links sent by e-Mail
<br>
<br>
James B. Byrne <a class="moz-txt-link-freetext" href="mailto:ByrneJB@Harte-Lyne.ca">mailto:ByrneJB@Harte-Lyne.ca</a>
<br>
Harte & Lyne Limited <a class="moz-txt-link-freetext" href="http://www.harte-lyne.ca">http://www.harte-lyne.ca</a>
<br>
9 Brockley Drive vox: +1 905 561 1241
<br>
Hamilton, Ontario fax: +1 905 561 0757
<br>
Canada L8E 3C3
<br>
<br>
--
<br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
<br>
Mailing list: <a class="moz-txt-link-abbreviated" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>
<br>
Subscribe: 'subscribe' in message body to
<a class="moz-txt-link-abbreviated" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a>
<br>
Unsubscribe: 'unsubscribe <password>' in message body to
<a class="moz-txt-link-abbreviated" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a>
<br>
<a class="moz-txt-link-freetext" href="https://lists.sowder.com/mailman/listinfo/powerh-l">https://lists.sowder.com/mailman/listinfo/powerh-l</a>
<br>
This list is closed, thus to post to the list you must be a
subscriber.
<br>
Add 'site:lists.sowder.com powerh-l' to your search terms to
search the list archive at Google.
<br>
<br>
<br>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Tracy Johnson
BT
NNNN</pre>
</body>
</html>