Monday, July 15, 2019
Tip of the Day: Limiting the Check Screen to Error Results with R:Scope
Product.......: R:Scope X.5 and R:Scope X.5 Enterprise (Version 10.5)
Build.........: 10.5.1.30707 or higher
Sections......: Checking Structure, Checking Data
When checking data and structure for tables with R:Scope, the details
displayed in
the Check Screen can include a great deal of output for large
databases. Having to
search/scroll through the list can take quite a bit of time.
As such, a "Display Errors Only" check box has been added to the
"Select Table(s)..."
dialog, to limit the Check Screen output to tables where errors are
encountered.
The output for checking Data and Structure would then only include errors.
For each table, R:Scope checks the following:
. Whether the table is a table (positive number of rows), a view, a
dBASE file, an
attached SERVER table, or a SYSTEM view.
. Each row width should be between 2 and 16,384 words.
. The number of columns for the table is no more than 2,048.
. The column number for the first column in the table is between 1 and the
maximum value for the version of R:BASE being used.
. The starting pointer is between 0 and the current size of the data file.
. The ending pointer is between the first row pointer and the size
of the data file.
. The total row length for all columns in a table must equal the
value stored in
the Table block of the structure file.
For each column, R:Scope checks the following:
. Data type validity.
. If a column is data typed TEXT, the length must be between 1 and
1500 bytes.
. The word offset for a table's first column should be 1. The word
offset for each
remaining column should equal the previous column's length in
words plus the
offset of the previous column.
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/201907151308.x6FD8Jx0006516%40atl4mhob15.registeredsite.com.
For more options, visit https://groups.google.com/d/optout.
