powerh-l digest, Vol 1 #1046 - 3 msgs
Maeve Hooper
mhooper@mhg.co.za
Mon, 13 Sep 2004 15:23:31 +0200
Thanks to all for the suggestions.
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of
powerh-l-request@lists.sowder.com
Sent: Saturday, September 11, 2004 1:10 PM
To: powerh-l@lists.sowder.com
Subject: powerh-l digest, Vol 1 #1046 - 3 msgs
Send powerh-l mailing list submissions to
powerh-l@lists.sowder.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
powerh-l-request@lists.sowder.com
You can reach the person managing the list at
powerh-l-admin@lists.sowder.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of powerh-l digest..."
Today's Topics:
1. RE:Record status in quick - resetting (Joe Boyle)
2. RE:Record status in quick - resetting (Deskin, Bob)
3. RE:Record status in quick - resetting (Peter Bateman)
--__--__--
Message: 1
From: "Joe Boyle" <joeboyle_adt@hotmail.com>
To: "'Maeve Hooper'" <mhooper@mhg.co.za>, <powerh-l@lists.sowder.com>
Cc: "'Paul Howard \(E-mail\)'" <paul@synergy.co.za>
Subject: RE: Record status in quick - resetting
Date: 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> </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>
<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>This e-mail and all information contained in it is
confidential and may be legally privileged. If you are not the =
intended</span></font><font
color=3Dnavy><span style=3D'color:navy'> </span></font><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>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.</span></font><o:p></o:p></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> </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> </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>
<p><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family: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 "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.</span></font><o:p></o:p></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:
(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--
--__--__--
Message: 2
Subject: RE: Record status in quick - resetting
Date: Fri, 10 Sep 2004 08:11:59 -0400
From: "Deskin, Bob" <Bob.Deskin@Cognos.COM>
To: "Maeve Hooper" <mhooper@mhg.co.za>, <powerh-l@lists.sowder.com>
Cc: "Paul Howard \(E-mail\)" <paul@synergy.co.za>
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--
--__--__--
Message: 3
From: "Peter Bateman" <ppfb@hotmail.com>
To: powerh-l@lists.sowder.com
Cc: paul@synergy.co.za
Subject: RE: Record status in quick - resetting
Date: Fri, 10 Sep 2004 13:44:48 -0300
<html><div style='background-color:'><DIV class=RTE>
<P>Depending on your transaction model and your database you may have to</P>
<P>commit not only the transaction in which you did your non-PowerHouse SQL update but</P>
<P>also Quick's "query" transaction.</P>
<P>This may lead to the lost of the pointer to the next row</P>
<P>and hence a need to restart the find. </P>
<P>Regards,</P>
<P>Peter Bateman<BR><BR></P></DIV>
<DIV></DIV>>From: "Deskin, Bob" <Bob.Deskin@cognos.com>
<DIV></DIV>>To: "Maeve Hooper" <mhooper@mhg.co.za>, <powerh-l@lists.sowder.com>
<DIV></DIV>>CC: "Paul Howard (E-mail)" <paul@synergy.co.za>
<DIV></DIV>>Subject: RE: Record status in quick - resetting
<DIV></DIV>>Date: Fri, 10 Sep 2004 08:11:59 -0400
<DIV></DIV>>
<DIV></DIV>>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.
<DIV></DIV>>Bob Deskin
<DIV></DIV>>Senior Product Manager, Application Development Tools
<DIV></DIV>>Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
<DIV></DIV>>bob.deskin@cognos.com (613) 738-1338 ext 7268
<DIV></DIV>>
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>From: powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Maeve Hooper
<DIV></DIV>>Sent: September 10, 2004 4:29 AM
<DIV></DIV>>To: powerh-l@lists.sowder.com
<DIV></DIV>>Cc: Paul Howard (E-mail)
<DIV></DIV>>Subject: Record status in quick - resetting
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Hello
<DIV></DIV>>
<DIV></DIV>>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.
<DIV></DIV>>
<DIV></DIV>>Any ideas would be great as I'm probably going to need to this fairly often.
<DIV></DIV>>
<DIV></DIV>>Maeve Hooper
<DIV></DIV>>Database Consultant
<DIV></DIV>>Metropolitan Health Group
<DIV></DIV>>Ph: (021) 480-6871
<DIV></DIV>>Cell: 083 6666 973
<DIV></DIV>>Fax: (021) 480 4932
<DIV></DIV>>
<DIV></DIV>> 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.
<DIV></DIV>>
<DIV></DIV></div><br clear=all><hr>Share a single photo or an entire slide show right inside your e-mail with <a href="http://g.msn.com/8HMBENCA/2743??PS=47575">MSN Premium: </a> Join now and get the first two months FREE*</html>
--__--__--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
End of powerh-l Digest