Hi all, Standard navision reports make extensive uses of Integer dataitems. I wonder what they are for, when they should be used. I also found Number ‘field’ in the Table Filter part of the DataItemTableView property. What does this ‘Number’ indicate? Is there any other type of dataitems other than table and integer dataitem? Please advise. Thanks. Regards, Hadi Lai
Hi Hadi, Integer is in fact a virtual (System-) table and Number is a (the only) field in this table. You’ll find Systemtables in the object-id range 200000001…200000203. These tables can be used (almost) like any other tables. Please search for “Integer table” and/or “Virtual table” in the forum and youl’ll find a lot of info.
quote:
Hi all, Standard navision reports make extensive uses of Integer dataitems. I wonder what they are for, when they should be used. I also found Number ‘field’ in the Table Filter part of the DataItemTableView property. What does this ‘Number’ indicate? Is there any other type of dataitems other than table and integer dataitem? Please advise. Thanks. Regards, Hadi Lai
Originally posted by Hadi Lai - 2005 Jun 01 : 15:26:01
Integer is a virtual table “containing” integer numbers (1, 2, 3…) - each record a number. Integer.Number is the only field in this table, its value is an integer number, that is: Record # 1 - Integer.Number = 1 Record # 2 - Integer.Number = 2 … Record # 1,457,256,456 - Integer.Number = 1,457,256,456 and so on… In reports it is often used as a dummy DataItem, whenever you need to print something which can’t be directly related to a real DataItem. Since the Integer numbers are infinite, to prevent an infinite loop, the records in a DataItem based on Integer must be filtered into a finite range before the DataItem starts to be processed. That can be done with a filter in the DataItemTableView property, when you know in advance how many times the triggers and sections on the DataItem must be executed or in the OnPreDataItem trigger. An other virtual table which you will find often used, both in reports and forms, is the Date table, which “contains” all the dates from 01/01/0000 to 31/12/9999. Did I manage to sound sufficiently confused? [:D] Anna
The Integer table isn’t quite infinite [;)] it has a range from -1.000,000,000 to 1,000,000,000
SV, Maybe I’m wrong, but as far as I remember, the range of Integer is between -2147483647 and 2147483647. /Karl
Hi Karl, It’s correct that the Datatype Integer has a range from -2,147,483,647 to 2,147,483,647. The Virtual table Integer (Table 200000026), though, has a range from -1.000,000,000 to 1,000,000,000
Hi all, Thanks a lot for all he replies. I am quite enlightened now. I was always thinking of the Integer as a dataitem was type; that what confused me. Thanks for the information. Regards, Hadi Lai