Record status in quick - resetting
Peter Bateman
ppfb@hotmail.com
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>