RE: [Axapta-Knowledge-Village] Re: SQL Query for AXAPTA BACKEND DATABASE

2007-05-21 Thread p.saravanakumar
- 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

[Axapta-Knowledge-Village] Re: SQL Query for AXAPTA BACKEND DATABASE

2007-05-21 Thread Santosh Kumar Sharma
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(""); RS = S