Stored Procedure from MsSQL to Temporary table to Nav

jhanvincent14
jhanvincent14 Member Posts: 214
in NAV Tips & Tricks
Good day. I have this kind of problem. is it possible for a stored procedure to have a value in the temporary table(SourceTableTemporary Property of a Page in Navision) which can later on be pulled out and made to appear in a page(NAVISION)? Thanks in advance :)

Best Answer

Answers

  • Peter+is1
    Peter+is1 Member Posts: 174
    no.

    good luck.
    \\
    The truth exists in seven versions.
  • jhanvincent14
    jhanvincent14 Member Posts: 214
    Peter+is1 wrote: »
    no.

    good luck.

    thanks for your answer :) by the way I've found some tips in stackoverflow on how to do it :)
  • Peter+is1
    Peter+is1 Member Posts: 174
    Share the tips please!
    \\
    The truth exists in seven versions.
  • jhanvincent14
    jhanvincent14 Member Posts: 214
    Peter+is1 wrote: »
    Share the tips please!

    yes of course I will share it here. but first I need to make it work :)
  • Remco_Reinking
    Remco_Reinking Member Posts: 74
    Yes off course it is.
    One option is to call stored procedure from NAV, get the resultset and fill the NAV-temptable, and start the page with this temptable.
  • rmv_RU
    rmv_RU Member Posts: 119
    We have done it by using Ado for procedures that can be executed in different transactions than Nav transaction. For procedures, that must be executed in one transaction with Nav we use buffer tables.
    Looking for part-time work.
    Nav, T-SQL.
  • Peter+is1
    Peter+is1 Member Posts: 174
    jhanvincent14 wrote: »
    Peter+is1 wrote: »
    Share the tips please!

    yes of course I will share it here. but first I need to make it work :)

    Any results already? I am very curious. :)
    \\
    The truth exists in seven versions.
  • Peter+is1
    Peter+is1 Member Posts: 174
    Any news?
    \\
    The truth exists in seven versions.
  • jhanvincent14
    jhanvincent14 Member Posts: 214
    Peter+is1 wrote: »
    Any news?

    kindly please email me here jvillasin14@gmail.com for the information and how did I do it.

Categories