postgresql fails on sqlite

Phil (OmnisList) phil at pgpotter.co.uk
Wed Jul 27 11:00:25 UTC 2022


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  


More information about the omnisdev-en mailing list