Column not found/specified (7520)

[jmaynar8]

Hello

I am trying to perform a query in Visual Basic to our Progress 10 OpenEdge database. When I do a simple query (SELECT * FROM PUB.FILE1) it works fine. When I try to add a where clause to the query I get the error message (column not found/specified). The final query is

SELECT * FROM PUB.FILE1 WHERE InOrOut = True

Where InOrOut is a logical column in the table FILE1. I suspect the problem is the word True. Does anyone know how to specify a logical check through an ODBC connection.

Would appreciate any help anyone can provide. I would also appreciate it if you could copy any replies to JimMaynard@comcast.net so that I can get any answer as soon as possible.

Thanks in advance for any help.

Jim

 

[Casper]

Try:

SELECT * FROM PUB.FILE1 WHERE InOrOut = 1

(0 for false).

HTH,

Casper.

BTW you get an email when your question is answered unless you specify in your options that you don' t want to get an e-mail. (So didn't reply to your email acount).