We can encrypt/decrypt/restructure it with TADSTable in not Server-Side Alias dictionary. In Server-Side Alias dictionary we cannot do that.

We use a free table for a higher security than an admin.

We can detect some problem but sometimes we can not fix it.
- a memo corrupt: we must export to a new table
- an invalid date: we must edit it
- an invalid value: we cannot restructure it if an invalid value found in two or more field. we must edit it one by one before restructure it Or we must use FoxPro to restructure it.

// detect table's problem
TRY
DROP TABLE #tmp;
CATCH ALL
END;

SELECT * INTO #tmp FROM any_table;

// detect field's problem
TRY
DROP TABLE #tmp;
CATCH ALL
END;

SELECT any_field INTO #tmp FROM any_table;

// detect record's problem for particular field
TRY
DROP TABLE #tmp;
CATCH ALL
END;

SELECT TOP x any_field INTO #tmp FROM any_table;

It show only for 'Browse for Directory...' connection, not for 'Browse for Dictionary File...' connection.
I request the same feature for 'Browse for Dictionary File...' connection.

Please, don't decline my feedback

Vote it