postgresql fails on sqlite

Martin Obongita martin.obongita at yahoo.com
Wed Jul 27 12:27:33 UTC 2022


 Thank you PhilI have seen the source of the error.I was reading in a sqlite data that had its folder address changed.


    On Wednesday, July 27, 2022 at 02:00:32 PM GMT+3, Phil (OmnisList) <phil at pgpotter.co.uk> wrote:  
 
 Martin,

Just something to check...

is the table class prefix the same for sqlite and postgres?

regards
Phil Potter
Based in Chester in the UK.

On 27/07/2022 11:18, Martin Obongita via omnisdev-en wrote:
>
> Hi all,
> I have the below SQL statement that fetched data in Postgresql.This loads data with no problems.But the same method will not fetch data from an SQLite database.
>
> Begin statement
>
> Sta:Select *
>
> Sta:From [pTableClassPrefix]emailpref_detail
>
> If pClassPrefName<>'AllTableClassPref'
>
> Sta:Where [pTableClassPrefix]class= @[pClassPrefName]
>
> End If
>
> Sta:Order By [pTableClassPrefix]order_linenum
>
> End statement
>
> Get statement iSqlStmt
>
> If iStatementRef.$prepare()
>
> Do iStatementRef().$execute()
>
> Do iStatementRef.$fetch($cinst,kFetchAll)
>
> Else
>
> Do $cinst.$sqlerror()
>
> End If
>
> Could someone spot why this code does not work with SQLite/
> Rgds,Martin.
>
> _____________________________________________________________
> Manage your list subscriptions athttps://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