Help! Diary-Appointment Book

[donslaven]

I am a total beginner. I am attempting to create a diary/appointment book using RevStudio and MySQL. I would like it to look something like and perform in a similar way to the appointment facillity in MS Outlook.

Any pointers as to where to start?

[Garrett]

I have no examples or code to offer you myself at this moment. Someone else might though. My only advice at the moment unless someone else comes along with something for you, is simply experiment at first with just one aspect of what you want to do.

Say at first, try playing around with the SQL stuff in Rev until you have an idea of what is going on with that and how you might be able to incorporate that into what you want.

And of course, along the way, come back here and ask lots of questions like I have been lately... *DoH!*

Hopefully someone comes along with some links or directions to some examples that'll help ya, cause what I got for ya is nothing right now

[donslaven]

Thanks. All and any contibutions greatfully accepted.

[SparkOut]

Trouble is, when you say you are a total beginner, it's a bit difficult to give you clues. You don't say whether you have no experience of computers at all, or whether you are a beginner with Rev, but come from a background in (say) web applications in php and javascript. Some knowledge of structures and computer procedures will be a kickstart to your learning process.
As a total beginner, think of your task of building an Outlook-style appointments application as that of a total beginner building a house, only you have to be the architect, surveyor and labourer too. You will need to know the how to design it so that your foundations will support what you build onto it. You will also have to learn how to lay the bricks.
So from a complete novice startpoint it really is impossible to tell you "how to build a finished application" competently, as there is much you will have to learn in many areas, from building the gui, setting up the controls, interrogating and updating the database, etc.
The people on this forum are very helpful, and never selfish with their code, but you will have to do a lot of learning yourself in order to be able to ask more specific questions. When you run into a wall, you will find people ready to help, but to begin with, I can't do better than suggest you use all the tutorials you can find.
In Rev 3.0 the start centre has a lot of tutorial information, http://www.runrev.com/developers/tutorials/ repeats most (if not all) of them, some with video walkthroughs.
Rev 2.8.1 through 2.9.1 had a "getting started" option accessed via the documentation toolbar icon, and a lot of sample stacks and in particular, some valuable video tutorials. I'm not sure how to access these directly any more, I still have 2.8.1 through 2.9.1 and have them cached on my machine too. If needs be, I'm sure there could be a way you could get to see them.

More tutorials are: http://www.runrev.com/developers/exploring-revolution/

http://support.runrev.com/tutorials/ has some of the older videos

http://support.runrev.com/scriptingconferences/ is also a series of stacks where in the "conference" a particular topic was covered and explained in depth. Very helpful.

The newsletters can be very helpful, get them here http://www.runrev.com/developers/newsletters/ and sign up to have future editions emailed.

Plenty of regulars on here also have very helpful sites and often with lots of downloadable sample stacks or libraries that help you not to have to reinvent the wheel, as well as learn.

http://www.sonsothunder.com/devres/revo ... lution.htm

http://www.altuit.com/webs/altuit2/RunR ... orials.htm

http://runrev.info/search.html

http://revolution.byu.edu/

http://www.troz.net/Rev/tutorials.php

http://economy-x-talk.com/download.html

http://revolution.screenstepslive.com/lessons

are all links that I can think of from the top of my head (and browser cache!) Apologies to anyone obvious that I've not given a thought/credit/link...!

All the best. Revolution can be frustrating sometimes, but usually there is a way to do what you need, and if you can be granular enough in putting your need across, you will find lots of help here in future. Good luck!

[bangkok]

First, you should download this stack :

http://www.troz.net/Rev/tutorials/MySQL.rev.gz

It's a very good "client" for MySQL databases : connexion, list of the tables, list of the fields (columns)... create, delete record etc.

It's a very good starting point to look and study the links between Revolution and MySQL.

Then of course, you need to learn the basic of MySQL (plenty of online tutorials on Internet).

Your SQL knowledge won't be lost... for instance if you decide to use SQlite instead of MySQL.
www.sqlite.org

SQLlite is mono user. But very powerful, and Revolution can access directly any SQLlite database via the "Database Query Builder".