Announcement

Collapse
No announcement yet.

Stored Procedures: run() return type

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • theschmitzer
    started a topic Stored Procedures: run() return type

    Stored Procedures: run() return type

    Per the schema compiler, run() can return long, Long, VoltTable or VoltTable[]

    I have a stored proc returning long, and cannot find in the documentation how to access the value.

    Results.table is an empty array in this case. Anybody know how I get my long value? I am using voltjs node client.

    Thanks

    jeff

  • jhugg
    replied
    Procedures always return an array of tables. Returning a long or scalar VoltTable from your procedure is just a convenience. Ultimately that long will be put in a one-column, one-row VoltTable and put into an array of length 1.

    So what you're seeing is expected.

    Leave a comment:


  • jhugg
    replied
    Procedures always return an array of tables. Returning a long or scalar VoltTable from your procedure is just a convenience. Ultimately that long will be put in a one-column, one-row VoltTable and put into an array of length 1.

    So what you're seeing is expected.

    Leave a comment:


  • theschmitzer
    replied
    I think I may have had an error in my stored proc, because I see the result in result.tables[0][0] now

    Leave a comment:

Working...
X