Hi Ton,
There are some weird issues with OS 9 standalones accessing a MySQL
database. I'm not exactly sure where the problem lies, but it seems
to be with the standalone builder itself, which makes sense since
everything works fine in the IDE and not in the standalone.
I had a similar problem a few months back, and if I remember
correctly, what you have to do is manually select your inclusions and
under database support select MySQL *and* Valentina. I know, it
sounds stupid, but it works. For some strange reason, database
support on OS 9 is linked to the Valentina xcmd, and if you build
your standalone without it, nothing works. So you end up with an
extra file in your distribution that wouldn't normally be necessary,
but right now it's the only way to make it work. This has already
been reported (#2613 in Bugzilla), and will hopefully be fixed soon.
HTH,
Chris
On Aug 1, 2005, at 1:04 PM, Ton Kuypers wrote:
What's going on, what am I missing here?
I've created a database frontend which needs to run on Windows,
2000 WIndows XP, Mac OS9 and Mac OS-X.
All run perfect except the Mac OS9 version...
I have a splash screen with some minor scripts in the preopenstack
and startup handlers. In the on opencard script I load some
parameters and call a script in another stack. (All basic SQL-
generating scripts are located in that stack, all in buttons, so
it's very easy to manage and edit them. I use properties in the
stack to pass parameters around and maintain parameters per session.)
The script I need to run is in the mouseup handler of button
"connectToDB".
I use the "revOpenDatabase" command with all parameters and the
result is a number, the connection ID.
When there is no error in connecting to the mySQL database, I
continue to the "Login" substack so a user can enter its username
and password.
Hitting the enter button should then set a property of the stack
with the name & password and send a mousup to a second button,
which checks if the user may or may not login.
The first part (getting the connection ID works fine on OS9, but
when I'm in the second script, the "revOpenDatabases()" return
empty and I get the error "revdberr, invalid connection id", so
nothing works :-((
When running it inside revolution on OS9 it's OK, so are all other
runtimes, just the OS9 runtime doesn't work.
Anybody any suggestions?
Regards,
Ton Kuypers
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
------------------------------------------
Chris Sheffield
Read Naturally
The Fluency Company
http://www.readnaturally.com
------------------------------------------
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
