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 21st August 2017, 21:38
jojovalenton jojovalenton is offline
Senior Member
 
Join Date: Aug 2007
Posts: 185
jojovalenton is on a distinguished road
Baan: InforLN FP7 - DB: SQL Server 2008 R2 - OS: Window Server 2008 R2
how to sort fields in the form (non-index)
Baan: ERP LN 6.1 FP7 (Infor ERP 10.1)
C/S: Both

hi,

i just want to inquire if possible to sort fields in the form because i need to open the form in diff scenarios using same table but diff sorting of fields. i used query.extend but select only data not fields sorting.

regards,
jojo
Reply With Quote
Sponsored Links
  #2  
Old 23rd August 2017, 11:38
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 573
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Hi,

Have you tried specifying Order By clause in query.extend.where in before.program section ?

function void query.extend.where (string extension_string [, long mode])

Please use EXTEND_APPEND as mode.

Vishal
Reply With Quote
  #3  
Old 24th August 2017, 23:14
jojovalenton jojovalenton is offline
Senior Member
 
Join Date: Aug 2007
Posts: 185
jojovalenton is on a distinguished road
Baan: InforLN FP7 - DB: SQL Server 2008 R2 - OS: Window Server 2008 R2
hi,
thanks for reply. i tried your suggestions in the before.program: but still the fields do not arrange as per query.select. any missing in my script?

case tcnpc.safety.inspection:
query.extend.select("tcnpc108.ssty, tcnpc108.ssno, tcnpc108.ssdt, " &
" tcnpc108.lctn, tcnpc108.dmgs, tcnpc108.inty, tcnpc108.dept")
query.extend.from("tcnpc108")
query.extend.where("tcnpc108._index1={tcnpc.safety.inspection}", EXTEND_OVERWRITE )
break

regards,
jojo
Reply With Quote
  #4  
Old 25th August 2017, 07:07
ashish.k.gupta ashish.k.gupta is offline
Junior Member
 
Join Date: Nov 2010
Location: Hyderabad
Posts: 9
ashish.k.gupta is on a distinguished road
Baan: Baan LN - DB: oracle - OS: windows 7
Hi
you can try query.extend.order("<field name> desc") along with your existing query and if it is index field you can use to.key function

Regards
Ashish
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
Find form does not include all index fields tab0529 Tools Development 2 28th June 2010 18:38
Form Error Question mark_h Tools Development 5 8th December 2009 16:29
Index Parts Info NPRao Tools Development 5 4th July 2006 11:52
Fields on Form LittleJohn Tools Development 4 13th May 2004 18:00


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


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