database issues

Chris Sheffield cm_sheffield at yahoo.com
Tue Aug 19 15:38:00 EDT 2003


I've been reading both Devin's and Jacque's posts, and
there is definitely something weird going on with
database access in Rev, especially when it comes to
built standalones.  So I have something I'd like
someone to verify for me and see if you get the same
results.  If so, I'm going to report this as another
database bug.

1) Create a new stack with two fields and two buttons
(or just get creative :-)

2) Open the database query builder and create a new
query to connect to a Valentina database (you can
download my database from
www.readnaturally.com/Internal/RNSE/data.zip).  Set
the path and all that, then click the Connect button. 
You should be able to connect okay.  You shouldn't
have to change anything on the Record Set tab.

3) Close the query builder and connect the fields and
buttons to the database.  Set field 1 to display first
name, and field two to display last name.  Set button
one to move to the previous record, and button two to
move to the next record.

4) Hit the browse tool and you should be able to move
back and forth between two different records.

5) Now for the fun.  Build a standalone and include
the database library.  Run the standalone and see if
the app connects to the database.  My guesses are that
it won't.

6) Try playing with the externals,
setDatabaseDriversPath, etc. and see if you can make
it work.  If you can, you're my hero and I'll be
eternally grateful for any input you can provide, but
you probably won't be able to.

The Rev docs say, and I quote,

"If you check the "Database Library" option in the
Distribution Builder, all the supporting scripts for
the Database Query Builder are included in the
application (although the Database Query Builder
window is not), along with the Database library
external. You don't need to do anything more to make
automatic database queries work in your application."

It sounds like part of this has been fixed as far as
the necessary scripts being included (thanks to
Jacque), but the part about not having to do anything
else to use automatic queries doesn't seem to be true.

I am experiencing these issues in both Windows and Mac
builds.  If someone has a bit of free time and can try
this out, I would greatly appreciate it.  I'm in the
same boat as Devin and really need to get this
working, and it sounds like to me that the issues are
related.

Thanks,


=====
Chris Sheffield
Read Naturally
www.readnaturally.com

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com



More information about the use-livecode mailing list