Stored Procedure from MsSQL to Temporary table to Nav

jhanvincent14

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

RockWithNAV

I believe the only way to achieve this is to call a stored procedure from NAV which will return all the specific values of the table and then you need to manually insert this.

Peter+is1

no.

good luck.

jhanvincent14

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

Share the tips please!

jhanvincent14

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

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

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.

Peter+is1

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.

RockWithNAV

I believe the only way to achieve this is to call a stored procedure from NAV which will return all the specific values of the table and then you need to manually insert this.

Peter+is1

Any news?

jhanvincent14

Peter+is1 wrote: »

Any news?

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