SQL 10.2

[Juan Bofill]

With Omnis Studio 10.2 28632 , the “Convert data to RDMS tool” worked again. It did convert all de files to SQLITE but then the library is not working with the Prefs dmlemulation=ktrue. The prompt for data file asks to open the created SQLITE data but nothing happens. Trying to open a window causes Omnis to crash.

Juan

> On May 3, 2021, at 7:17 PM, Daniel Sananes via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> I could not do it either.
> A SQLite database was created but without any correct data or field and file names.
> Exporting DML tab-delimited files and importing to a manually created SQLite worked quick and flawless.
> 
> Daniel
> 
> -----Ursprungligt meddelande-----
> Från: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com <mailto:omnisdev-en-bounces at lists.omnis-dev.com>> För Juan Bofill
> Skickat: den 3 maj 2021 20:44
> Till: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>>
> Ämne: Re: SQL 10.2
> 
> 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 <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> 
>>>> <mailto: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>><mailto: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/> 
>>> <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> 
>>> <mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>>
> 
> _____________________________________________________________
> 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> 
> _____________________________________________________________
> 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>