it, but will be lot slower than use the where clause because you
first have to query the hole table and then discriminate the records
in the If statement, instead of using where you just query the
records that fulfill the condition.
Regards.
Gonzalo.
--- In [email protected], axapta developer
<[EMAIL PROTECTED]> wrote:
> hi Dadan,
>
> Perhaps you could try working around it:
>
> while select * from MyLedgerJournalTrans
> {
> if(substr(MyLedgerJournalTrans.Txt,1,3) == '123')
> do something;
>
> }
>
>
> dadan_kasep_2 <[EMAIL PROTECTED]> wrote:
> I have problem with substring in query like :
>
> while select MyLedgerJournalTrans
> where substr(MyLedgerJournalTrans.Txt,1,3) == '123'
>
> Does anyone have any suggestions to solve this?
>
> thank's
> Regards
>
> Dadan s
>
>
>
>
>
>
>
> ---------------------------------
> 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.
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> [Non-text portions of this message have been removed]
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.
