I have a profile with ten users. In the SQL these run, I want each to get a value to use in the where clause from a file - each user has its own file, so user A has C:\A.txt, B has C:\B.txt, etc. I came up with this
where id=$BFFileArray($BFConcat(“C:”,$BFProfile(USERNAME) ,".txt"),RANDOM)
The $BFConcat function constructs the filename from the username, and $BFFileArray gets a single value from the file to complete the condition.
But the syntax of the $BFFileArray function does not allow a function as one of its parameters, because when I test this I get
“Parameter 1 of script FileArray must not be an embedded script”
Does anyone know of a workaround for this?