SQL 10.2

[Juan Bofill]

Trying to import from DML to SQLite and can not do it. Tried with and without the conversion tool dragging files from the Browser Sql sessions that are open. Must be doing something wrong.

Juan

> On May 2, 2021, at 9:23 AM, Juan Bofill <juanbofillaba at gmail.com> wrote:
> 
> Hi Martin
> 
> I must be doing something very wrong. I created a DML lib and data with two FILE formats and total 0f 12 records to 
> 
>> On May 1, 2021, at 8:31 AM, Martin Luce via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
>> 
>> 
>> 
>>> Begin forwarded message:
>>> 
>>> From: Martin Luce <martinluce at eclipse.co.uk <mailto:martinluce at eclipse.co.uk>>
>>> Subject: Re: SQL 10.2
>>> Date: 1 May 2021 at 11:10:35 BST
>>> To: Juan Bofill <juanbofillaba at gmail.com <mailto:juanbofillaba at gmail.com>>
>>> 
>>> Yes, that is what I have. but you have as one line
>>> Do $root.$devices.Screen.$visible.$assign(kTrue)Do $root.$prefs.$mapdmltodam. $assign("SQLITEDAM”)
>>> as one line. It should be 2 as
>>> Do $root.$devices.Screen.$visible.$assign(kTrue)
>>> Do $root.$prefs.$mapdmltodam. $assign("SQLITEDAM") 
>>> 
>>> 
>>> I also have the following which should not affect the conversion
>>> 
>>> Calculate $prefs.$printernotify as kPrtNoteNoMsg ## to stop printer message coming when user Returnｓ to omnis from another app
>>> Calculate $devices.PDF.$visible as kTrue
>>> 
>>> Have you set the library to dmiemulation to true OK (item 6 on the notes).
>>> 
>>> Is the note 7 showing you the conversion routine OK. During processing it does give you various things to look at
>>> 
>>> Martin
>>> 
>>>> On 30 Apr 2021, at 16:27, Juan Bofill <juanbofillaba at gmail.com <mailto:juanbofillaba at gmail.com><mailto:juanbofillaba at gmail.com <mailto:juanbofillaba at gmail.com>>> wrote:
>>>> 
>>>> 
>>>> Hi
>>>> 
>>>> Having problems with the build in conversion to SQLite. I put the code:
>>>> 
>>>> Add or uncomment in task $construct at the start
>>>> 
>>>> 1)  Do $root.$prefs.$scale.$assign(100)
>>>> 
>>>> 2)  Do $root.$prefs.$alwaysshowmainmenu.$assign(kTrue) ## Not available in 4.2? Should keep the menues
>>>> 
>>>> visable
>>>> 
>>>> 3)  Do $root.$prefs.$oldlistsearching.$assign(kTrue) ## search list correctly when highlighted
>>>> 
>>>> 4)  Do $root.$devices.Screen.$visible.$assign(kTrue)
>>>> 
>>>> Do $root.$prefs.$mapdmltodam. $assign("SQLITEDAM") 
>>>> 
>>>> In the $construct of the STARTUP task. Is that correct?
>>>> 
>>>> Thanks!
>>>> 
>>> 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com <http://lists.omnis-dev.com/>
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>