Use of the SQL Index via Navision?

Philipp

Hallo everyboy!

I'm everything but an experienced Navision developer. Thus please don't explain on a too high level.
I have got two questions.
Firstly, is it possible to access the Index of a SQL Table via Navision? If it is - what I expect - can you tell me how?
Secondly, can you tell me whether Navision finds the optimal keys by itself?

Thanks in advance

Regards

Philipp

Doomhammer

Hi

I try to answer you:

1) I think, Navision works wit its own indexes and translation layer between Navision SQL Client and SQL server translates indexes from Navision keys to SQL indexes.

2) Navision can not automaticaly select best key (except situation when user uses FIND (ctrl+f) function). User must select key using SORT command from toolbar (shift+F8) and developer must use function RECORD.SETCURRENTKEY(fields) or TableView property on Form, report or dataport.

M.

kine

But in some cases SQL use another key because Navision only hint the key...

- MS SQL sometime thinks, that he knows better how select data from DB... 8)