Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating Index String
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00587680
Message ID:
00587728
Views:
24
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
Map
View

Click here to load this message in the networking platform