SE: restore default handlers?

Ralph DiMola rdimola at evergreeninfo.net
Wed Feb 7 13:56:38 EST 2018


Mike,

Yes, the DBID will increment and the DB will be opened multiple time. I have
SQLite DBs open in the IDE while testing and open in MS Access via ODBC at
the same time. If both apps are reading then no problem. There is no real
good transactional record locking in SQLite. LC will throw an error if you
are  even reading the record in another program at the same time as an
update happens in LC. You can use these LC errors to do a retry for the
update.

Ralph DiMola
IT Director
Evergreen Information Services
rdimola at evergreeninfo.net

-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On Behalf
Of Mike Kerner via use-livecode
Sent: Wednesday, February 07, 2018 1:44 PM
To: How to use LiveCode
Cc: Mike Kerner
Subject: Re: SE: restore default handlers?

@Bob are you sure that's true?  I seem to recall being able to accidentally
reopen the db over and over without an error.  I can't remember if the dbid
increments when I do this, but I think it does.

On Wed, Feb 7, 2018 at 11:04 AM, Bob Sneidar via use-livecode <
use-livecode at lists.runrev.com> wrote:

> Of course, sqlite DBs are single user only so any attempt to open it a 
> second time would fail. Just tossing that out there.
>
> Bob S
>
>
> > On Feb 6, 2018, at 11:30 , panagiotis merakos via use-livecode <
> use-livecode at lists.runrev.com> wrote:
> >
> > Thanks Richard. So, a guess is that for some reason LC cannot open 
> > the sqlite database that holds all the dictionary entries, thus it 
> > cannot
> fetch
> > the list of the default handlers per object. I am wondering if this 
> > is related to the other bug report you have filed, where the 
> > dictionary
> opens
> > but it is empty for you.
> >
> > Let's delete the Documentation Cache:
> >
> > 1. Quit LC 9.0.0 DP-11
> > 2. Delete folder: .runrev/documentationcache/9_0_0_dp_11_commercial/
> > 3. Open LC
> > 4. Check if the default handlers appear now.
> >
> > Best,
> > Panos
> > --
> >
> >
> >
> > On Tue, Feb 6, 2018 at 7:03 PM, Richard Gaskin via use-livecode < 
> > use-livecode at lists.runrev.com> wrote:
> >
> >> panagiotis merakos wrote:
> >>> I cannot reproduce this, tested on Ubuntu 16.04 with LC 9 DP-11.
> >>>
> >>> Could it be the case that there is a bad interaction with a Plugin?
> >>>
> >>> What happens if you try first to "put true into grevdevelopment" 
> >>> and then uncheck and recheck "Show Default handlers"?
> >>>
> >>> If something was failing silently before, this should now throw an 
> >>> error.
> >>
> >> Thanks.  Indeed it does - this is what I get pouring into the 
> >> Message
> Box:
> >>
> >>
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >>
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >>
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >>
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >>
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >>
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >> ERROR: unable to open database
> >> unable to create sqlite API database revdberr,invalid database type
> >> line: 1079
> >> handler: ideThrow
> >> script object: stack "/home/rg/.runrev/components/l 
> >> ivecodeindy-9.0.0-dp-11.x86_64/Toolset/libraries/revidelibra
> >> ry.8.livecodescript"
> >>
> >>
> >> --
> >> Richard Gaskin
> >> Fourth World Systems
> >> Software Design and Development for the Desktop, Mobile, and the 
> >> Web
____________________________________________________________________
> >> Ambassador at FourthWorld.com                http://www.FourthWorld.com
> >>
> >> _______________________________________________
> >> use-livecode mailing list
> >> use-livecode at lists.runrev.com
> >> Please visit this url to subscribe, unsubscribe and manage your 
> >> subscription preferences:
> >> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



--
On the first day, God created the heavens and the Earth On the second day,
God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
_______________________________________________
use-livecode mailing list
use-livecode at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode





More information about the use-livecode mailing list