Dear Santhoh
Thanks for Your valuable advice, but I'm Not in position to execute this
thru Axapta, because I'm not a technical person, but I know the Sql
query, so I want to take any reports from database directly.
Regards
P Saravanakumar
Co-Its
09894999281
-----Original Message-----
From: Santosh Kumar Sharma [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 19, 2007 1:13 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: SQL Query for AXAPTA BACKEND
DATABASE
Dear Saravanakumar ,
Try using the following in the fetch() method of ur report
Connection Con = new Connection();
Statement SQLStmt = Con.createStatement();
Notes SQLStrl;
ResultSet RS;
ret = element.prompt();
SQLStrl = Strfmt("<Your SQL Statement>");
RS = SQLStmt.executeQuery(SQLStrl);
In RS you have the cursor which has the records of fields that
you have fetched using your sql statement.
May be this should help you.
Regards ,
Santosh Kumar Sharma
--- In Axapta-Knowledge-
<mailto:Axapta-Knowledge-Village%40yahoogroups.com>
[EMAIL PROTECTED], "p.saravanakumar"
<[EMAIL PROTECTED]> wrote:
>
> Hi Friends
>
> Does anybody having a SQL Query for taking reports directly from
Backend
> Database in Axapta? Or where I get it from?
>
>
>
> Regards
>
> P Saravanakumar
> Co-Its
> 09894999281
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
