example: statement will be select fieldlist from sometableorview wherecondition
modify the statement as follows: select count(*) from sometableorview wherecondition
run this statement -> you'll get 1 reocrd containing one column containig the number of records
now run the normal statement (if there are no changes in the meanwhile, the number of records
are the on which you obtained using the count(*) statement
============================
regards / mfg / mvh / Kve�ja
michael
p.s. half of 12 is 7
__ __ ___ ___
\ / | |
\/ | | __________________ cut off here
/\ | |
/ \ | |
-- -- --- ---
-----Urspr�ngliche Nachricht-----
Von: hoffmanc2003 [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 25. Januar 2004 09:45
An: [EMAIL PROTECTED]
Betreff: [development-axapta] howto count rows in a OCIConnect ResultSet
How can I count the number of rows returned in a OCIConnection
ResultSet without having to move the cusor (ResultSet.next) through
the data.
Is their a ResultSet.count() function.
Can someone please provide X++ code example.
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: http://docs.yahoo.com/info/terms/
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.
