Hy i just saw in the d3 ref this:
https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/102/refman/TCL/index_select_command.htm#reference4710
so i tryed
index-select sgvar016 A6(MCNA):" ":2
but i got the message
[162] Error in icode conversion: 'A6(MCNA):"'; index not found.
what is the correct way to use ?
------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------
Hi Alberto,
I think the parser is getting it's knickers in a twist with the space in the A-correlative; so while a legal syntax; the command parser thinks the index.specification is A6(MCNA):"
If you are able, you could prove this by using a non-space in your index.specification A-correlative.
I guess what we need is a different command delimiter? Or the ability to specify via an A-correlative to append a space? I cannot think of one.
Source is available; and sure enough the routine is doing a space based field extract:
0026 Tclread tcl
0027 tcl = Trim(tcl);* [03]
0028 fn = Field(tcl," ",2)
I guess you could copy this a routine of your own choosing and modify it, but it would then be a custom routine.
------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------
Hi Alberto,
I think the parser is getting it's knickers in a twist with the space in the A-correlative; so while a legal syntax; the command parser thinks the index.specification is A6(MCNA):"
If you are able, you could prove this by using a non-space in your index.specification A-correlative.
I guess what we need is a different command delimiter? Or the ability to specify via an A-correlative to append a space? I cannot think of one.
Source is available; and sure enough the routine is doing a space based field extract:
0026 Tclread tcl
0027 tcl = Trim(tcl);* [03]
0028 fn = Field(tcl," ",2)
I guess you could copy this a routine of your own choosing and modify it, but it would then be a custom routine.
------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------
A guess a cheat-way would be to create a dictionary item that returns the space char; and use it as via the n(dictonaryitem) command:
Thus:
A6(MCNA):n(space)["1","1"]:2
Where 'space' is a dictionary item in the same file which always returns a single space.
That might work?
------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------
Hy i just saw in the d3 ref this:
https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/102/refman/TCL/index_select_command.htm#reference4710
so i tryed
index-select sgvar016 A6(MCNA):" ":2
but i got the message
[162] Error in icode conversion: 'A6(MCNA):"'; index not found.
what is the correct way to use ?
------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------
i had some sucess but its not expect result yet
:up dict sgvar016 I.TEST
DICT sgvar016 'I.TEST' size = 32
01 S
02 6(MCNA):" ":2
INDEX-SELECT SGVAR016 I.TEST N 0986
where N is the direction
0986 is the string i want to begin the search
but how to sow the results
expect result i want to see the string created by the index 6(MCNA):" ":2
------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------
i had some sucess but its not expect result yet
:up dict sgvar016 I.TEST
DICT sgvar016 'I.TEST' size = 32
01 S
02 6(MCNA):" ":2
INDEX-SELECT SGVAR016 I.TEST N 0986
where N is the direction
0986 is the string i want to begin the search
but how to sow the results
expect result i want to see the string created by the index 6(MCNA):" ":2
------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------
Hi Again,
Not sure I understand your last.
If the routine works; it will create a select list of item keys from the file in question which has an index created with the nominated dictionary item or a-correlative.
I've not played with this; but wouldn't the index have to exist? Read the source of the routine to work out what it is doing.
The resulting select list would then be an active select-list and you can do what you want with those keys afterwards?
Am I missing your point?
------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------
Hi Again,
Not sure I understand your last.
If the routine works; it will create a select list of item keys from the file in question which has an index created with the nominated dictionary item or a-correlative.
I've not played with this; but wouldn't the index have to exist? Read the source of the routine to work out what it is doing.
The resulting select list would then be an active select-list and you can do what you want with those keys afterwards?
Am I missing your point?
------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------
Expect result:
DNI6913 00179
ACA017103 01850
6110502 00237
W2113STD 00116
63052RS 00162
2047CR 00510
0986332611 00035
ETE7814 00222
8PK1750HDGATES 02509
MOLHADEDOCENT 00493
CHCORRONDP17 01638
6106601 00237
W2114ST 00116
wich is A6(MCNA):" ":2
in QM i have the comand LIST.INDEX
for exemple:
LIST.INDEX sgvar016 i.test DETAIL
which show the stored strings for the index created
i liket to get the same result in D3
------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------
Expect result:
DNI6913 00179
ACA017103 01850
6110502 00237
W2113STD 00116
63052RS 00162
2047CR 00510
0986332611 00035
ETE7814 00222
8PK1750HDGATES 02509
MOLHADEDOCENT 00493
CHCORRONDP17 01638
6106601 00237
W2114ST 00116
wich is A6(MCNA):" ":2
in QM i have the comand LIST.INDEX
for exemple:
LIST.INDEX sgvar016 i.test DETAIL
which show the stored strings for the index created
i liket to get the same result in D3
------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------
Ahh, ok.
Stating the obvious: index-select doesn't do what QM's LIST.INDEX command does.
I've not used QM so I do not know if source is provided or not for commands; and of course I am choosing to ignore the whole copyright issue - but one way or another I suspect in d3 you will have to write your own routine to emulate/replicate LIST.INDEX
What does the documentation in QM say about LIST.INDEX and it's use?
------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------
Ahh, ok.
Stating the obvious: index-select doesn't do what QM's LIST.INDEX command does.
I've not used QM so I do not know if source is provided or not for commands; and of course I am choosing to ignore the whole copyright issue - but one way or another I suspect in d3 you will have to write your own routine to emulate/replicate LIST.INDEX
What does the documentation in QM say about LIST.INDEX and it's use?
------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------
hahah to much work
i was looking for an "easy" way...
------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------