# Value requires (more) subscripts -

**URL:** <https://clarionhub.com/t/value-requires-more-subscripts/7764>\
**Category:** questions\
**Tags:** csv, compiler\
**Created:** [December 21, 2024, 1:44am UTC](https://clarionhub.com/t/value-requires-more-subscripts/7764 "2024-12-21T01:44:51Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![WesVec](https://clarionhub.com/user_avatar/clarionhub.com/wesvec/32/2256_2.png) [@WesVec](https://clarionhub.com/u/WesVec)\
**Post date:** [December 21, 2024, 1:44am UTC](https://clarionhub.com/t/value-requires-more-subscripts/7764/1 "2024-12-21T01:44:51Z")

</div>

Rewriting my import app for all the changes in the new csv file. When compiling this error now occurs. Not sure what it means and how to correct.

Value requires (more) subscripts - C:\NewFMCSA\ImportFMCSA002.clw:257,11

```clarion
que:dot=bas:DOT_NUMBER

```

Compiles when this line is removed.

---

<div class="post-metadata">

**Author:** ![jslarve](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/e480ec/32.png) [@jslarve](https://clarionhub.com/u/jslarve)\
**Post date:** [December 21, 2024, 1:49am UTC](https://clarionhub.com/t/value-requires-more-subscripts/7764/2 "2024-12-21T01:49:37Z")

</div>

Perhaps that field is an array

---

<div class="post-metadata">

**Author:** ![Bruce](https://clarionhub.com/letter_avatar_proxy/v4/letter/b/ccd318/32.png) [@Bruce](https://clarionhub.com/u/Bruce)\
**Post date:** [December 21, 2024, 11:31am UTC](https://clarionhub.com/t/value-requires-more-subscripts/7764/3 "2024-12-21T11:31:43Z")

</div>

One of those fields is sn array and needs a [index]

---

<div class="post-metadata">

**Author:** ![Bruce](https://clarionhub.com/letter_avatar_proxy/v4/letter/b/ccd318/32.png) [@Bruce](https://clarionhub.com/u/Bruce)\
**Post date:** [December 21, 2024, 11:38am UTC](https://clarionhub.com/t/value-requires-more-subscripts/7764/4 "2024-12-21T11:38:14Z")

</div>

One of those fields is sn array and needs a [index]

---

<div class="post-metadata">

**Author:** ![donridley](https://clarionhub.com/user_avatar/clarionhub.com/donridley/32/1459_2.png) [@donridley](https://clarionhub.com/u/donridley)\
**Post date:** [December 21, 2024, 9:25pm UTC](https://clarionhub.com/t/value-requires-more-subscripts/7764/5 "2024-12-21T21:25:23Z")

</div>

As others have said, there’s an array in there somewhere.

---

<div class="post-metadata">

**Author:** ![WesVec](https://clarionhub.com/user_avatar/clarionhub.com/wesvec/32/2256_2.png) [@WesVec](https://clarionhub.com/u/WesVec)\
**Post date:** [December 22, 2024, 2:30am UTC](https://clarionhub.com/t/value-requires-more-subscripts/7764/6 "2024-12-22T02:30:52Z")

</div>

Thanks Everyone,

How is the best approach to find it.

---

<div class="post-metadata">

**Author:** ![Bruce](https://clarionhub.com/letter_avatar_proxy/v4/letter/b/ccd318/32.png) [@Bruce](https://clarionhub.com/u/Bruce)\
**Post date:** [December 22, 2024, 3:45am UTC](https://clarionhub.com/t/value-requires-more-subscripts/7764/7 "2024-12-22T03:45:58Z")

</div>

Read the clw and look for those field declarations. If necessary read the MEMBER clw if the declarations are there.

In the declaration if its defjned as ,DIM then its an array.

---

<div class="post-metadata">

**Author:** ![CarlBarnes](https://clarionhub.com/user_avatar/clarionhub.com/carlbarnes/32/1859_2.png) [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\
**Post date:** [December 22, 2024, 4:39pm UTC](https://clarionhub.com/t/value-requires-more-subscripts/7764/8 "2024-12-22T16:39:19Z")

</div>

> [@WesVec](#):
>
> C:\NewFMCSA\ImportFMCSA002.clw:257,11
> 
> ```auto
> que:dot=bas:DOT_NUMBER
> 
> ```

Use File Open and pick ImportFMCSA002.clw  
Find Pre(que)  
Then scroll down to the field named DOT  
How is that declared?  
Does it have a DIM(  
If Yes, should it?

Repeat the above  
searching for Pre(bas) then DOT\_NUMBER

You probably won’t find it, I would guess it’s in your Dictionary  
So open your DCT  
Find the file with PRE(bas)  
Find the field DOT\_NUMBER  
It probably has a DIM number that you entered accidentally when you meant to enter that number into size

Failing that you could search in your root module  
ImportFMCSA.clw  
for Pre(bas) then DOT\_NUMBER

---

<div class="post-metadata">

**Author:** ![WesVec](https://clarionhub.com/user_avatar/clarionhub.com/wesvec/32/2256_2.png) [@WesVec](https://clarionhub.com/u/WesVec)\
**Post date:** [December 22, 2024, 9:15pm UTC](https://clarionhub.com/t/value-requires-more-subscripts/7764/9 "2024-12-22T21:15:58Z")

</div>

YES, thought I had checked but missed one file. Many thanks Carl and everyone. Have been struggling with this for days. Now to reconcile the other 2 dataset changes which are keyed to the DOT number. Thanks again for the help.
