postgresql fails on sqlite

Martin Obongita martin.obongita at yahoo.com
Wed Jul 27 13:16:57 UTC 2022


No worries.I was thanking you for your time.Many in here read my post but were too busy to reply.


Sent from Yahoo Mail on Android 
 
  On Wed, 27 Jul 2022 at 16:05, Phil (OmnisList)<phil at pgpotter.co.uk> wrote:   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  
_____________________________________________________________
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