on 7/19/03 12:14 AM, Simon lord wrote > Hi all, I need to write an app that will allow me to read/write data to > MySQL. I'd like to tinker with this on the weekend and I've seen it > mentioned here a few times but was not in the market to use such a > combination. > > That said, can some kind sole provide me with the following: > > 1) Information about what I need in order read/write to MySQL > 2) A sample stack (I can change the MySQL table calls) just so get a > frame of reference > > This would be much appreciated, I look forward to playing with it.
If it's not too off-list-topic - it must be worth mentioning that support for this is "built in" to Revolution (that is, Rev is supplied with a library which 'just works', and which you can then have built into your standalones). There's a straightforward set of routines which allow you to connect to the database, make queries, execute SQL etc. In Rev 2 there's also a point and click interface layered on top of this, which doesn't do everything you want, but makes it straightforward to for example with a few clicks add to a card a table field which is automatically updated (eg each time the card is opened - configurable) with the columns you select from a SQL query to a MySQL or various other databases. (The full list is that it supports MySQL, Oracle, PostgreSQL and Valentina natively; plus many others via ODBC.) AFAIK, you can do this is in the free edition - there are some extra limitations (beyond the standard script-length one) about number of non-ODBC databases you can have open unless you go for the full "Professional" license. I might be wrong about that - in fact I just took a look at the runrev site, and I get the impression that they're just about to shake up their license options. By the looks of it, the changes will be more favourable if you just want MySQL. Anyway, I'd definitely suggest it was worth a try with the free edition. I'd be pretty sure it was the simplest way to achieve what you want: of course you need to set the extra effort involved in other ways to achieve it with vanilla MC against what it might cost to cross-grade to Rev. Hope this helps, Ben Rubinstein | Email: [EMAIL PROTECTED] Cognitive Applications Ltd | Phone: +44 (0)1273-821600 http://www.cogapp.com | Fax : +44 (0)1273-728866 _______________________________________________ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/metacard