Accessing Databases using RunRev

[Bill]

Rev's built in query builder does a lot of what you need except it won't
allow you to insert a record, delete a record, or move through records in
SQL using joins to other tables (which sucks). But otherwise it is great and
there are a couple undocumented features that are very useful especially

 revSetSQLOfQuery "Connect",tSQLStatement (this is great for working with
the query builder)

Then there is Trevor's library which allows you to do everything else that
is missing in the query builder. Altuit has an excellent help stack for
their SQLite which is you should try right now if you haven't already. It
would be perfect if it used Trevor's library and showed how to do everything
with that.

So - in my opinion what is needed is a stack that teaches how to use the
query builder and Trevor's library -- this stack would have all the things
we need built in it ready for copy and paste to new projects. For example I
need a SQL search function that will bring up a list from a field in a table
based on letters you type in a  search field and do it quickly and narrow
down the search in front of you as you type more letters. I also need a
simple function to build pop-up pick lists from a database SQL on a field.

If you were using Trevor's library for the stuff that you are writing I
would love to see your examples. I am a cut and paste programmer (I guess
that means I'm not really a programmer but a mash-up guy instead) and clear
examples that I can understand and modify are the life blood.

A copy of the excellent Altuit help stack that had a window in the beginning
for describing which database you are going to use (SQLite, MySQL, Valentine
etc) and that used Trevor's library would be absolutely cool (and Altuit
might even allow people to do it). I would like to be able to switch between
SQLite and MySQL with just one simple change for any project that I am doing
(and as easily try Valantine too). If you could switch from one database to
another easily you could test to see which is faster for the project your
building (for example).

The latest RunRev release is also very stable using the query builder.


On 6/1/06 11:14 PM, "Josh Mellicker" <josh at dvcreators.net> wrote:

> I have been working on a database front end in Rev, and in most ways
> have been happier than any other solution I've worked in. It is fast
> and reliable.
> 
> To state the obvious, I miss some things about a dedicated database
> development environment like FileMaker, but I have been slowly
> developing writing a library of functions that are increasingly
> serving as an easy and powerful layer between:
> 
>   - a card with a scrolling group of individual groups of controls,
> each subgroup representing a record in the database
> 
>   - a remote MySQL database
> 
> For example, I have a function that populates a field or option menu
> with some text data from a series of records, then sets a custom prop
> of the control to a list of the database IDs, so when the user
> selects a line in the field of an option from the menu, the database
> ID of that record is immediately accessible, yet invisible to the user.
> 
> (I feel certain I am reinventing the wheel at every step!)
> 
> I realize this is an obvious and rudimentary example, but it would be
> cool if there were a whole bunch of these functions that were
> invisible to the developer.
> 
> I know Sarah and Trevor and many others have written stacks and
> libraries that I am gradually becoming aware of, and Rev even has a
> built-in Query Builder that I just either don't like or don't get,
> but I have not found the ideal solution for being able to whip
> together a multiuser shared data solution with several cards in about
> as much time, and in as intuitive a process as FileMaker... but
> superior to FileMaker in power and flexibility and multi-user
> options, where controls hook up to their corresponding database
> records invisibly, where things like record IDs and complex JOIN SQL
> syntax are mostly invisible to the developer.
> 
> So, to summarize all this rambling, it's clear a Rev library could be
> written that made 90% of the common things people need to do with a
> shared database easy and intuitive... and then jumping in to script
> the other 10% could be done by a specialist.
> 
> If anyone has done this already or wants to plan out a library
> everyone could contribute to, let me know!
> 
> :-)
> 
> On May 31, 2006, at 8:35 AM, Jonathan Lynch wrote:
> 
>> 
>> I have thought of another method, using only enough rows to be
>> visible in
>> the table, and storing all the rest of the data in custom props -
>> then, when
>> you scroll, it would actually just reassign the information in each
>> row.
>> Such a thing would be tough to implement so that it actually looks
>> like
>> normal scrolling, but I think it could be done.
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution

            |    |    |
           )_)  )_)  )_)
          )___))___))___)\
         )____)____)_____)\\
       _____|____|____|____\\\__
-------\                   /--------- http://www.bluewatermaritime.com
 ^^^^^ ^^^^^^^^^^^^^^^^^^^^^
  ^^^^      ^^^^     ^^^    ^^
       ^^^^      ^^^

24 hour cell: (787) 378-6190
fax: (787) 809-8426

Blue Water Maritime
P.O. Box 91
Puerto Real, PR 00740