FAQ- POSSIBLE REPORT QUERY

Manex has over 400 dynamic tables, so it would be very difficult for us to continually update/maintain these.  So we will not be providing any table listings and relationship information in a standard format.   What we have done and can continue to do is have users let us know which specific table they are looking for and what they are trying to create so we can give some information related to that area

 

As requests arise, we will create a cursor that captures some data from the related files. If users have any knowledge of queries, they should be able to add or subtract information they might need or not need from the basic outline. 

 

These queries are for your reference and are subject to change at anytime due to programming.
 

 

In addition the below suggestion might help you find specific Table/fields you desire in your report:

  • Using your TEST ManEx system.
  • Make the desired record entry within Manex
  • Save all of the records/changes
  • Completely Exit the TEST ManEx system
  • Close the TrigTimer
  • Then go to the TEST ManEx\DBFS directory
  • Change the View to “Details”
  • Then sort the tables per “Date Modified”
This will narrow your search down to at least a small hand full of tables, that the desired field could be located.
 
Note:  Once SQL conversion has been completed ManEx will be able to more easily provide Table/Structure changes to our users when their Custom reports are concerned.  At this point in time if one of their Custom reports stop working possibly due to Table/Structure changes made by ManEx, they will have to provide us with the SQL statement for review and assistance.