Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] INSERT and ReportCaster
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] INSERT and ReportCaster
 Login/Join
 
Platinum Member
posted
I am having an insert statement in my report (SQL Passtru).
When i try to run it from the procedure it works fine and a new row is inserted.when the same procedure is ran from reportCaster i get the message for successful insert.

(FOC1364) ROWS AFFECTED BY PASSTHRU COMMAND : 1/INSERT

But i don't see the row in the table.

webFOCUS 8105M
windows 10

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 176 | Registered: October 25, 2017Reply With QuoteReport This Post
Guru
posted Hide Post
try using MODIFY instead or maybe add a commit.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 411 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
Also, is it still trying to insert into the same DB, is the default connection the same, or have you hard coded the default connection ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6136 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] INSERT and ReportCaster

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.