Weird SQL error message

TBS andyh at totallybrilliant.com
Thu Feb 3 17:05:59 UTC 2022


Das

Quote marks within text blocks have long been a cause of issues !!

Try replacing your double quote marks with single quote marks…...

Andy Hilton
Totally Brilliant Software Inc
Phone (US) : (863) 409 4870
Phone (UK) : 0207 193 8582
Web : www.totallybrilliant.com
Helpdesk : http://totallybrilliant.kayako.com
Email : andyh at totallybrilliant.com
On Feb 3, 2022, 12:04 PM -0500, Das Goravani <goravanis at gmail.com>, wrote:
>
> 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?
>
> Das
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com


More information about the omnisdev-en mailing list