Omnis classic with sqlite

Phil (OmnisList) phil at pgpotter.co.uk
Mon Jun 27 21:51:14 UTC 2022


Martin,

Oh if your in need of O7 pdf documentation, I'm sure I have a copy of 
many of the PDF's available at the time...

A couple of them I believe are on the FTP site in /Omnis7/7381/Doc
so, ftp.omnis.net no user or password...

regards
Phil Potter
Based in Chester in the UK.

On 27/06/2022 21:16, Doug Easterbrook via omnisdev-en wrote:
> hI martin:
>
> this is the basis of my premise:      Omnis 7 can’t talk to SQL lite.  It can talk to ODBC (which can talk to sqllite), but only through the V2 dams.
>
> ergo, if you need to write to a V2 dams, using that interface, then you may as well use postgres as the datbase.   and I know that there are listers that are using omnis 7 and talking to postgres.
>
>
> All my omnis 7 documentation is paper (books) … and they are filed away deep in the basement.  I don’t know if there is any available in PDF format —  might be that you can ask fellow listers for a PDF version, if you don’t have any at all.
>
>
> Whats the general difference between V2 and V3 dams.     V2 is built it your self.  do logins, create connections and statement object.   build your own sql.   read the database.  update it — using SQL statements.
>
> I tried to do it with our omnis 7 code some 20 odd years ago, thinking I’d try be compatible with our studio version we were building.  I got connected, did an sql statement to prove it worked...  but then gave up — because I realized that didn’t want two code bases.
>
>
> so, I know it is possible
> you’ll have to find the documentation (or maybe somebody has it)
>
> and ask some fellow listers who have done it for some sample login code.
>
> Doug Easterbrook
>
>> On Jun 27, 2022, at 10:31 AM, Martin Obongita via omnisdev-en<omnisdev-en at lists.omnis-dev.com>  wrote:
>>
>> 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.
>>
>>> 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.
>>>
>>>
>>>> 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.
>>>>
>>>>


More information about the omnisdev-en mailing list