hana query and $[ ]

[former_member424692]

Dear All,

Please advice is it possible to use $[ ] for reference to current open window with UDV in SQL HANA query?

[kvbalakumar · Accepted solution]

Hi,

Yes, it is 100% possible to use $[] syntax for HANA

[former_member424692 · Accepted solution]

My query works with exact parameters, but shows errors with reference to current form and UDF field. Please kindly advice:

(SELECT MAX("PrjCode") + 1 FROM OPRJ WHERE "U_PartnerNo" = $["U_PartnerNo"])

This query returns error.

The same query but with exact parameter, e.g. $["U_PartnerNo"] = '11' returns requested number. The mistake is obviously somewhere in this final part.

[kvbalakumar · Accepted solution]

UDV/FMS syntax is wrong. Please correct the syntax.

It should be either $[TableName.FieldName] or $[FieldItemNo.ColumnNo.0]