mibuso.com
Home› NAV Tips & Tricks
Options

Stored Procedure from MsSQL to Temporary table to Nav

jhanvincent14jhanvincent14 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

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

    good luck.
    \\
    The truth exists in seven versions.
  • Options
    jhanvincent14jhanvincent14 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 :)
  • Options
    Peter+is1Peter+is1 Member Posts: 174
    Share the tips please!
    \\
    The truth exists in seven versions.
  • Options
    jhanvincent14jhanvincent14 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 :)
  • Options
    Remco_ReinkingRemco_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.
  • Options
    rmv_RUrmv_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.
  • Options
    Peter+is1Peter+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.
  • Options
    Peter+is1Peter+is1 Member Posts: 174
    Any news?
    \\
    The truth exists in seven versions.
  • Options
    jhanvincent14jhanvincent14 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.
Sign In or Register to comment.