Whenever an inventtrans is created/updated etc I want to check that one of
the dimensions is set. This is because I have created an inventory movement
report that assumes the dimension is always set but I dont want to have to
go round every place in the system and put mandatory/checks as this will
take forever, so I am hoping there is on place I can catch this. If the
dimension is blank I would want to give an error and abort the operation the
user was doing.
If I was to put such checking in the validatewrite of the inventtrans I am
not confident as I think it maybe too late as I know there are a lot of
processing that is done before inventtrans is finally updated...
Thanks
James
-----Original Message-----
From: Theissen, Annette [mailto:[EMAIL PROTECTED]
Sent: 25 August 2004 23:50
To: '[EMAIL PROTECTED]'
Subject: 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/>
-----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
oups/S=1705006764:HM/EXP=1093531563/A=2319498/R=0/SIG=11thfntfp/*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=
: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/>
* 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
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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.