×
Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...
FIXED.SORT field in equiry.
- kda
- Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 603
- Thank you received: 3
12 years 1 month ago #10743
by kda
FIXED.SORT field in equiry. was created by kda
Dear all,
Could you please explain me clearly about field FIXED.SORT field in enquiry.
What is the function of this field in enquiry with or without it effect to our report or not?.
Thank so much.
Could you please explain me clearly about field FIXED.SORT field in enquiry.
What is the function of this field in enquiry with or without it effect to our report or not?.
Thank so much.
Please Log in or Create an account to join the conversation.
- durai611
- Offline
- Elite Member
-
Less
More
- Posts: 300
- Thank you received: 51
12 years 1 month ago - 12 years 1 month ago #10744
by durai611
Replied by durai611 on topic Re: FIXED.SORT field in equiry.
If FIXED.SORT is set, then records are selected by sort order of the field specified.
For example:
For an enquiry to display account numbers if CUSTOMER field is set as FIXED.SORT then the select statement is like
SELECT FXXX.ACCOUNT BY CUSTOMER (Default ascending order)
else (No FIXED.SORT)
SELECT FXXX.ACCOUNT
Certainly this will affect the display of records.
For example:
For an enquiry to display account numbers if CUSTOMER field is set as FIXED.SORT then the select statement is like
SELECT FXXX.ACCOUNT BY CUSTOMER (Default ascending order)
else (No FIXED.SORT)
SELECT FXXX.ACCOUNT
Certainly this will affect the display of records.
Last edit: 12 years 1 month ago by durai611.
Please Log in or Create an account to join the conversation.
- kda
- Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 603
- Thank you received: 3
12 years 1 month ago #10767
by kda
Replied by kda on topic Re: FIXED.SORT field in equiry.
Hi durai611,
Thank so much
Thank so much
Please Log in or Create an account to join the conversation.
- zouzou
- Offline
- Junior Member
-
Less
More
- Posts: 25
- Thank you received: 0
3 years 2 months ago #23280
by zouzou
Replied by zouzou on topic Re: FIXED.SORT field in equiry.
Can I use fixed sort in a nofile ENQ
when I do it I'm getting this error "INVALID SORT FIELD "
and if I can use it in no file enquiry how can I group by a field(string not integer)
or how can I sort
thank you
when I do it I'm getting this error "INVALID SORT FIELD "
and if I can use it in no file enquiry how can I group by a field(string not integer)
or how can I sort
thank you
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
3 years 2 months ago #23282
by VK
Cheers
VK
Replied by VK on topic Re: FIXED.SORT field in equiry.
Hi
you can do everything in your NOFILE routine
you can do everything in your NOFILE routine
Cheers
VK
Please Log in or Create an account to join the conversation.
- silvergem
-
- Offline
- Elite Member
-
- TAFC|R12/R13, TAFJ|R20
Less
More
- Posts: 247
- Thank you received: 20
3 years 1 month ago #23284
by silvergem
Replied by silvergem on topic Re: FIXED.SORT field in equiry.
sort is based on field defined at standard selection, since you are using the nofile, you need to defined the fields also or you can sort it based on ID
www.wikibanking.info/?s=nofile
www.wikibanking.info/?s=nofile
Please Log in or Create an account to join the conversation.
- DUBLIN
- Offline
- Elite Member
-
Less
More
- Posts: 202
- Thank you received: 29
3 years 1 month ago #23287
by DUBLIN
Replied by DUBLIN on topic Re: FIXED.SORT field in equiry.
Hi zouzou,
You could go to STANDARD.SELECTION table like
SS S "YOUR NOFILE NAME" . You will see all fields defined for this NOFILE. Most of them could be used in FIXED.SORT field exept field with type R.
You could go to STANDARD.SELECTION table like
SS S "YOUR NOFILE NAME" . You will see all fields defined for this NOFILE. Most of them could be used in FIXED.SORT field exept field with type R.
Please Log in or Create an account to join the conversation.
Time to create page: 0.114 seconds