LiveCode Forums.

Hi,

Not sure where this needs to go - getting started or databases. But it is a newbie question so here it is...

I have been playing around with Rev for a little bit to see if it could replace MSAccess for me. So far so good, but I now have the following question: what is the easiest (not necessarily the most powerful, just quickest and easiest) way to edit data in a database without having to resort to arrays/cursors/etc?

Is there a control - even if not part of standard Rev but a third party add-on - that will create a "add/delete/edit records" table-like structure which I can place onto a card and where I write no/minimal scripting (something that MSAccess can do)?

Thanks!

Take a look at SQL Yoga:

http://www.bluemangolearning.com/revolu ... databases/

You'll also want to look into Quartam Reports as a third-party add-on. Keep in mind that MSAccess is designed to do one thing only, and so it has database niceties that you shouldn't expect out of the box in a general-purpose development environment like rev or Visual Basic or whatever else.

If the size of your data is not to big you might not need to use a database at all! Add your fields and make a background group. In a test I made, searching in 1000 cards is almost a zero-time search. (But I still mostly use DBs anyway

Hi Battlewolf,
I use tables a lot in the software I write, the basic table, not datagrid.
There is a convenient method to add to the table, edit the table save the data and restore it. If you would like to see a stack and the code, please reply to ajperks@tiscali.co.uk and I will send it to you.
NB this is a junk address, so spammers, waste your time!