try the following:
select forupdate exu_delpoint
where !(exu_delpoint.extnum like '???????'
Gert D'Hollander schrieb:
>
>
>
>
> Hi,
>
> I have a problem with a x++ query
>
> I want to do somthing like
>
> select forupdate exu_delpoint where strlen(exu_delpoint.extnum) != 7
>
> I get the error dureing compilation that it is an invalid use of the
> where clause
>
> does anybody know how to solve this
>
> tnx
>
> /Gert D'Hollander/
> Transaction Management
> *SPE*-*Citypower* nv/ /
> /tel. 09 38 77 681 /
> /fax. 09 38 77 689/
>
> -----Oorspronkelijk bericht-----
> *Van:* Harry Deshpande [mailto:[EMAIL PROTECTED]
> *Verzonden:* donderdag 27 januari 2005 21:05
> *Aan:* Axapta-Knowledge-Village@yahoogroups.com
> *Onderwerp:* RE: [Axapta-Knowledge-Village] Influence of static and
> dynamic master plan on capacity reservations
>
> Hi
>
>
>
> I am not sure if this is relevant to your question but...
>
> I had tried this some time back I think in V3SP1 and realised that
> *Only dynamic* plan is considered while checking the reserved
> capacity while scheduling production orders.
>
> I had logged this with MS and believe it or not .. I was told that
> this is an undocumented feature and not a bug. (However, it was very
> obvious from the code that this is a bug). They also came up with a
> justification for this so I just gave up and modified standard Axapta.
>
> I think you will have to log this call with Microsoft, I am not sure
> if this is happening with V3SP3 (not implemented a manufacturing
> site for the last one year)
>
>
>
> Regards
>
>
>
> harry
>
>
>
>
>
> **
>
>
> Harry Deshpande
> Senior Consultant
> CGNZ Middle Market Solutions
> Website: www.cgnz.com/middlemarketsolutions
> <http://www.cgnz.com/middlemarketsolutions>
> Ph +64 29 289 9031
> Fax +64 9 358 1018
>
> CGNZ Limited and its predecessor organisations (Cap Gemini Ernst &
> Young, and Ernst & Young Consulting) have a proud track record of
> market leadership and excellent service delivery in all areas of
> systems delivery both for New Zealand clients and in supporting
> regional and global projects. CGNZ is a licensed affiliate of Cap
> Gemini S.A. (one of the world's leading management consulting and IT
> services companies), wholly owned by NZ employee-shareholders, with
> over 150 IT professionals in our Auckland and Wellington offices.
> Middle Market Solutions specialises in the implementation of
> business solutions for small corporate and middle market companies.
> The core activity of our team is the implementation and support of
> Enterprise Resource Planning (ERP), Customer Relationship Management
> (CRM), E-Business solutions and related technologies from Microsoft
> Business Solutions. Find out more about what we do at
> http://www.cgnz.com/middlemarketsolutions
>
> CGNZ DISCLAIMER: This email and any attachments are confidential and
> intended exclusively for the person to whom the email is addressed.
> If you are not the intended recipient, do not read, copy, disclose
> or use the contents in any way. Please notify us immediately by
> return email and destroy the email and attachments. CGNZ does not
> accept any liability for any changes made to this email or
> attachments after sending by CGNZ. You must scan this email and
> attachments for viruses. The opinions expressed are not necessarily
> those of CGNZ.
> CGNZ accepts no liability for any loss, damage or consequence,
> whether caused by our own negligence or not, resulting directly or
> indirectly from the use of this email and attachments.
>
> ------------------------------------------------------------------------
>
> *From:* baumgartner_helbling [mailto:[EMAIL PROTECTED]
> *Sent:* Friday, 28 January 2005 2:14 a.m.
> *To:* Axapta-Knowledge-Village@yahoogroups.com
> *Subject:* [Axapta-Knowledge-Village] Influence of static and
> dynamic master plan on capacity reservations
>
>
>
>
> Hello all
>
> Can anybody help me with the following problem:
>
> I have a production order in the status scheduled (operation
> schedule). And i have for the same item a planned production order.
> When looking at the capacity reservation of a certain ressource i can
> see for the dynamic plan both - the production order and the planned
> production order. But for the static plan i only see the planned
> production order - also if i execute the static plan. In fact i never
> see in the static plan any production orders.
>
> This makes absolute no sense for me, because the static plan should
> contain the whole situation while the dynamic plan should show the
> changes.
>
> I'm really wondering if someone could give me a hint.
>
> Kind regards
> Michael
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
>
> Sharing the knowledge on Axapta.
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/Axapta-Knowledge-Village/
>
> * 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/>.
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> 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/
