postgresql fails on sqlite

Phil (OmnisList) phil at pgpotter.co.uk
Wed Jul 27 13:04:56 UTC 2022


Glad you resolved it, but not sure I had much to do with that.

regards
Phil Potter
Based in Chester in the UK.

On 27/07/2022 13:27, Martin Obongita via omnisdev-en wrote:
>   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 athttps://lists.omnis-dev.com
> Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com  
>    
> _____________________________________________________________
> 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