Defined a client-only index for a MySQL table.

When defining in stuidio, everything went apparently fine.. .int file was properly updated..

but when running app, and the "index" is used..

Code:
...\Programs\WebApp.exe
Erro genérico HY000 (1176)--[MySQL][ODBC 5.3(w) Driver][mysqld-5.7.10-log]Key 'hymn_subcategory_ix002' doesn't exist in table 'hymn_sub_category'  Table = hymn_sub_category (6), Source = ODBC_DRV.Find
Erro número: 12289 linha: 5873.


GET_FINDBYROWIDEX (1761) - ohymn_category_DD (172) - at address 5873
MSG_NAVIGATEFORWARDFINISH (6970) - oZoomCategory (171) - at address 27839
MSG_NAVIGATEFORWARD_CALLBACK (6967) - oZoomCategory (171) - at address 27649
MSG_SHOWVIEW (6382) - oWebApp (23) - at address 22634
MSG_NAVIGATEFORWARD2 (6968) - oZoomCategory (171) - at address 27730
MSG_NAVIGATEFORWARD (6962) - oZoomCategory (171) - at address 27557
MSG_PERFORMNAVIGATEBYINVOKINGOBJ (5734) - oCategorySelection (114) - at address 20882
MSG_PERFORMNAVIGATEBYINVOKINGOBJ (5734) - oList (122) - in native code
MSG_PERFORMNAVIGATEBYINVOKINGOBJ (5734) - oDetailButton (127) - in native code
MSG_NAVIGATEPATH (5809) - oDetailButton (127) - at address 17925
MSG_ONCLICK (6460) - oDetailButton (127) - at address 36768
GET_HANDLEACTION (5779) - oDetailButton (127) - at address 17425
MSG_CALL_ACTION (5679) - oWebApp (23) - at address 21077
MSG_PROCESSREQUEST (5665) - oWebApp (23) - at address 16528
MSG_ONHTTPPOST (5631) - oWebServiceDispatcher (46) - at address 28635
MSG_ONHTTPREQUEST (5448) - oWebServiceDispatcher (46) - at address 15983
MSG_HANDLEHTTPREQUEST (5411) - oWebServiceDispatcher (46) - at address 16021
MSG_ONHTTPREQUEST (5448) - oVDFInetSession (25) - at address 14837
MSG_STARTWEBAPP (5655) - oWebApp (23) - at address 16380
[start] - at address 37234

Yes, the error message is 100% correct. the index does not exist at db.. it's a client-only index.. why driver is querying index info , and raising an error for a client-side index ?


int section:
Code:
INDEX_NUMBER 2
INDEX_NAME hymn_subcategory_ix002
INDEX_NUMBER_SEGMENTS 2
INDEX_SEGMENT_FIELD 2
INDEX_SEGMENT_FIELD 1

I need a workaround, or an urgent fix.. I can't create the index at the database.