topic Re: How to display last record from table in jasper in Talend Studio

How to display last record from table in jasper

_AnonymousUser — Sat, 16 Nov 2024 12:51:29 GMT

I run a procedure , output of that procedure is stored in one table . I want to print the last record from that table....
Is this possible , i tired tMSSqllastinserted and tlogrow , i getting only Null values . am using 3.2.1 version ....
Any suggestions ?
Thanks
Vikram

Re: How to display last record from table in jasper

Anonymous — Fri, 17 Jun 2011 15:26:03 GMT

Hi
Where do you execute the procedure? tMssqlRow? Can you upload a screenshot of job?
Best regards
Shong

Re: How to display last record from table in jasper

Anonymous — Mon, 20 Jun 2011 07:28:51 GMT

UPDINS is the procedure which i call , i load the output of the procedure in another table ....
I want display the message of the procedure thru Jasper ..

Re: How to display last record from table in jasper

Anonymous — Tue, 21 Jun 2011 10:34:45 GMT

Hi
tMSSqllastinserted can't get last inserted id from the reproduce, you should use the tMssqlInput to query the last records after you call the reproduce. For example:
tMssqlConnection
|
onsubjobok
|
tMssqlsp
|
tMssqlnput--main--tLogRow
|
tMssqlClose
Best regards
Shong