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
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 7th March 2017, 01:10
FrenkR FrenkR is offline
Member
 
Join Date: Jul 2009
Posts: 59
FrenkR is on a distinguished road
Baan: 5 - DB: AS400 - OS: Linux
Dynamic SQL accessing row buffer
Baan: Other/Unknown
C/S: None/Unknown

Hi,
is there any way to get a single "pointer" (bound) to whole row data in dynamic SQL for each fetched row in LN fp8?
example:
Code:
long _sqlId
_sqlId = sql.parse("
select tcibd001.item, tcibd001.dsca, tcmcs001.dsca as cuniNama
from tcibd001
left join tcmcs001 on tcmcs001.cuni = tcibd001.cuni 
")
| instead of binding here to each column, I would like to bind to a single "row constructor")
sql.bind(?, ?) | bind to row ?
sql.exec(_sqlId)
while sql.fetch(_sqlId) = 0
  | here, write to row buff to file or to some buffer
endwhile
sql.close(_sqlId)
in LN 10.4, there is a function "ttstpdlljuesql.fetch.records.from.query()" that saves a record as XML. But there is no similar solution for FP8

Last edited by FrenkR : 7th March 2017 at 01:15.
Reply With Quote
Sponsored Links
  #2  
Old 7th March 2017, 13:22
FrenkR FrenkR is offline
Member
 
Join Date: Jul 2009
Posts: 59
FrenkR is on a distinguished road
Baan: 5 - DB: AS400 - OS: Linux
solved using get.var().
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
Out of memory with dynamic sql. walterbb Tools Development 3 8th September 2010 15:08
update table with dynamic sql stenodegio Tools Development 6 19th March 2009 16:58
Strange error while importing tables: Can not create index 9999 eppesuiG Tools Administration & Installation 8 17th March 2008 04:35
(Embedded SQL) and (Dynamic SQL) nopadon Tools Development 2 6th December 2003 06:55
Question about dynamic sql drifter Tools Development 1 17th October 2003 16:05


All times are GMT +2. The time now is 13:10.


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