Record status in quick - resetting

Maeve Hooper mhooper@mhg.co.za
Fri, 10 Sep 2004 10:28:44 +0200


This is a multi-part message in MIME format.

------_=_NextPart_001_01C49710.2F4D0059
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



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_001_01C49710.2F4D0059
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7226.0">
<TITLE>Record status in quick - resetting</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">Hello</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">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.</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Any ideas would be great as I'm =
probably going to need to this fairly often.</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Maeve Hooper</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Database Consultant</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Metropolitan Health Group</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Ph:&nbsp; (021) 480-6871</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Cell: 083 6666 973</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Fax: (021) 480 4932</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C49710.2F4D0059--