gabrielk10
New Member
HI, i have a problem and i need help with an ODBC errror, im working with Merant 3.6 and Progress 9.1D . I have this queries
"SELECT * FROM pub.UM_MSTR ORDER BY UM_PART "
"SELECT pub.UM_MSTR.UM_PART,pub.UM_MSTR.UM_UM,pub.UM_MSTR.UM_ALT_UM,pub.UM_MSTR.UM_CONV FROM pub.UM_MSTR"
this works fine. but if i use WHERE :
"SELECT * FROM pub.UM_MSTR WHERE pub.UM_MSTR.UM_PART=value" or
"SELECT pub.UM_MSTR.UM_PART,pub.UM_MSTR.UM_UM,pub.UM_MSTR.UM_ALT_UM,pub.UM_MSTR.UM_CONV FROM pub.UM_MSTR WHERE pub.UM_MSTR.UM_PART=value"
with this sentences sends an error message :"COLUMN NOT FOUND / SPECIFIED (7520) + PROGRESS" . Can you help me with this, please?.
"SELECT * FROM pub.UM_MSTR ORDER BY UM_PART "
"SELECT pub.UM_MSTR.UM_PART,pub.UM_MSTR.UM_UM,pub.UM_MSTR.UM_ALT_UM,pub.UM_MSTR.UM_CONV FROM pub.UM_MSTR"
this works fine. but if i use WHERE :
"SELECT * FROM pub.UM_MSTR WHERE pub.UM_MSTR.UM_PART=value" or
"SELECT pub.UM_MSTR.UM_PART,pub.UM_MSTR.UM_UM,pub.UM_MSTR.UM_ALT_UM,pub.UM_MSTR.UM_CONV FROM pub.UM_MSTR WHERE pub.UM_MSTR.UM_PART=value"
with this sentences sends an error message :"COLUMN NOT FOUND / SPECIFIED (7520) + PROGRESS" . Can you help me with this, please?.