-----Mensaje original-----
De: Theissen, Annette [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 25 de agosto de 2004 16:50
Para: '[EMAIL PROTECTED]'
Asunto: AW: [development-axapta] Rows in a select
Try this:
InventTrans inventtrans;
;
select count(RecID) from inventtrans where inventtras.transtype==3;
info(int2str(inventTrans.RecID));
The number of records is then stored in inventTrans.RecID.
Also, please consider using enums instead of numbers. Here, you ought to
write InventTransType::Purch instead of 3. It makes the code a lotmore
readable!
Hope this helps!
Annette
Mit freundlichen Grüßen / Best regards
Dipl. Phys. Annette Theißen
System Software Entwicklung
______________________________________________
Viscom AG - Carl-Buderus-Str. 9-15 - D-30455 Hannover
Phone: +49/511/94996-0 - Fax: +49/511/94996-900
mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -
http://www.viscom.de <http://www.viscom.de> < http://www.viscom.de/
<http://www.viscom.de/> >
-----Ursprüngliche Nachricht-----
Von: Alfonso Collados Arroyo [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 25. August 2004 16:40
An: 'Development-Axapta (E-mail)
Betreff: [development-axapta] Rows in a select
Hi,
How can i know in a 'select' the number of registers returned?
For example,
Code:
InventTrans inventtrans;
;
select inventtrans where inventtras.transtype==3;
I need to know the number of registers.
Thanks
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://us.ard.yahoo.com/SIG=129585agv/M=298184.5285298.6392945.3001176/D=gr
<http://us.ard.yahoo.com/SIG=129585agv/M=298184.5285298.6392945.3001176/D=gr
>
oups/S=1705006764:HM/EXP=1093531563/A=2319498/R=0/SIG=11thfntfp/*
http://www. <http://www.>
netflix.com/Default?mqso=60185352&partid=5285298> click here
<
http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=
>
:HM/A=2319498/rand=146572662>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<http://groups.yahoo.com/group/development-axapta/>
< http://groups.yahoo.com/group/development-axapta/
<http://groups.yahoo.com/group/development-axapta/> >
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129q6a0mm/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705006764:HM/EXP=1093532063/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=483999758>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<http://groups.yahoo.com/group/development-axapta/>
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
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.