To continue with this content, please log in with your Data Access ID or create a new account.
Cancel Data Access ID
You may not be authorized to see this content. Please contact Data Access Europe for more information.
Cancel Data Access Europe
You are not authorized to see this content.
Cancel Data Access Europe
Next lesson:
Message Tracing

Debugging DataFlex Apps

Lesson 8: Tables Window

Things to know about the Tables window

  • Any open tables global record buffer can be viewed 
  • It cannot show anything regarding Data Dictionaries
  • Only open tables are listed
  • If a table is shown as ‘active’ it has data in its global record buffer
  • Alias tables are listed using the master table’s root name, but can be identified using the table number

Demonstration – Inspecting Table Data and Global Record Buffers 

  1. From the Table Explorer, right click on the Customer Table and select ‘New <Customer> Alias Table’
  2. Enter “Customer2” in the ‘Table Name’ field and press OK
  3. Hovering over the original Customer table shows that it is ‘Table 25 – Customers,’ and the alias table is ‘Table 6 – Customer2’
  4. Select ‘Database’ from the top menu, and select ‘Filelist Explorer’
  5. The Filelist Explorer shows that Customer2 is an alias for the Customer table because they share the same root name.
  6. Double click ‘Customer.vw’ from the Workspace Explorer on the right
  7. Open the Class Palette window by clicking its icon in the top tool bar, and drag-and-drop a button into the view

  8. Click on the button to view its code
    1. Add some code to the OnClick method to perform two Find gt in the Customer table to find the second row in the table
    2. An open statement has to be added for Customer2 because it has not been opened in this view, which was designed to only view the original Customer table 
    3. Add a single Find gt in the Customer2 table to find the first row in that table
    4. Add a breakpoint to the End Procedure line
  9. Run the program, and open the Customer view by selecting ‘Customer Entry View’ from VIEW in the top menu
  10. Perform a manual find for any row other than the first two and click the button, which will pause the program at the breakpoint placed at the End Procedure line
  11. Add Watches to inspect the global record buffers for the Customer and Customer2 tables and the local Data Dictionary buffer for the Data Dictionary in this view  
    • Each of these buffers can hold a separate record from the same Customer table
  12. The Tables window now shows two Customer tables listed; both the Customer table and the alias table are listed by the tables root name ‘Customer.’ They can be differentiated by their table numbers.