Record status in quick - resetting

Fri, 10 Sep 2004 12:08:13 +0100

This is a multi-part message in MIME format.

------=_NextPart_000_002A_01C4972E.D9347500
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

how about letting quick do the update in the standard way and then run your
SQL - as an update rather than an insert - in the postupdate procedure.

Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.

  _____  

From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Maeve Hooper
Sent: 10 September 2004 09:29
To: powerh-l@lists.sowder.com
Cc: Paul Howard (E-mail)
Subject: Record status in quick - resetting

Hello 

Does anyone know how to 'fool' quick into thinking that a record has been
written away (put) when it hasn't. I have a program that has a primary file
- various fields are changed on the screen by the user. Then for various
reasons, I use embedded sql to write the record away - NOT Powerhouse. I
don't want the user to get the message "Date changed but not updated". How
do I reset the alteredrecord status ?  I've tried doing a "get" of the
record again which resets the status but the values in the file buffer are 0
- even though the record does exist (I'm in find mode). I want to leave the
file as primary to preserve the screen functionality.

Any ideas would be great as I'm probably going to need to this fairly often.

Maeve Hooper 
Database Consultant 
Metropolitan Health Group 
Ph:  (021) 480-6871 
Cell: 083 6666 973 
Fax: (021) 480 4932 

------=_NextPart_000_002A_01C4972E.D9347500
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Record status in quick - resetting</title>
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
p
	{mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman";}
span.EmailStyle18
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:navy;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>how about letting quick do the =
update in
the standard way and then run your SQL - as an update rather than an =
insert - in
the postupdate procedure.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>Regards, Joe.</span></font><font color=3Dnavy><span
style=3D'color:navy'><o:p></o:p></span></font></p>

This e-mail and all information contained in it is
confidential and may be legally privileged. If you are not the =
intended recipient,
your access to this e-mail is unauthorized. Any use, dissemination,
distribution, publication or copying by you of this e-mail or any of the
information contained within it is prohibited and may be unlawful. Do =
not open
any attachments, delete it immediately from your system and notify the =
sender
promptly by e-mail that you have done so. The content of this e-mail and =
any
attachments sent with it may have been altered without the consent or =
knowledge
of the author.<o:p></o:p>

</div>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>

<hr size=3D3 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>
powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com] =
<b><span
style=3D'font-weight:bold'>On Behalf Of </span></b>Maeve Hooper<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 10 September 2004 =
09:29<br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> Paul Howard =
(E-mail)<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Record status in =
quick -
resetting</span></font><o:p></o:p></p>

</div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D3
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Hello</span></font>
<o:p></o:p></p>

Does
anyone know how to 'fool' quick into thinking that a record has been =
written
away (put) when it hasn't. I have a program that has a primary file - =
various
fields are changed on the screen by the user. Then for various reasons, =
I use
embedded sql to write the record away - NOT Powerhouse. I don't want the =
user
to get the message &quot;Date changed but not updated&quot;. How do I =
reset the
alteredrecord status ?&nbsp; I've tried doing a &quot;get&quot; of the =
record
again which resets the status but the values in the file buffer are 0 - =
even
though the record does exist (I'm in find mode). I want to leave the =
file as
primary to preserve the screen =
functionality.<o:p></o:p>

<p><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Any
ideas would be great as I'm probably going to need to this fairly =
often.</span></font>
<o:p></o:p></p>

<p><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Maeve
Hooper</span></font> <br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Database
Consultant</span></font> <br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Metropolitan
Health Group</span></font> <br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Ph:&nbsp;
(021) 480-6871</span></font> <br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Cell:
083 6666 973</span></font> <br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Fax:
(021) 480 4932</span></font> <o:p></o:p></p>

</div>

</body>

</html>

------=_NextPart_000_002A_01C4972E.D9347500--