Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 15th October 2015, 08:28
Noor Jahan Noor Jahan is offline
Member
 
Join Date: Dec 2013
Posts: 33
Noor Jahan is on a distinguished road
Baan: baan4 - DB: oracle - OS: windows
Thumbs up how to skip the record in selectdo and continue to next record
Baan: Other/Unknown
C/S: None/Unknown

Hi ,

I want to skip the record in selectdo and proceed to next record depend on some condition in Sql wuer

ex:

select tccom011.field
from tccom001
where ....

selectdo
IF CONDITION NOT SATISTY
SKIP THIS RECORD AND PROCEED TO NEXT RECORD
Selectempty
endselect
Reply With Quote
Sponsored Links
  #2  
Old 15th October 2015, 08:34
sachinbaan's Avatar
sachinbaan sachinbaan is offline
Senior Member
 
Join Date: Oct 2013
Posts: 166
sachinbaan is on a distinguished road
Baan: ERP LN - DB: MS SQL - OS: Microsoft Server
Try this,
Code:
select        tccom011.field
from          tccom011
where       condition
selectdo
        if not <condition> then
                continue
        endif
endselect
__________________
Regards,
Sachin

TO DREAM THE PERSON U WOULD LIKE 2 B, IS 2 WASTE THE PERSON U R.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Very nasty work around for an ugly problem AFS finds and updates WRONG RECORD OmeLuuk AFS/DDC/OLE: Function servers 5 17th August 2015 13:21
Problem with multi-thread processing gget79 Tools Development 5 9th October 2008 17:51
bshell received SIGTERM manojsharma Tools Development 11 5th June 2008 10:22


All times are GMT +2. The time now is 20:12.


©2001-2017 - Baanboard.com - Baanforums.com