You can use "Navision Developers Toolkit" which can be found on the 3.70 tools disc
Notice: In order to run Navision Developer's Toolkit your License file must be updated with the following Navision granules:
99,003,640 - Navision Developer’s Toolkit - Source Analyzer
99,003,650 - Navision Developer’s Toolkit - Compare & Merge
I think Philippe wants to search in every field of a table for data.
Maybe you could use the new datatypes RecordRef and FieldRef to step through all records of all tables, and search for a particular string. But it will be very slow.
No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
We have a huge DB (30 Gig), with a few thousand new objects. In those objects, we have data that refers to shared files.
The DB is a heritage from an other NSC, and we do not have any documentation on it.
The DB will be moved to an other location, so we need to review all links to external objects (like fileshares etc.).
In order to avoid "forgetting" a few links, I would like to search all data for strings like "/:" or "h:/" or ....
Write some dataports to export all tables to a text-file. Then you can do your searching on those text-files.
Search in the downloads on this site for a dataport generator. This routine creates a Navision object text-file, containing dataports for selected tables. That object file needs to be imported in the database and compiled, and your dataports are created.
No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
Comments
You can use "Navision Developers Toolkit" which can be found on the 3.70 tools disc
Notice: In order to run Navision Developer's Toolkit your License file must be updated with the following Navision granules:
99,003,640 - Navision Developer’s Toolkit - Source Analyzer
99,003,650 - Navision Developer’s Toolkit - Compare & Merge
1.) Export all objects as text
2.) Open the exported file as UltraEdit32
3.) Search for the string of your choice
Vice President, Deployment Operations
Symbiant Technologies, Inc.
http://www.symbiantsolutions.com
Maybe you could use the new datatypes RecordRef and FieldRef to step through all records of all tables, and search for a particular string. But it will be very slow.
We have a huge DB (30 Gig), with a few thousand new objects. In those objects, we have data that refers to shared files.
The DB is a heritage from an other NSC, and we do not have any documentation on it.
The DB will be moved to an other location, so we need to review all links to external objects (like fileshares etc.).
In order to avoid "forgetting" a few links, I would like to search all data for strings like "/:" or "h:/" or ....
any ideas?
Search in the downloads on this site for a dataport generator. This routine creates a Navision object text-file, containing dataports for selected tables. That object file needs to be imported in the database and compiled, and your dataports are created.
I did this already looking specifically for date fields.
Use this:
...and it works