Record status in quick - resetting
Ole Hansen, ScanConsult
oh@scanconsult.dk
Fri, 10 Sep 2004 11:38:25 +0200
This is a multi-part message in MIME format.
------=_NextPart_000_0021_01C4972A.AF72E660
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello Paul,
=20
I don't know of a way to 'fool' quick like you want, but I would use
temporaries for all fields on the screen.
=20
Set and display the temporaries in the postfind procedure, and let the =
user
modify fields as required.=20
=20
Update using your embedded sql - taking the values from the temporaries
rather than from the record items.
=20
If there are many fields on the screen, this is of cource impractical, =
but
it will leave the retrieved record status 'unchanged'.
=20
Mange hilsner / With kind regards
=20
Ole Hansen
=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
E-mail: oh@scanconsult.dk Cell Phone: +45 4040 1150
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
ScanConsult IT-Partners ApS Voice : +45 8738 7474
Jegstrupvej 96A Fax : +45 8738 7475
DK-8361 Hasselager Support : support@scanconsult.dk
Denmark Sales : sales@scanconsult.dk
http://www.scanconsult.dk <http://www.scanconsult.dk/>
=3D ParaSuite : A Suite of Air Cargo Handling solutions =3D
=3D ParaSafe : A Suite of IT-Security solutions =3D
=3D Partners : Hewlett-Packard, Cognos, Microsoft and more =3D
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Maeve Hooper
Sent: 10. september 2004 10:29
To: powerh-l@lists.sowder.com
Cc: Paul Howard (E-mail)
Subject: Record status in quick - resetting
Hello=20
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=20
Database Consultant=20
Metropolitan Health Group=20
Ph: (021) 480-6871=20
Cell: 083 6666 973=20
Fax: (021) 480 4932=20
------=_NextPart_000_0021_01C4972A.AF72E660
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D249021909-10092004><FONT face=3DArial color=3D#0000ff =
size=3D2>Hello=20
Paul,</FONT></SPAN></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><SPAN class=3D249021909-10092004><FONT face=3DArial color=3D#0000ff =
size=3D2>I=20
don't know of a way to 'fool' quick like you want, but I would use =
temporaries=20
for all fields on the screen.</FONT></SPAN></DIV>
<DIV><SPAN class=3D249021909-10092004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D249021909-10092004><FONT face=3DArial color=3D#0000ff =
size=3D2>Set=20
and display the temporaries in the postfind procedure, and let the user =
modify=20
fields as required. </FONT></SPAN></DIV>
<DIV><SPAN class=3D249021909-10092004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D249021909-10092004><FONT face=3DArial color=3D#0000ff =
size=3D2>Update=20
using your embedded sql - taking the values from the temporaries rather =
than=20
from the record items.</FONT></SPAN></DIV>
<DIV><SPAN class=3D249021909-10092004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D249021909-10092004><FONT face=3DArial color=3D#0000ff =
size=3D2>If=20
there are many fields on the screen, this is of cource impractical, =
but it=20
will leave the retrieved record status =
'unchanged'.</FONT></SPAN></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2>Mange hilsner / With kind=20
regards</FONT></DIV>
<DIV> </DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2>Ole Hansen</FONT></DIV>
<DIV> </DIV>
<DIV align=3Dleft><FONT face=3DArial=20
size=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>E-mail: <A=20
href=3D"mailto:oh@scanconsult.dk">oh@scanconsult.dk</A> =
=20
Cell Phone: +45 4040=20
1150<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>ScanConsult=20
IT-Partners ApS =20
Voice : +45 8738 7474<BR>Jegstrupvej=20
96A &nbs=
p; =20
Fax : +45 8738 7475<BR>DK-8361=20
Hasselager Support : <A=20
href=3D"mailto:support@scanconsult.dk">support@scanconsult.dk</A><BR>Denm=
ark &nbs=
p; =20
Sales : <A=20
href=3D"mailto:sales@scanconsult.dk">sales@scanconsult.dk</A><BR> &n=
bsp; &nb=
sp; =20
<A=20
href=3D"http://www.scanconsult.dk/">http://www.scanconsult.dk</A> &n=
bsp; &nb=
sp; =20
<BR>=3D ParaSuite : A Suite of Air Cargo Handling=20
solutions =3D<BR>=3D ParaSafe : A Suite of =
IT-Security=20
solutions =
=3D<BR>=3D=20
Partners : Hewlett-Packard, Cognos, Microsoft and more =
=3D<BR></FONT></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>Maeve Hooper<BR><B>Sent:</B> 10. september 2004=20
10:29<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Cc:</B> Paul =
Howard=20
(E-mail)<BR><B>Subject:</B> Record status in quick -=20
resetting<BR><BR></FONT></DIV><!-- Converted from text/rtf format =
--><BR><BR>
<P><FONT face=3DArial size=3D2>Hello</FONT> </P>
<P><FONT face=3DArial size=3D2>Does anyone know how to 'fool' quick =
into thinking=20
that a record has been written away (put) when it hasn't. I have a =
program=20
that has a primary file - various fields are changed on the screen by =
the=20
user. Then for various reasons, I use embedded sql to write the record =
away -=20
NOT Powerhouse. I don't want the user to get the message "Date changed =
but not=20
updated". How do I reset the alteredrecord status ? I've tried =
doing a=20
"get" of the record again which resets the status but the values in =
the file=20
buffer are 0 - even though the record does exist (I'm in find mode). I =
want to=20
leave the file as primary to preserve the screen =
functionality.</FONT></P>
<P><FONT face=3DArial size=3D2>Any ideas would be great as I'm =
probably going to=20
need to this fairly often.</FONT> </P>
<P><FONT face=3DArial size=3D2>Maeve Hooper</FONT> <BR><FONT =
face=3DArial=20
size=3D2>Database Consultant</FONT> <BR><FONT face=3DArial =
size=3D2>Metropolitan=20
Health Group</FONT> <BR><FONT face=3DArial size=3D2>Ph: (021)=20
480-6871</FONT> <BR><FONT face=3DArial size=3D2>Cell: 083 6666 =
973</FONT>=20
<BR><FONT face=3DArial size=3D2>Fax: (021) 480 4932</FONT>=20
</P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0021_01C4972A.AF72E660--