Column not found / specified (7520) + progress

[gabrielk10]

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

 

[Stefan]

What is the datatype of um_part?

The following should be sufficient (no idea about 9.1D, but it is on 10.2B):

SELECT * FROM pub.um_mstr WHERE um_part = 123

If um_part is a character field use single quotes to indicate the value:

SELECT * FROM pub.um_mstr WHERE um_part = '123'

 

[gabrielk10]

The field is a string(8), i tried with the single quotesand already is running without error. Im using Visual Basic and this is the query:

"SELECT UM_PART, UM_UM, UM_ALT_UM, UM_CONV FROM pub.UM_MSTR WHERE UM_UM='KG' AND UM_PART=" & "'" & CStr(RsPARTIDA!SOD_PART) & "'" & " AND UM_ALT_UM=" & "'" & CStr(RsPARTIDA!SOD_UM)

Thanks Stefan.
Best regards