Weird SQL error message
goravanis at gmail.com
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.
More information about the omnisdev-en