If I have a field named "[Items]Material Value" and try to use it with string interpolation as follows for example:

write to console ('Materials = [Items]Material Value'), it fails with an error :

return ([Items]Materials)
Invalid table/field reference.

Obviously its having a problem with the space in the field name.

It's doing the right thing. Think about it for a second...if I were to allow spaces in a field name, how would I know where the field name ended and the text after the field name started?

From the documentation:

"What happens if the variable name or _form/_query/_request reference is
followed or preceded by valid identifier characters? How do we distinguish between the embedded reference and the surrounding text? In a case like this
you have to enclose the variable name with backticks"

So in the example above, you have to do this:

'Materials = `[Items]Material Value`'

Regards,

   Aparajita
   Victory-Heart Productions
   www.aparajitaworld.com

   "If you dare to fail, you are bound to succeed."
   - Sri Chinmoy   |   www.srichinmoylibrary.com

_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/

Reply via email to