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 4th October 2017, 15:47
pralash pralash is offline
Senior Member
 
Join Date: Feb 2017
Posts: 129
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Listing the particular record by mentioned the record number
Baan: Other/Unknown
C/S: None/Unknown

Hi,

I'm new to LN Programming. I want to read a record one by one from the baan table by mentioned the record number like in MySQL "select *from employee limit 2,1" which read the second record only. Similarly can you please let me know that how to read a particular record in the baan table by mentioned the record number.

Thanks and Regards,
Pralash
Reply With Quote
  #2  
Old 4th October 2017, 16:55
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,934
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
LN people probably have something different - but in 4c4 I would never read a specific record like that. But if I new I needed exactly 2 records I could use something like this:
Code:
select tccom010.*
from tccom010
where tccom010.emno >0
as set with 2 rows
selectdo
endselect
Just doing this I know the last set of tccom010 fields will have second record. I never really code something like so this is just for example. I do as set with, but usually to get the last record(or first) for a given set of criteria.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 5th October 2017, 08:42
pralash pralash is offline
Senior Member
 
Join Date: Feb 2017
Posts: 129
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Thanks for your reply....

But I want to read the record one by one from the source table and also need to store it some another table. So can you please tell me how to read the record one by one without mentioned any condition in where clause until the end of record is reached...
Thanks...
Pralash
Reply With Quote
  #4  
Old 6th October 2017, 23:34
rahul ingale rahul ingale is offline
Member
 
Join Date: May 2011
Location: Hyderabad
Posts: 33
rahul ingale is on a distinguished road
Baan: baan infor - DB: sql - OS: windows xp
Hello Pralash,

In Baan Sql,limit and offset function are not there while writing Sql query.
so if you want read record and also offset some record like in query you offset in 1 record.you can do this like below

select tdpur400.orno
from tdpur400
selectdo
|it will loop all record in table
| select other table
select tdpur401.orno,tdpur401.pono
from tdpur401
selectdo
endselect
selecteos
|end of search after looping all record this section will executed.
endselect
use as set with n rows to limit recordset.
offsetting the recordset can be done in selectdo section.but no direct function available.
__________________
IRL
Reply With Quote
  #5  
Old 8th October 2017, 17:46
pralash pralash is offline
Senior Member
 
Join Date: Feb 2017
Posts: 129
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Thanks a lot for your information.... I'll try to the task by using the set with no row option...
Regards,
Pralash
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
using line number (record number) VishalMistry Tools Development 2 27th January 2016 14:45
company_nr MilindV Tools Development 5 12th July 2013 15:49
Retrieve data from tdinv750 Drikus70 Operating Systems & Databases 2 9th September 2009 10:23
bshell received SIGTERM manojsharma Tools Development 11 5th June 2008 10:22
Audit file structure baan_user Tools Development 8 4th May 2007 15:32


All times are GMT +2. The time now is 06:25.


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