This ASP page demonstrates how to update a Clipper table and two of its NTX indexes using Apollo ASP.
The key is to call "SetTables" and list each table that will be used in the SQL statement as follows:
The following ASP/SQL code will be called:
oQuery.SetTables "CLIPPER.DBF", "Clipper", "ttSXNTX", "", FALSE, "CLIP1.NTX, CLIP2.NTX" oQuery.SQL = "Update Clipper Set HireDate = #' + cstr(Date) + '#" oQuery.ExecSQL oQuery.SQL = "Select First, HireDate From Clipper" oQuery.Open