<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV><SPAN class=561150501-12092005><FONT face=Arial color=#0000ff size=2>Yes.
It works now. All I did was place the NEED 1 as you suggested
Michael.</FONT></SPAN></DIV>
<DIV><SPAN class=561150501-12092005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=561150501-12092005><FONT face=Arial color=#0000ff size=2>Thank
you</FONT></SPAN></DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Fernando Olmos
<BR><B>Sent:</B> Monday, September 12, 2005 10:43 AM<BR><B>To:</B>
powerh-l@lists.sowder.com<BR><B>Cc:</B>
'Michael.Lee@mclsystemsinc.com'<BR><B>Subject:</B> RE: Primary vs Secondary
files<BR><BR></FONT></DIV>
<DIV><SPAN class=682044200-12092005><FONT face=Arial color=#0000ff size=2>Oops.
I did omit the SECONDARY verb by mistake. I did actually have it in the original
code and it would not work.</FONT></SPAN></DIV>
<DIV><SPAN class=682044200-12092005><FONT face=Arial color=#0000ff size=2>I am
trying your suggestion now. stand by.</FONT></SPAN></DIV>
<DIV><SPAN class=682044200-12092005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=682044200-12092005><FONT face=Arial color=#0000ff size=2>Thank
you</FONT></SPAN></DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Michael.Lee@mclsystemsinc.com
[mailto:Michael.Lee@mclsystemsinc.com] <BR><B>Sent:</B> Monday, September 12,
2005 10:23 AM<BR><B>To:</B> Fernando Olmos<BR><B>Subject:</B> Re: Primary vs
Secondary files<BR><BR></FONT></DIV>Hi Fernando,<BR><BR>I see a couple of
issues:<BR>The first is that you haven't declared the 2nd file as 'secondary'.
Since the program wouldn't compile this way I assume it was a problem with your
copying the code to your email.<BR>The second thing is that a secondary will
only get update if it's record status is changed to alteredrecord. That means
that a field from the 'www_users' table must be modified on the screen by the
user or modified by a LET statement in a procedure (one that is not the FIND or
PATH procedure). <BR><BR>My guess is that the SECONDARY file is not being
modified. You can get around this by putting a NEED 1 option on the FILE
statement for the SECONDARY file or doing a LET instead of a FINAL statement in
something like the PREUPDATE procedure.<BR><BR><BR>Regards,<BR><BR><BR>Michael
Lee<BR>MCL Systems Inc.<BR><BR><BR><A class=moz-txt-link-abbreviated
href="mailto:fernando.olmos@hpa.com.au">fernando.olmos@hpa.com.au</A> wrote:<BR>
<BLOCKQUOTE cite=midC5B2133CD2641C4EA593D2143A5FA0A82E8F35@exchange2k
type="cite">
<META content="MS Exchange Server version 6.0.6603.0" name=Generator><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>This sounds crazy, but I thought secondary files
were meant to automatically add/update/delete along with the primary file in
quick.</FONT></P>
<P><FONT face=Arial size=2>I have a simple code...</FONT> </P>
<P><FONT face=Arial size=2>screen tmp</FONT> <BR><FONT face=Arial size=2>file
copy_file in isdb primary</FONT> <BR><FONT face=Arial size=2>select if
copy_type = 'xx'</FONT> <BR><FONT face=Arial size=2>file www_users in
natdb</FONT> <BR><FONT face=Arial size=2>item user_id final user_id of
copy_file</FONT> <BR><FONT face=Arial size=2>item domain final "VIC"</FONT>
<BR><FONT face=Arial size=2>gen</FONT> <BR><FONT face=Arial size=2>go</FONT>
</P>
<P><FONT face=Arial size=2>The primary key of the www_users table is the
user_id and domain field combo. The primary key of the copy_file is user_id
and a column called copy_type which in this case must be 'xx'</FONT></P>
<P><FONT face=Arial size=2>Well the screen builds and runs perfectly, but when
I add a new record to copy_file, there is nothing been added to
www_users.</FONT></P>
<P><FONT face=Arial size=2>I haven't worked with qdesign for a long time and
my faint memory cells, tell me this was once a possibility. I guess I am
missing something here.</FONT></P>
<P><FONT face=Arial size=2>Thanks</FONT> </P>
<P><I><FONT face=Arial color=#0000ff size=4>Fernando Olmos</FONT></I>
<BR><B><FONT face=Arial size=2>M.I.S.</FONT></B> </P>
<P><SPAN lang=en-au><B><FONT face=Arial color=#0000ff
size=2>HPA</FONT></B></SPAN><SPAN lang=en-us><FONT
face=Arial><BR></FONT></SPAN><SPAN lang=en-au><FONT face=Arial color=#000000
size=2>Direct: 03 9217 5411</FONT></SPAN><SPAN
lang=en-us><BR></SPAN><SPAN lang=en-au><FONT face=Arial color=#000000
size=2>Mobile: 0410 382 857</FONT></SPAN><SPAN lang=en-us><FONT
face=Arial><BR></FONT></SPAN><SPAN lang=en-au><FONT face=Arial color=#000000
size=2>Fax: 03 9217 5716</FONT></SPAN><SPAN lang=en-us>
</SPAN></P>
<P><A href="file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au"
moz-do-not-send="true"><SPAN lang=en-au><U><B><FONT face=Arial color=#0000ff
size=2>www.hpa.com.au</FONT></B></U></SPAN></A>
</P><BR></BLOCKQUOTE></BODY></HTML>