longer than 2 characters:
select forupdate exu_delpoint
where exu_delpoint.extnum like '??*'
shorter than 3 characters:
select forupdate exu_delpoint
where !(exu_delpoint.extnum like '???*')
Gert D'Hollander schrieb:
> not realy an option if you want longer then or shorther then but nice
> workaroud for = or !=
>
>
> /Gert D'Hollander/
> Transaction Management
> *SPE*-*Citypower* nv/ /
> /tel. 09 38 77 681 /
> /fax. 09 38 77 689/
>
> -----Oorspronkelijk bericht-----
> *Van:* Stefan Osterburg [mailto:[EMAIL PROTECTED]
> *Verzonden:* vrijdag 28 januari 2005 8:07
> *Aan:* Axapta-Knowledge-Village@yahoogroups.com
> *Onderwerp:* Re: [Axapta-Knowledge-Village] query question
>
> 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/>.
> >
> >
>
>
>
> 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 --------------------~-->
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/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/
