This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Dear BIRT experts,
Does anyone know how the syntax to update fields thru BIRT, like actuate
does?
Best Regards,
Yudi Irianto
I'm not an expert, but I just finished a Maximo BIRT training class. . .
I'd suggest you look at a report that has the code. I assume you mean something like the Asset Cost Rollup report. Open the design of that and look at the code it uses. This was in the OnClose() method of the report object, IIRC.
Travis Herron
--- In MAXIMO@yahoogroups.com, yudi.irianto@... wrote:
>
> Dear BIRT experts,
>
> Does anyone know how the syntax to update fields thru BIRT, like actuate
> does?
>
> Best Regards,
>
> Yudi Irianto
>
>
>
Hope this help
** **
**** executing the update within a DataSet (any of the
open/describe/fetch/close/beforeOpen/beforeClose/onFetch/afterOpen/afterClose
events)****
** **
myTxn = MXReportTxnProvider.create(this.getDataSource().getName());****
myStmt = myTxn.createStatement();****
myStmt.setQuery("update ... set .... = ....");****
myTxn.save();****
** **
** **
**** executing the update outside of a DataSet****
** **
myTxn = MXReportTxnProvider.create("MAXIMODATASOURCE");****
myStmt = myTxn.createStatement();****
myStmt.setQuery("update ... set .... = ....");****
myTxn.save();****
** **
Note: all examples are illustrated with SQL UPDATE statement, but SQL
INSERT and DELETE can be used similarly****
**
On Wed, Mar 21, 2012 at 6:56 PM, <yudi.irianto@ytljt.com> wrote:
> **
>
>
> Dear BIRT experts,
>
> Does anyone know how the syntax to update fields thru BIRT, like actuate
> does?
>
> Best Regards,
>
> Yudi Irianto
>
>
>
>
>
--
Mohamed Skandaji, MBA, PMP
Hi Mohamed,
thank for your suggestion, let me try.
Best Regards,
Yudi Irianto
Mohamed Skandaji <mohska@gmail.com>
Sent by: MAXIMO@yahoogroups.com
23-03-2012 02:07
Please respond to
MAXIMO@yahoogroups.com
To
MAXIMO@yahoogroups.com
cc
Subject
Re: [MAXIMO List] updating fields thru birt
Hope this help
** **
**** executing the update within a DataSet (any of the
open/describe/fetch/close/beforeOpen/beforeClose/onFetch/afterOpen/afterClose
events)****
** **
myTxn = MXReportTxnProvider.create(this.getDataSource().getName());****
myStmt = myTxn.createStatement();****
myStmt.setQuery("update ... set .... = ....");****
myTxn.save();****
** **
** **
**** executing the update outside of a DataSet****
** **
myTxn = MXReportTxnProvider.create("MAXIMODATASOURCE");****
myStmt = myTxn.createStatement();****
myStmt.setQuery("update ... set .... = ....");****
myTxn.save();****
** **
Note: all examples are illustrated with SQL UPDATE statement, but SQL
INSERT and DELETE can be used similarly****
**
On Wed, Mar 21, 2012 at 6:56 PM, <yudi.irianto@ytljt.com> wrote:
> **
>
>
> Dear BIRT experts,
>
> Does anyone know how the syntax to update fields thru BIRT, like actuate
> does?
>
> Best Regards,
>
> Yudi Irianto
>
>
>
>
>
--
Mohamed Skandaji, MBA, PMP
------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join : MAXIMO-subscribe@yahoogroups.com
Leave : MAXIMO-unsubscribe@yahoogroups.com
Cry : MAXIMO-owner@yahoogroups.com
Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links