× 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...

NEED DETAILS ON I_ENQUIRY.COMMON

Start
Prev
1
Next
End

vijitizer
Topic Author
Offline
Junior Member

13 years 10 months ago - 13 years 10 months ago #8927 by vijitizer

NEED DETAILS ON I_ENQUIRY.COMMON was created by vijitizer

Kindly help
Need Info on all variables present in ENQUIRY.COMMON.

Thank You

Last edit: 13 years 10 months ago by vijitizer.

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

13 years 10 months ago #8937 by jpb

Replied by jpb on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

I don't have ALL, but some important

ENQ.SELECTION<1>      Name of enquiry
ENQ.SELECTION<2,n>    Selection field names
ENQ.SELECTION<3,n>    Associated operands (EQ,LK etc)
ENQ.SELECTION<4,n>    Data list
ENQ.SELECTION<5,n>    Background ;Phantom = R / Display = D
ENQ.SELECTION<6,n>    Notify Y / N  not used ?
ENQ.SELECTION<7,n>    spare
ENQ.SELECTION<8,n>    spare
ENQ.SELECTION<9,n>    Sort fields 
ENQ.SELECTION<10>     Function ; OUTPUT <format> for reports

ENQ.ERROR<1,n>  field number in ENQ.SELECTION<2,n>
ENQ.ERROR<2,n>  error message

SELECTION.LIST<n,1>	field names
SELECTION.LIST<n,2> operands
SELECTION.LIST<n,3> data
SELECTION.LIST<n,4> sort

D.FIELDS			field names
D.LOGICAL.OPERANDS	operands numeric
D.RANGE.AND.VALUE	Data list delimited by SM if more than one value

numeric operands
1 = EQ
2 = RANGE
3 = LT
4 = GT
5 = NE
6 = LIKE
7 = UNLIKE
8 = LE
9 = GE
10 = NR

Please Log in or Create an account to join the conversation.

vijitizer
Topic Author
Offline
Junior Member

13 years 10 months ago #8942 by vijitizer

Replied by vijitizer on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

Thank you jbp

But in need more details on VC, VM.COUNT this type of variables which are not commonly used

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

13 years 10 months ago #8945 by jpb

Replied by jpb on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

VC and VM.COUNT are used to determine if all multivalues that occur in one line are processed (VC = actual count, VM.COUNT = max. of all multivalued fields in current line)

The same applies to S and SM.COUNT for Subvalues.

Please Log in or Create an account to join the conversation.

ridik
Offline
Premium Member

13 years 9 months ago #9194 by ridik

Replied by ridik on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

Hi, jpb
I'm wondering is there a variable I could use to sequentially enumerate each result line in the enquiry, for example:

Customer List
# Customer.Id Customer Name
1 234 AAAAAAAAAA
2 679990 BBBBBBBBBB
3 19088 CCCCCCCCCC
...
n 100897 ZZZZZZZZZZ

Regards,
Ridik

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

13 years 9 months ago #9195 by jpb

Replied by jpb on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

Hi ridik,

do you talk about showing a "running number" ??

Regards,
jpb

Please Log in or Create an account to join the conversation.

ridik
Offline
Premium Member

13 years 9 months ago #9205 by ridik

Replied by ridik on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

Hi, jpb
That's right a need a running number. I tried the same solution you showed, because I didn't know if the ENQUIRY application has a control variable for that.
Even though in my requirements I need to reinitialize that runnning number based on a break condition, and I haven't figure it out so far.

I'll appreciate any suggestion

Regards,
ridik

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

13 years 9 months ago #9206 by jpb

Replied by jpb on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

Try defining NO. as Operation = TOTAL FIX
with DISPLAY.BREAK set to your defined "BREAK CHANGE" field

Please Log in or Create an account to join the conversation.

ridik
Offline
Premium Member

13 years 9 months ago #9207 by ridik

Replied by ridik on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

I tried that and it works fine for counting elements in each group, because it reinitilise the total when the break condition is met, but I still need the running number.

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

13 years 9 months ago #9214 by jpb

Replied by jpb on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

Can you show us what you have and what you expect, it's a bit hard to follow ...

Please Log in or Create an account to join the conversation.

ridik
Offline
Premium Member

13 years 9 months ago #9228 by ridik

Replied by ridik on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

Hi, jpb

I have a table that look similar to this:

Ccy Contract Bank Total
USD 00069454 02 13.50
USD 01813069 05 18.72
USD 01653624 02 27.99
USD 00631407 03 32.40
USD 01076202 03 42.64
USD 00089216 04 86.79
USD 01723172 02 12.45
USD 00631344 04 62.31
GBP 00089204 03 86.79
GBP 00857072 02 12.45
GBP 00116106 05 62.31
JPY 01769918 03 563.23
JPY 00094470 02 982.12
JPY 00186670 05 90.23
JPY 01641640 04 74.37

and I need to show the info group by currency on independent pages, and with a running number for each currency. Something like this:

Page 1 (suposse only 5 line per page)
Ccy:USD Date:20111021
# Contract ID Bank Total
1. 00069454 02 13.50
2. 01813069 05 18.72
3. 01653624 02 27.99
4. 00631407 03 32.40
5. 01076202 03 42.64

Page 2
Ccy:USD Date:20111021
# Contract ID Bank Total
6. 00089216 04 86.79
7. 01723172 02 12.45
8. 00631344 04 62.31

Page 3
Ccy:GBP Date:20111021
# Contract ID Bank Total
1. 00089204 03 86.79
2. 00857072 02 12.45
3. 00116106 05 62.31

Page 4
Ccy:JPY Date:20111021
# Contract Bank Total
1. 01769918 03 563.23
2. 00094470 02 982.12
3. 00186670 05 90.23
4. 01641640 04 74.37

Hope it helps to understand my requirements.

Regards,
ridik

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

13 years 9 months ago #9234 by jpb

Replied by jpb on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

I tried a bit but the best result is having the counter always 1 behind :(

Only way seems to be a nofile or attach a routine that uses a field from common to compare if a break has occured?!

Regards,
jpb

Please Log in or Create an account to join the conversation.

ridik
Offline
Premium Member

13 years 9 months ago #9237 by ridik

Replied by ridik on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

That's exactly what happen to me. My hope was this application would have a common variable to control detail lines.
Thanks for your info and effort on this matter.
Best regards,
ridik

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

13 years 9 months ago #9238 by jpb

Replied by jpb on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

You can try using PREVIOUS.DATA<nn> in your routine for comparison (from I_ENQUIRY.COMMOM)

Please Log in or Create an account to join the conversation.

ridik
Offline
Premium Member

13 years 9 months ago #9239 by ridik

Replied by ridik on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

Ok, I'll give it a try.

Please Log in or Create an account to join the conversation.

DUBLIN
Offline
Elite Member

13 years 9 months ago - 13 years 9 months ago #9240 by DUBLIN

Replied by DUBLIN on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

Hi ,

Could you try this one. Be carefull as order DOes matter !

1 PAGE.SIZE ........ 4,19
2 FILE.NAME......... ACCOUNT
4. 1 FIXED.SORT..... CURRENCY
14. 1 FIELD.NAME..... ZERO
15. 1. 1 OPERATION... "0"
21. 1 DISPLAY.BREAK.. ONCE
14. 2 FIELD.NAME..... ONE
15. 2. 1 OPERATION... "1"
14. 3 FIELD.NAME..... CCY
15. 3. 1 OPERATION... CURRENCY
35. 3 SINGLE.MULTI... S
14. 4 FIELD.NAME..... RUN.NUM
15. 4. 1 OPERATION... IF CCY.OLD EQ CCY SAVE.RUN.NUM ZERO
14. 5 FIELD.NAME..... CUR.NUM
15. 5. 1 OPERATION... C RUN.NUM + ONE
16. 5 COLUMN......... 2
14. 6 FIELD.NAME..... SAVE.RUN.NUM
15. 6. 1 OPERATION... F CUR.NUM
14. 7 FIELD.NAME..... @ID
15. 7. 1 OPERATION... @ID
16. 7 COLUMN......... 10
17. 7 LENGTH.MASK.... 8L
35. 7 SINGLE.MULTI... S
14. 8 FIELD.NAME..... CCY.DISP
15. 8. 1 OPERATION... CURRENCY
16. 8 COLUMN......... 25
17. 8 LENGTH.MASK.... 3L
35. 8 SINGLE.MULTI... S
14. 9 FIELD.NAME..... BR.CCY
15. 9. 1 OPERATION... B C CCY
16. 9 COLUMN......... P
14.11 FIELD.NAME..... CCY.OLD
15.11. 1 OPERATION... CURRENCY

OUTPUT :

1 19968 AUD
2 20613 AUD
3 21962 AUD
4 22721 AUD
5 25586 AUD

ENQUIRY TEST.DEV 18 MAY 11 REPORT ACL Page 2
Area TEST No. 1 Printed at 24 OCT 2011 16:27:13
To TEST TEST

1 19917 CAD
2 22737 CAD

ENQUIRY TEST.DEV 18 MAY 11 REPORT ACL Page 3
Area TEST No. 1 Printed at 24 OCT 2011 16:27:13
To TEST TEST

1 19925 CHF
2 22748 CHF

ENQUIRY TEST.DEV 18 MAY 11 REPORT ACL Page 4
Area TEST No. 1 Printed at 24 OCT 2011 16:27:13
To TEST TEST

1 19933 DKK

ENQUIRY TEST.DEV 18 MAY 11 REPORT ACL Page 5
Area TEST No. 1 Printed at 24 OCT 2011 16:27:13
To TEST TEST

1 19488 EUR
2 19518 EUR
3 19526 EUR
4 19558 EUR
5 19976 EUR
6 20524 EUR
7 20656 EUR
8 20718 EUR
9 21113 EUR
10 21881 EUR
11 21903 EUR
12 21946 EUR
13 22047 EUR
14 22055 EUR
15 22322 EUR
16 22373 EUR
17 22411 EUR
18 22427 EUR
19 22478 EUR
20 22489 EUR
21 22497 EUR
22 22527 EUR
23 22667 EUR
24 22756 EUR
25 22918 EUR
26 22969 EUR
27 22985 EUR
28 22993 EUR
29 23008 EUR
30 23019 EUR
31 23027 EUR
32 23035 EUR
33 23043 EUR
34 23051 EUR
35 23067 EUR
36 23108 EUR
37 23248 EUR

ENQUIRY TEST.DEV 18 MAY 11 REPORT ACL Page 6
Area TEST No. 1 Printed at 24 OCT 2011 16:27:13
To TEST TEST

38 23264 EUR
39 23353 EUR
40 25003 EUR
41 25011 EUR

Last edit: 13 years 9 months ago by DUBLIN.

The following user(s) said Thank You: jpb

Please Log in or Create an account to join the conversation.

ridik
Offline
Premium Member

13 years 9 months ago #9242 by ridik

Replied by ridik on topic Re: NEED DETAILS ON I_ENQUIRY.COMMON

Hi, Dublin
your solution works perfect for me after I did an small adjustment. I have to add a new field between FIELD 4 and FIELD 5 in your solution.

14. 4 FIELD.NAME..... RUN.NUM
15. 4. 1 OPERATION... IF CCY.OLD EQ CCY SAVE.RUN.NUM ZERO

14. 5 FIELD.NAME..... RNUM
15. 5. 1 OPERATION... F RUN.NUM <

asign RUN.NUM value to RNUM

14. 6 FIELD.NAME..... CUR.NUM
15. 6. 1 OPERATION... C RNUM + ONE <

replace RUN.NUM wiht RNUM
16. 6 COLUMN......... 2

Thanks a lot!!!
Best regards,
Ridik

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Time to create page: 0.067 seconds

NEED DETAILS ON I_ENQUIRY.COMMON

Attachments:

Attachments: