$select sql errors

Das Goravani goravanis at gmail.com
Sun Oct 2 20:37:55 UTC 2022


My answer to you today is my long post called "All About Table Methods"

Which is really my answer to "Why do we have two ways of doing SQL"

And I also cover SQL Error Method in the long post. 



> On Oct 2, 2022, at 2:26 PM, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> Hi All,
> I am also confused why we have two types of sql commands in Omnis:
> 1. Begin...End statement
> 2. Do iDataList.$select()... Do iDataList.$fetch()
> When is each one recommended for use?
> 
> 
> 
> 
>    On Sunday, October 2, 2022 at 09:19:31 PM GMT+3, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:  
> 
> Hi All,
> I was going through the archives looking for information on $select sql statement.
> (The documentation has scanty info)
> I found a 2014 discussion that is close to what I am looking for.
> O6 - $select()
> 
> 
> | 
> | 
> |  | 
> O6 - $select()
> 
> 
> |
> 
> |
> 
> |
> 
> 
> 
> The question I wish to follow up with this discussion is,
> How do I get or trap for sql errors in a select command with a where clause?eg:
> Do iDataList.$select('WHERE name = Martin')
> 
> Martin Obongita
> _____________________________________________________________
> 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 



More information about the omnisdev-en mailing list