Can't open sqlite disk file in XP standalone

[Peter Haworth]

So what ends up in PrefsDB?  Not sure what you mean by "causes an error
rather than returning an error code".

Don't know if this might help, but I always check the db file exists (if
there is a file PrefsFilNam) before opening any sqlite database, just too
error prone without doing that.

On Sat, Mar 7, 2015 at 11:40 AM Dr. Hawkins <dochawk at gmail.com> wrote:

> I'm in odd waters at the moment, on XP (which is left over on a FreeBSD
> laptop; I've never actually owned a windows machine, ever . . .)
>
> Anyway, this application has compiled and run as a mac standalone for
> years, and as a windows standalone compiled mac-side at some point in the
> past.
>
> I have a three line sequence
>
>    answer "trying to open " & prefsFilNam
>    put revOpenDatabase("sqlite", prefsFilNam , , , , )  into prefsDb
>    answer "got: " & prefsDb
>
> The directory in the pathname exists, and actually gets successfully
> created a few lines previous if it doesn't exist (i've removed to check
> this).
>
> OK, it's a bug, bug 14838 <http://quality.runrev.com/show_bug.cgi?id=14838
> >
> that I just filed.
>
> The dlls are not landing where the should, as set out in the bug text
> below.
>
> Is there a way to work around this until its patched?  Move files (I've
> tried putting the dlls in the same directory as the executable, and putting
> the folder of them there, to no avail.
>
>
> The standalone compiles and places revpdfprinter.dll and
> revsecurity.dll in the same folder as the executable.
>
> Also created is an "externals" folder containing revdb.dll and folder
> database_drivers, which in turn contains dbpostgresql.dll and
> sqlite.dll (the two types selected in standalone settings).
>
> Nonetheless, revOpenDatabase() causes an error (rather than returning
> an errorcode).
>
> The code works without problem in the IDE on both mac and windows, and
> has worked in mac executables for years.
>
>
>
>
>
>
>
> --
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> _______________________________________________
> 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
>