Question on Temp tables in Navision

Business Central/NAV User Forum
1

We use Navision 5.0 SP 1.

I am trying to use the G/L Entry table as a temp table. As soon as i go to Insert into the temp table I get an error message. Everything compiles fine in the report.

TempGLEntry := “G/L Entry”;
TempGLEntry.INSERT;

Are only certain tables allowed to be used as Temp tables?

Is there another method of using a temp table? Array maybe??

Thanks in advance,

Greg

2

What’s the error message?

3

Have you set the TempGL table as tempory=yes in the property ?

4

The error is no permission to insert into the G/L Entry table.

5

Thanks Manish.

Never realized there was a property for variables.

6

Just curious, and maybe it will help someone else, but how were you doing it? Were you thinking it would make it a temp table by adding Temp to the beginning of the variable name?

7

[:D]

You are never too old to learn!

8

Thank U

9

That’s what I was doing Matt,

My bad…

Greg