revOpenDatabase acting differently in IDE and standalone

Mike Bonner bonnmike at gmail.com
Tue Apr 30 22:59:35 EDT 2013


Sounds like something is up with the external for postgres standalone
building.  You might look in the installation folder for LC 6+, find the
tools/runtime/windows/x86-32/externals folder, look at the file
externals.txt and see if it looks right, then also look in the database
drivers folder and make sure dbpostgresql.dll is there like it should be.
(if you're still on 6.0 even, working in windows there is a chance its not
there.. quite a few externals were non-functional in 6.0 windows, but have
since been fixed in 6.0.1 I think)

Of course do this for whatever platform you're building for. Make sure the
external is there for the runtime build. If its not you can look elsewhere
in the tree to see where the IDE is grabbing it from. (of course if you're
on a mac, and building for windows there may be no fix except to get 6.0.1)

Of course i'm using community, things may be different with 6.0 commercial.
Its worth a check anyway.


On Tue, Apr 30, 2013 at 8:40 PM, Dr. Hawkins <dochawk at gmail.com> wrote:

> I have lost about 20 hours to this now.
>
> My whole application runs and functions just fine in the IDE.  The
> standalone, however, is having problems.
>
> It seems that both sometimes globals aren't properly global, even when
> declared in a substack, and tthat revOpenDatabase acts differently.
>
> I have a command ck that takes a string and outputs it.  Currently, it puts
> it in a log window and also in an answer to get as close as I can to
> single-stepping the standalone
>
>  ck "postgresql , "  & dhbkSrvr &  ", dhbk_dbtrs, " & dhbkDbUsr & ", "
> &dhbkDbPw
>             put revOpenDatabase("postgresql",dhbkSrvr,
> "dhbk_dbtrs",dhbkDbUsr,dhbkDbPw) into dhbkSrvrDb
>             ck "got " & dhbkSrvrDb
>
> In the IDE, I generally get "got 11" as the response (other sqlite dbs have
> been opened).
>
> In the standalone, I get
> postgresql, sharpshin.local, dhbk_dbtrs, ,
> got revdber,invalid database type
>
> (the first line is the same as I get in the IDE).
>
>
> I've reverted to 5.5.4, as 6.0 was giving other strange results.
> --
> 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
>



More information about the use-livecode mailing list