ValueListNames - Not working

[Amram Chayim Eirinberg]

I have a calculated field with the following definition: ValueListNames ( Get(FileName )) The file has many lists, the field returns an empty string!

Any help will be very much appreciated!

Amram Chayim Eirinberg

[comment]

What is your file's name?

[LaRetta]

Two additional things you can check: 1) Do you have at least one record in the file? Calculations won't display unless there is and 2) If you created the calculation before you entered any value lists AND if the calculation is not unstored, it will remain empty.

Item 1 would not be true if calculation was unstored.

Edited April 22, 2010 by Guest
Corrected Item #1

[Amram Chayim Eirinberg]

Thanks Laretta

I changed Get(FileName) with literal filename text including the ext. .fp7, now it works.

[LaRetta]

I do not believe that is the best answer. If you ever change that file name then your calculation will break. Comment was asking for your file name for reason. :wink2:

[comment]

Indeed:

http://fmforums.com/forum/showpost.php?post/294072/

http://fmforums.com/forum/showpost.php?post/243167/

[Amram Chayim Eirinberg]

The filename is TimeWyze.v4.1.fp7 I did see somewhere that get(filename) has a bug when the file name includes a period as in my case, perhaps I should change it, although I believe I have used Get(Filename) in other places in the same file with good results.

[LaRetta]

"perhaps I should change it,"

I believe the links are quite clear about the dangers of using period in file name. And I was quite clear on the effects if you rename your file (when you hard-code it within the calculation).

We can provide you the facts but only you can decide whether your data should be protected and available according to those facts.