Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 4th October 2016, 04:50
penahill's Avatar
penahill penahill is offline
Newbie
 
Join Date: Aug 2016
Posts: 2
penahill is on a distinguished road
Baan: 10.2 - DB: Oracle - OS: HP-Unix
Cursors in LN 10.2
Baan: ERP LN 6.1 FP8 (Infor ERP 10.2)
DB: Oracle 8.0.3.x
OS: HP-UX 11.31
C/S: None/Unknown

I am trying to find out if I can use a prepare/cursor logic to query data in LN. I am coming from an Informix background using 4gl and very green in LN

Let me give an example of an Informix 4gl cursor logic I would like to use in LN:

let sql = 'SELECT item, price, on_hand FROM table_a '
' WHERE item = ', s.item, 'AND company = ' compr

PREPARE cp_cursor FROM sql
DECLARE cx_cursor FROM cp_cursor
FOREACH cx_cursor INTO p.item, p.price,p.on_hand
Do logic
END FOREACH

I know the FOREACH loop is the selectdo in LN but I would like to build a sql where clause in a string so I can use the input field(s) values to help in getting to the data quicker and more accurate.

Thanks in advance for your response.

Paul
Reply With Quote
Sponsored Links
  #2  
Old 4th October 2016, 05:52
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,286
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
You can use Dynamic SQL
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
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
Cost Allocation in Infor LN 10.2 PACHernandez Finance, Invoicing and Integration 3 30th June 2015 07:27
BaaN IV sessions - ERP LN 10.2 sessions Bogdan Tools Administration & Installation 1 7th May 2015 19:39
Porting set 8.8a.03 (64 bit) and oracle 10.2 (64bit) davismit Operating Systems & Databases 1 18th November 2013 13:41
db resource file GaryEd Tools Administration & Installation 1 7th June 2013 21:47
sequential dumps of tools table joepte Tools Administration & Installation 13 20th June 2012 23:34


All times are GMT +2. The time now is 05:42.


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