Omnis classic with sqlite

Martin Obongita martin.obongita at yahoo.com
Mon Jun 27 17:31:15 UTC 2022


Hi Doug,
Is there any change in the code if I use V2 dam to connect to postgres db?
Where in the library should I specify the dam?
Rgds,Martin.
Sent from Yahoo Mail on Android 
 
  On Mon, 27 Jun 2022 at 20:23, Doug Easterbrook via omnisdev-en<omnisdev-en at lists.omnis-dev.com> wrote:   hi Martin:

you can connect to Postgres in Omnis 7 (the approach is called V2 dam’s) …. so if you were going to do sqllite and write something to talk to the database, then I’d do the V2 dam and talk to postgres ..

then you’d get reliability, performance and what-not.



Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com <mailto:doug at artsman.com>
http://www.artsman.com <http://www.artsman.com/>
Phone (403) 650-1978

> On Jun 27, 2022, at 9:28 AM, Alain Stouder Omnis <omnis at smartway.ch <mailto:omnis at smartway.ch>> wrote:
> 
> It’s possible but not reliable.
> 
> You need a 32bit ODBC driver for SQlite and then you have to deal with accented chars via an Omnis 7 procedure since sqlite stores unicode chars.
> 
>> Learn something new every day !
> 
>> On 27 Jun 2022, at 18:23, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>> wrote:
>> 
>> Hi all,
>> There is an old Omnis 7 app that I have inherited that runs with .df1 database.
>> Is there a way to run .lbr files with sqlite database?
>> I'm thinking of exporting the data to excel then importing to sqlite while maintaining the same table structure.
>> Rgds,Martin.
>> 
>> Sent from Yahoo Mail on Android
>> _____________________________________________________________
>> Manage your list subscriptions at https://lists.omnis-dev.com <https://lists.omnis-dev.com/>
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com <https://lists.omnis-dev.com/>
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>

  


More information about the omnisdev-en mailing list