Syntax Error in SELECT FROM on Hana

[former_member208415]

Hi guys,

I am new to B1 and I can't get data from a user defined table. (@MBB_S)

I get syntax error at the '@'

Does anybody know how to encode the string in VB to make it work?

I am running version 9.2 on Hana

My code is:

SqlStr = "SELECT U_MBB1 FROM @MBB_S"

            oRecSet.DoQuery(SqlStr)

            While Not oRecSet.EoF

                Windows.Forms.MessageBox.Show("MBB1" & oRecSet.Fields.Item("MBB1").Value & _

                "MBB2" & oRecSet.Fields.Item("MBB2").Value)

                ' Get the next record

                oRecSet.MoveNext()

            End While

Thanks,

Martin

[Former Member · Accepted solution]

SqlStr = SELECT "U_MBB1" FROM "[@MBB_S]"

Try this.

Thanks,

Harshal

[former_member208415 · Accepted solution]

Thanks, but that doesn't work in VB.

I got it working with this:

"SELECT U_MBB1 FROM ""@MBB_S"""

[frank_wang6]

SqlStr = "SELECT U_MBB1 FROM [@MBB_S]"

you should add [] on table name.

[former_member208415]

Thanks Frank,

I have tried that, but this also gives me a syntax error

Martin

[KennedyT21]

Hi Martin,

Post in the SDK Place to get quick response

Cheers

[former_member208415]

Thanks, Kennedy, I'll do that.

Martin