$select sql errors

Martin Obongita martin.obongita at yahoo.com
Sun Oct 2 18:26:53 UTC 2022


 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 
  


More information about the omnisdev-en mailing list