Hello everyone.
I fear index problems because Jet reports is showing me records that are deleted already…
I made a report showing me the item table with item no. and than I retrive the first item of a second table in beside it.
to check relations between the table.
when I did not find a few records in the second table, I got woried and tried to find the item in the item table, using Navision and SQL with no result.
I know by head that those items where deleted long ago, but how dous Jet remember that? and when deleted I am not interested in it…
What is happening? I tried to do some SQL querys on the database
SELECT [No_]
FROM [PROD_DB].[dbo].[Cronus$Item] WITH (INDEX = 1)
WHERE [No_] = 'MISSINGITEMNO'
GO
TO
SELECT [No_]
FROM [PROD_DB].[dbo].[Cronus$Item] WITH (INDEX = 17)
WHERE [No_] = 'MISSINGITEMNO'
GO
raizing the index number every time, to check every index but that did not give me results either..
Any help = apriciated
Regards,
Sjaco
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Sjaco,
First I should clarify that you are actually running the report (Jet -> Report or Jet -> Refresh). Results in design mode are optimized for speed and not guaranteed to be accurate.
Jet is not remembering something that was deleted. If Jet is returning the record then it does exist in the database. Assuming you are connecting to Navision with a Navision data source in Jet, Jet is using C/Front and the Navision client to connect to the database. Therefore, you should probably look for the record in the Navision client itself (not in the SQL backend). The easiest way to do that is to open the Object Designer in the Navision client (the classic client if you are using NAV 2009 or later). Find the table in question and run it. Then you can filter it or scroll through it till you find the records Jet is returning. If you really think Jet is returning records that do not exist, you are welcome to create a ticket on the Jet support site, but lots of tickets have come through support from people who thought Jet was doing this and 99% of the time the records are there. Does this help?
Regards,
Hughes
Please sign in to leave a comment.