Weird SQL error message

Das Goravani goravanis at
Thu Feb 3 17:03:34 UTC 2022

I’m getting a weird error message when trying to do simple SQL.

I am searching my "states" database for the states of Denmark for example.

I am getting this error message in NATIVETEXT:

ERROR:  column "Denmark" does not exist
LINE 1: ...tate_type" FROM "fcstates"   WHERE state_country = "Denmark"

It says "column" Denmark does not exist.

Denmark is not a column, it’s a value for the "state_country" column, it’s a search value, not a column name.

The error comes up from this line of code:

Do plist.$select(pwhereclause) Returns #F

plist is a reference to a list name, which is in an instance variable from the JS form. 

pWhereClause equals: WHERE state_country = "Denmark"

This code and this search have worked much before in window versions of the same application. 

I am logging on in my remote task construct. I have my session object and statement object variables in the remote task so that they are there for the JS forms to use. 

I don’t get what to do with this error message. It seems wrong. 

Any ideas?


More information about the omnisdev-en mailing list