Advantage Developer Zone

 
 
 

Advantage Knowledgebase Item




Ref No:
130501-2609
Last Modified:
Monday, May 06, 2013
Product:
Advantage Delphi ( General )
Category:
Error Codes
Title:
Error 5170 Returned when Pre 8.1 Delphi Client Attempts to Reindex a Table With Triggers on 8.1 or Newer Server
Problem Description:
After adding a trigger to a table or modifying an existing trigger using the Advantage 8.1 or newer server (either REMOTE or LOCAL) and attempting to re-index the table with a pre 8.1 client using Delphi (i.e. TAdsDataset version 7.1), the following error is returned:
5170 AE_DATABASE REQUIRES_NEW_SERVER
Solution:
Upgrade the client to 8.1 or later.

When using a pre 8.1 client the following workaround will correct this situation.
In Delphi, ensure that after the table is open to reset the AdsTableOptions.AdsIndexPageSize to 0 prior to calling AdsReindex.
Was This Item Helpful?