Saturday, July 4, 2020

#1 2020-05-02 10:07:47 am

esla
Member
Registered: 2007-12-29
Posts: 3

Database Events user interface

I have a few databases in DBE that from time to time will require editing.

Adding or deleting records; editing fields.

I store the data in files written and read as lists.

I'm thinking of using Myriad Tables as a user interface.

But, before I try to reinvent the wheel, I'm wondering if anyone has tried anything similar, and if there's anything to watch out for.

Or if there's already a Database Events editing system available.

Any thoughts?

Ed

Offline

 

#2 2020-05-02 10:02:07 pm

KniazidisR
Member
Registered: 2019-03-03
Posts: 1259

Re: Database Events user interface

See Database Events Examples in the book "Hanaan Rosenthal, Hamish Sanderson - Learn AppleScript The Comprehensive Guide to Scripting 3rd ed 2010".

Your script should be stay-open application.
Try to bound database with Numbers.app. The script should create new document and set cells value to data from database automatically (in the on initaialize handler). Then, edit the cells in the Numbers.

Each delay, indicated in the on idle handler the script should take the cells value and put back into database. The on quit handler of your stay-open application should quit Numbers.app without saving the document, then quit stay-open application itself.

Also, it would not be out of place to add in the on quit handler a call to the updater handler (say, on update), which updates the database in accordance with the latest changes in Numbers.app (this handler will also use the on idle handler).

There is a lot of work here, and the specifics of your database are known only to you. Therefore, hardly anyone will write you a finished script. But, you begin, and they will help you with certain problems.

NOTE: begin with structure of stay-open script application

Last edited by KniazidisR (2020-05-03 07:05:26 am)


Model: MacBook Pro
OS X: Catalina 10.15.4
Web Browser: Safari 13.1
Ram: 4 GB

Offline

 

#3 2020-05-03 06:56:44 pm

Shane Stanley
Member
From:: Australia
Registered: 2002-12-07
Posts: 6395

Re: Database Events user interface

How much data are you storing, and how are you interrogating it?

I store the data in files written and read as lists.



Do you mean update data?


Shane Stanley <sstanley@myriad-com.com.au>
www.macosxautomation.com/applescript/apps/
latenightsw.com

Offline

 

Board footer

Powered by FluxBB

RSS (new topics) RSS (active topics)