Record status in quick - resetting
Deskin, Bob
Bob.Deskin@Cognos.COM
Fri, 10 Sep 2004 08:11:59 -0400
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4972F.5F9FDF20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Is it possible that the transaction is not committed at the time you do =
your GET? If it isn't then the GET will not "see" the new row. You may =
be able to use the COMMIT verb but if you need your transaction to =
continue, then I suggest one of the other techniques that have been =
mentioned.
Bob Deskin =20
Senior Product Manager, Application Development Tools=20
Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA=20
bob.deskin@cognos.com (613) 738-1338 ext 7268=20
-----Original Message-----
From: powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Maeve Hooper
Sent: September 10, 2004 4:29 AM
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.=20
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
=20
This message may contain privileged and/or confidential =
information. If you have received this e-mail in error or are not the =
intended recipient, you may not use, copy, disseminate or distribute it; =
do not open any attachments, delete it immediately from your system and =
notify the sender promptly by e-mail that you have done so. Thank you.=20
=20
------_=_NextPart_001_01C4972F.5F9FDF20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Record status in quick - resetting</TITLE>
<META content=3D"MSHTML 5.50.4943.400" name=3DGENERATOR></HEAD><BODY =
><DIV>
<DIV><SPAN class=3D662570912-10092004><FONT face=3DArial color=3D#0000ff =
size=3D2>Is it=20
possible that the transaction is not committed at the time you do your =
GET? If=20
it isn't then the GET will not "see" the new row. You may be able to use =
the=20
COMMIT verb but if you need your transaction to continue, then I suggest =
one of=20
the other techniques that have been mentioned.</FONT></SPAN></DIV>
<DIV><SPAN class=3D662570912-10092004>
<P><FONT face=3DArial size=3D2>Bob=20
Deskin &=
nbsp; =20
</FONT><BR><FONT face=3DArial size=3D2>Senior</FONT> <FONT face=3DArial =
size=3D2>Product=20
Manager</FONT><FONT face=3DArial size=3D2>,</FONT> <FONT face=3DArial=20
size=3D2>Application Development Tools</FONT> <BR><FONT face=3DArial =
size=3D2>Cognos=20
Inc.</FONT><FONT face=3DArial size=3D2></FONT> <FONT face=3DArial =
size=3D2>3755=20
Riverside Drive</FONT><FONT face=3DArial size=3D2>,</FONT> <FONT =
face=3DArial=20
size=3D2>Ottawa ON K1G 4K9 CANADA</FONT> <BR><FONT face=3DArial=20
size=3D2>bob.deskin@cognos.com</FONT><FONT face=3DArial size=3D2></FONT> =
<FONT=20
face=3DArial size=3D2>(613) 738-1338 ext</FONT> <FONT face=3DArial =
size=3D2>7268</FONT>=20
</P></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
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> September 10, 2004 4:29=20
AM<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></DIV>
<DIV> </DIV>
<DIV>
<P> <FONT FACE=3D"Arial" =
SIZE=3D"2">This message may contain privileged and/or confidential =
information. If you have received this e-mail in error or are not =
the intended recipient, you may not use, copy, disseminate or distribute =
it; do not open any attachments, delete it immediately from your system =
and notify the sender promptly by e-mail that you have done so. =
Thank you.</FONT>
</P>
</DIV></BODY></HTML>
------_=_NextPart_001_01C4972F.5F9FDF20--