LINKING TABLES
Brett Greiner (Kinetix)
Brett@Kinetix.co.nz
Wed, 17 Nov 2004 10:45:52 +1300
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4CC25.A5138956
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
We use PH on AIX machine, had this happen to me.
=20
Check the item names of the subfile have not changed their name.
=20
Brett.
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Kristina Carlton
Sent: Wednesday, 17 November 2004 10:34 a.m.
To: 'powerh-l@lists.sowder.com'
Subject: LINKING TABLES
=09
=09
Hi List,=20
I am using OpenVMS v7.3-2 and Quiz V7.10.G4.=20
A while back I had trouble linking tables and got some help from
this list. Everything has been working great, but today I ran into a
problem again. My attempt is to access a subfile, then link it to a
dictionary file via one field, which is not indexed.
This is my access statement:
ACC *DKF1:[DW]DWDTL ALIAS DWDTL LINK DOCUMENT_NUM OF DWDTL TO
DOCUMENT_NUM OF DTL
And the resulting error message:
*E* Item(s) DOCUMENT_NUM not defined as an index of DTL.
Can someone point out what I am doing wrong?
=20
Thanks,
Kristina Carlton
Senior Programmer/Analyst
The JI Companies
512.427.2459
kristina.carlton@jicompanies.com
=20
------_=_NextPart_001_01C4CC25.A5138956
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word"><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 6.00.2800.1476" name=3DGENERATOR>
<META content=3D"Microsoft Word 9" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml@01C4CBF1.BE74D0A0" rel=3DFile-List><!--[if gte =
mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:DrawingGridHorizontalSpacing>2.15 =
pt</w:DrawingGridHorizontalSpacing>
<w:DrawingGridVerticalSpacing>1.45 pt</w:DrawingGridVerticalSpacing>
=
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>
</w:WordDocument>
</xml><![endif]-->
<STYLE>@font-face {
font-family: Century Gothic;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; =
mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; }
P.MsoNormal {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: =
widow-orphan; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: "Courier New"
}
LI.MsoNormal {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: =
widow-orphan; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: "Courier New"
}
DIV.MsoNormal {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: =
widow-orphan; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: "Courier New"
}
P.MsoAutoSig {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: =
"Courier New"
}
LI.MsoAutoSig {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: =
"Courier New"
}
DIV.MsoAutoSig {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Century Gothic"; =
mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: =
"Courier New"
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
"Times New Roman"; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto
}
SPAN.EmailStyle15 {
COLOR: #333399; mso-bidi-font-family: Arial; mso-style-type: =
personal-compose; mso-ansi-font-size: 9.0pt; mso-ascii-font-family: =
"Century Gothic"; mso-hansi-font-family: "Century Gothic"
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US style=3D"tab-interval: .5in">
<DIV><SPAN class=3D375444421-16112004><FONT face=3DArial color=3D#0000ff =
size=3D2>We use=20
PH on AIX machine, had this happen to me.</FONT></SPAN></DIV>
<DIV><SPAN class=3D375444421-16112004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D375444421-16112004><FONT face=3DArial color=3D#0000ff =
size=3D2>Check=20
the item names of the subfile have not changed their=20
name.</FONT></SPAN></DIV>
<DIV><SPAN class=3D375444421-16112004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D375444421-16112004><FONT face=3DArial color=3D#0000ff =
size=3D2>Brett.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com] <B>On=20
Behalf Of </B>Kristina Carlton<BR><B>Sent:</B> Wednesday, 17 November =
2004=20
10:34 a.m.<BR><B>To:</B> =
'powerh-l@lists.sowder.com'<BR><B>Subject:</B>=20
LINKING TABLES<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT face=3D"Century Gothic" =
color=3Dblue=20
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 10.0pt">Hi=20
List,</SPAN></FONT><FONT face=3D"Century Gothic" color=3Dblue =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 12.0pt">=20
<o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT face=3D"Century Gothic" =
color=3Dblue=20
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 10.0pt">I=20
am using OpenVMS v7.3-2 and Quiz V7.10.G4.</SPAN></FONT><FONT=20
face=3D"Century Gothic" color=3Dblue size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 12.0pt">=20
<o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT face=3D"Century Gothic" =
color=3Dblue=20
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 12.0pt">A=20
while back I had trouble linking tables and got some help from this =
list.=20
Everything has been working great, but today I ran into a problem =
again. My=20
attempt is to access a subfile, then link it to a dictionary file via =
one=20
field, which is not indexed.<o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT face=3D"Century Gothic" =
color=3Dblue=20
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 12.0pt">This=20
is my access statement:<o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT face=3D"Century Gothic" =
color=3D#333399=20
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: #333399; FONT-FAMILY: 'Century =
Gothic'; mso-bidi-font-size: 12.0pt">ACC=20
*DKF1:[DW]DWDTL ALIAS DWDTL LINK DOCUMENT_NUM OF DWDTL <SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>TO DOCUMENT_NUM OF=20
DTL</SPAN></FONT><FONT face=3D"Century Gothic" color=3D#333399 =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: #333399; FONT-FAMILY: 'Century =
Gothic'; mso-bidi-font-size: 12.0pt; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT face=3D"Century Gothic" =
color=3Dblue=20
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 12.0pt">And=20
the resulting error message:<o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT face=3D"Century Gothic" =
color=3D#333399=20
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: #333399; FONT-FAMILY: 'Century =
Gothic'; mso-bidi-font-size: 12.0pt">*E*=20
Item(s) DOCUMENT_NUM not defined as an index of =
DTL.</SPAN></FONT><FONT=20
face=3D"Century Gothic" color=3D#333399 size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: #333399; FONT-FAMILY: 'Century =
Gothic'; mso-bidi-font-size: 12.0pt; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3Dblue size=3D1><SPAN style=3D"FONT-SIZE: 9pt; COLOR: =
blue"><SPAN=20
style=3D"mso-bidi-font-size: 12.0pt">Can someone point out what I am =
doing=20
wrong?<o:p></o:p></SPAN></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3Dblue size=3D1><SPAN style=3D"FONT-SIZE: 9pt; COLOR: =
blue"><![if =
!supportEmptyParas]><![endif]> </SPAN><o:p></o:p></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT face=3D"Century =
Gothic"=20
color=3Dblue size=3D1><SPAN style=3D"FONT-SIZE: 9pt; COLOR: =
blue"><SPAN=20
style=3D"mso-bidi-font-size: =
12.0pt">Thanks,<o:p></o:p></SPAN></SPAN></FONT></SPAN></P>
<P class=3DMsoAutoSig><!--[if supportFields]><font color=3Dblue><span=20
style=3D'color:blue'><span =
style=3D'mso-element:field-begin'></span><span=20
style=3D"mso-spacerun: yes"> </span>AUTOTEXTLIST \s "E-mail=20
Signature" <span =
style=3D'mso-element:field-separator'></span></span></font><![endif]--><F=
ONT=20
color=3Dblue><SPAN style=3D"COLOR: blue">Kristina=20
Carlton<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoAutoSig><FONT face=3D"Century Gothic" color=3Dblue =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue"><SPAN=20
style=3D"mso-bidi-font-size: 12.0pt">Senior=20
Programmer/Analyst<o:p></o:p></SPAN></SPAN></FONT></P>
<P class=3DMsoAutoSig><FONT face=3D"Century Gothic" color=3Dblue =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue"><SPAN=20
style=3D"mso-bidi-font-size: 12.0pt">The JI=20
Companies<o:p></o:p></SPAN></SPAN></FONT></P>
<P class=3DMsoAutoSig><FONT face=3D"Century Gothic" color=3Dblue =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue"><SPAN=20
style=3D"mso-bidi-font-size: =
12.0pt">512.427.2459<o:p></o:p></SPAN></SPAN></FONT></P>
<P class=3DMsoAutoSig><FONT face=3D"Century Gothic" color=3Dblue =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue"><SPAN=20
style=3D"mso-bidi-font-size: =
12.0pt">kristina.carlton@jicompanies.com<o:p></o:p></SPAN></SPAN></FONT><=
/P>
<P class=3DMsoNormal><!--[if supportFields]><font color=3Dblue><span=20
style=3D'color:blue'><span =
style=3D'mso-element:field-end'></span></span></font><![endif]--><FONT=20
color=3D#333399><SPAN style=3D"COLOR: #333399"><![if =
!supportEmptyParas]><![endif]> </SPAN></FONT><FONT=20
color=3D#333399><SPAN=20
style=3D"COLOR: #333399; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML=
>
=00
------_=_NextPart_001_01C4CC25.A5138956--