Simple SQL Question

Reg Paling reg.paling at lokanet.com
Wed Oct 26 20:49:28 UTC 2022


Hi Das,

Try this:

SELECT top 1
CC_SEQ,CC_CREDIT_NUM,CC_TOKEN
FROM cust_cc
WHERE CC_CCODE=@[iRowCust.CCODE]
AND CC_CURRENT=1
order by CC_SEQ

Kind regards,
Reg

On Thu, Oct 27, 2022 at 7:16 AM Max Hattenback <maxh at carrubba.com> wrote:

> 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]
>
>
> _____________________________________________________________
> 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