OS Query Class versus PG Views

[Jeffrey Jones]

Character in the data that is not in your selected character set in Omnis. 

-Jeff

> On Aug 22, 2022, at 10:17 AM, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> Hi All,
> I have created the SQL statement below in Postgres:
> Begin statement
> Sta:select c05.c05_name as country_name, count(*)
> Sta:as total_countrybranch,
> Sta:array_agg(c10.c10_name)
> Sta:as countrybranch_name
> Sta:from c10_countrybranch_detail c10
> Sta:inner join c05_country_detail c05
> Sta:on c10.c10_parent_id=c05.c05_id
> Sta:group by c05.c05_name
> Sta:order by c05.c05_name;
> End statement
> I have tested in PG Admin and I get results successful.I have created the same SQL statement in an Omnis table class.If I fetch data to a list, I get an error in column BAD! BAD! BAD! BAD!I have never seen this scary message before.
> Please help.
> Kind regards,Martin.
> 
> 
>    On Sunday, August 21, 2022 at 10:33:29 PM GMT+3, TBS <andyh at totallybrilliant.com> wrote:  
> 
> Doug
> 
> Thats a fair point - but something I have got used to :)
> 
> 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 Aug 21, 2022, 3:29 PM -0400, Doug Easterbrook via omnisdev-en <omnisdev-en at lists.omnis-dev.com>, wrote:
>> I would use omnis queries and table classes.
>> 
>> In our app, we’ve for it set up so you can join as many tables as you want in a query and pick the fields you want.
>> 
>> and, being a little bit creative, we wrote our table classes so that you can update against queries (onl the main table, and not the joins)_. thats some thing you can’t do in sql. but its really convenient
>> 
>> 
>> 
>> why we avoid Postgres views: they are just something else to maintain. I’ve had issues altering fields in tables in the past when there are views that are dependant on it. you ave to drop the views and recreate them, so there is database maintenance — which is something you have to write into your upgrade routines because of the dependancy.
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> Doug Easterbrook
>> Arts Management Systems Ltd.
>> mailto:doug at artsman.com
>> http://www.artsman.com
>> Phone (403) 650-1978
>> 
>>> On Aug 21, 2022, at 7:16 AM, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
>>> 
>>> Hello to All,
>>> From your experiences, which is a more efficient way working with SQL queries, from within Omnis query classes or creating views in a postgres database?
>>> Rgds,Martin.
>>> _____________________________________________________________
>>> Manage your list subscriptions at https://lists.omnis-dev.com
>>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at https://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com