Post Reply 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Periods in database filenames
06-28-2016, 04:05 PM
Post: #1
Periods in database filenames
As noted in the following it is not good practice to have a period in a filename other than for the file extension:
ValueListItem bug
Design functions fail when filename has a dot in it

In the process of determining that this was the root cause, it was noted that the length of the filename also has an affect on the outcome.
Using copies of the same file but with different filenames gives different behaviour for ValueListItems ( Get(FileName) ; "RM_Child_Ver" )
It was noted that Get(FileName) dialogue box will display the name prefix correctly (prior to .fmp12)

NOK Sigma_2016-06-21_14.00.fmp12
OK Sigma_2016-06-21_14.00_Modify_Find_Error.fmp12
OK Sigma_2016-06-21_1400.fmp12
NOK Sigma_2016-06-21_14.00.Copy.fmp12

The real solution was tested in Sigma_2016-06-21_14.01.fmp12

Changed: ValueListItems ( Get(FileName) ; "RM_Child_Ver" )
to: ValueListItems ( "" ; "RM_Child_Ver" )

OK Sigma_2016-06-21_14.01.fmp12
Find all posts by this user
Quote this message in a reply
06-28-2016, 04:18 PM
Post: #2
RE: Periods in database filenames
Sigma uses time stamps in lots of saved file names. This is generally done using the custom function "GetTimeStampString" which produced a file system friendly string. It basically substitutes out periods and spaces and replaces them with _ and -.
Find all posts by this user
Quote this message in a reply
Post Reply 

Forum Jump:

User(s) browsing this thread: 1 Guest(s)