![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Platinum Member |
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 10This message has been edited. Last edited by: FP Mod Chuck, | ||
|
Guru |
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. | |||
|
Expert |
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...
| |||||||||||||||||||||||||||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|