gabrielk10
New Member
Hi, i have a problem with array fields , i would to access in a array field named "cmmt" , This field content 15 arrays , but i just need consultings the first and second arrays with a SQL sentence like this:
SELECT CMT_INDX, CMT_CMMT[1], CMT_CMMT[2] FROM CMT_DET WHERE CMT_INDX= "VBCMTINDEX"
and send an error message [Datadirect-Technologies][ODB PROGRESS driver][PROGRESS] "Sintaxis Error (7587)"
but if i use this sentece, dont send an error however the application doesnt respond and i have to kill the process with the taskmanager of windows:
SELECT CMT_INDX, CMT_CMMT FROM CMT_DET WHERE CMT_INDX= "VBCMTINDEX"
Can you help with this?. Thanks.
Best regards...
SELECT CMT_INDX, CMT_CMMT[1], CMT_CMMT[2] FROM CMT_DET WHERE CMT_INDX= "VBCMTINDEX"
and send an error message [Datadirect-Technologies][ODB PROGRESS driver][PROGRESS] "Sintaxis Error (7587)"
but if i use this sentece, dont send an error however the application doesnt respond and i have to kill the process with the taskmanager of windows:
SELECT CMT_INDX, CMT_CMMT FROM CMT_DET WHERE CMT_INDX= "VBCMTINDEX"
Can you help with this?. Thanks.
Best regards...