Dear Sema ,
I think it's better you create procedure and put all sql statement on that
procedure , and then you just call the procedure ..
----- Original Message -----
From: "sema_armagan" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, March 08, 2005 10:59 PM
Subject: [development-axapta] direct sql problem again
>
>
>
> Hello,
>
> I am developing a report which should be written by using direct sql
> statements. I recognized a problem about direct sql if anybody helps
> me i will be very pleased. The problem is i could not write while
> loops one within the other.For example;
>
> Connection Con = new Connection();
> Statement Stmt = Con.createStatement();
> ResultSet R,R1;
> sql ='SELECT ACCOUNTNUM,ACCOUNTNAME,ACCOUNTPLTYPE,RECID FROM
> LEDGERTABLE WHERE ACCOUNTNUM <= \'699\'ORDER BY ACCOUNTNUM';
> R=Stmt.executeQuery(sql);
> while (R.next())
> {
>
> acno1=R.getString(1);
> i = R.getInt(3);
> k= R.getString(4);
> if(strlen(acno1)==3)
> {
> if(i==LedgerAccountType::sum)
> {
>
> sql = 'SELECT FROMACCOUNT,TOACCOUNT FROM
> LEDGERTABLEINTERVAL WHERE ACCOUNTTABLEID ='+_tableId+' AND
> ACCOUNTRECID = '+k+'';
> R1 = Stmt.executeQuery(sql);
> while(R1.next())
> {
> print R1.getString(1),' ',R1.getString(2),' ',k;
> pause;
> }
>
> }
> else
> {
> //blaaaa.....
> }
> }acno1
> } ledgertable2
>
> it just takes the first value from the second resultset and then go
> out of the loop.
>
> best wishes...
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
