Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Here what I got after your response. I am still doing some wrong.
lcNdxStr = 'INDEX ON ' + ALLTRIM(indextable.indexexp) + ' TAG ' + ALLTRIM(indextable.ctag) + ALLTRIM(region.c_region_id). This create INDEX ON ALLTRIM(indextable.indexexp) TAG ORGTWN. However my problem is when I go to add the for statement. What I need to happen is that it say FOR indextable.indexfilt = Alltrim(region.c_region_id). The For statement is based on what is stored in indextable.indexfilt that the field in the table (such as c_region) and the other portion to the right of the equal is stored in region.c_region_id. I hope I've made myself clear.
Thanks
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement