Using Live Reports to update a database field

hi,I'm trying to update a database field by means of a live report...any help would be very much appreciated...thanks:)

Find more posts tagged with

Comments

Message from Bhupinder Singh via eLinkAlthough this can be done by checking the "Allow database modification"check box on the LiveReport edit page, I usually recommend usingSQL-worksheet instead if you are going to modify any database fields.The reason is that when you run the LiveReport, it will always return amessage like "No results found", even if 500 records were updated. Ifyou use SQL-worksheet, it will let you know how many records wereupdated, and, if there is an error in your SQL statement, it should letyou know where the error is.- Bhupinder------------------------------------------------------------------------- Bhupinder Singh, B.Math., B.Ed. Senior Product Specialist, Customer Support Open Text Corporation, Waterloo, Ontario, Canada Customer support e-mail: support@opentext.com Customer Support Telephone: 800-540-7292 ------------------------------------------------------------------------- -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Monday, September 27, 2004 10:08 AMTo: eLink RecipientSubject: Using Live Reports to update a database fieldUsing Live Reports to update a database fieldPosted by Dzinic, Zlatan on 09/27/2004 10:03 AM hi,I'm trying to update a database field by means of a live report...anyhelp would be very much appreciated...thanks:)[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe