General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only