Simple SQL Question

Max Hattenback maxh at carrubba.com
Wed Oct 26 20:16:26 UTC 2022


And then if it works in PG Admin but not in your app, you know the issue is related to your omnis variables / schemas ect and not an issue with the underlying SQL.
________________________________
From: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> on behalf of Max Hattenback <maxh at carrubba.com>
Sent: Wednesday, October 26, 2022 4:15 PM
To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Subject: Re: Simple SQL Question

Hey Das,
When i'm trying to debug SQL I always prefer to run it in an external SQL browser. (I use razor SQL but the one that comes with postgres, PG Admin works as well) If you run the query in PG Admin, it should give you the error directly and you can modify and re run it without dealing with the app interface, breakpoints ect.
________________________________
From: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> on behalf of Das Goravani <goravanis at gmail.com>
Sent: Wednesday, October 26, 2022 4:07 PM
To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Subject: Re: Simple SQL Question


I did what Alan suggested, looked good to me, but it didn’t work, so far
I am using Postgres
Studio 8.1
I tried using the upper case column names that they have in their schemas
I tried switching them all to lowercase

The statement object is good, the database is live and working


_____________________________________________________________
Manage your list subscriptions at https://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com

[https://carrubba-image.s3-us-west-2.amazonaws.com/logo_smaller.png]


_____________________________________________________________
Manage your list subscriptions at https://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com

[https://carrubba-image.s3-us-west-2.amazonaws.com/logo_smaller.png]




More information about the omnisdev-en mailing list