DB Inquriy is returning blank or partial results in the DataGrid
RecTrac 3.1.10.29.00
Table of Contents
Problem
Some DB Inquiry results for certain system tables (i.e. SATemplate, SAWaiver, SASnapshot, ect..) show blank or partial records in the results DataGrid.
Solution
When using DB inquiry on a table with Clob file data types, be sure to select all fields and deselect any field containing a Clob file.
Steps For Solution
- From the RecTrac main menu, go to DB Inquiry.
- Set Select Table To View to a table containing a Clob record. (i.e. SACache)
- Click Options > Select All Rows on the DataGrid.
- Deselect all rows that have a Type of Clob. (i.e LongValue is a Clob record)
- Click View.
This will provide the most complete view to the end user to see any problem records.