Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

Roundtable 9.x

SYMPTOM(s):

Adding SQL-92 views to Progress 9 database messes up Roundtable Integrity check report

Database Integrity check report gives:"
Checking table: <table-name>
Table: <table-name> is not in Progress Dictionary. "

The name of the SQL-92 views is the same as the progress database table names

CAUSE:

Seems to be a Roundtable bug.
Roundtable seems to search in the VST using FIND without FIRST and without checking the ._tbl-type (T- for tables, V-for views).
This means that will return an error because is ambiguous .
Roundtable check only if available _file, and because is not available will display in the report :
"
Checking table: <table-name>
Table: <table-name> is not in Progress Dictionary.
"

FIX:

Create SQL-92 views with names different than database table names.