Visual Basic 6 y Progress 9.1D with arrays fields

[gabrielk10]

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...

 

[tamhas]

I don't remember if it was introduced way back then, but check your manual for PROELEMENT()