Digital Workshop

Can anyone help, I have made two databases, one with flashcards generated by myself that will be added to on a monthly basis and an endusers database where they can add additional cards as they work.

Mack suggested this method so I can then update the students flashcards but not delete the ones that they have entered.

I have linked the users input database to my main datebase and then made the query so I can access the end result in Opus but I seem to hit a brick wall at this point

Any help would be appriciated

Ok, I think I have solved this, I have made an append query that adds the users input to my main database.

How can I get Opus to carry out the append query (within MS Access) so this is all done in the background without the endusers knowledge.

I do not use scripting but am willing to give it a go.

No, it seems that Opus actions cannot access queries but you can using scripting. There are several database lessons under the tutorials section.

Your setup should look something like this.

User Database
Main Database with link (not import) to table in User Database

Union Query in main database that merges the linked table (user) and actual table (in main).

Opus Script that connects to the name of the union query.

I've only ever had to do this with Oracle and mySql - so no guarantee that it works with Access

Mack

Thanks mack,

I have now got my Union Query which seems to working fine, can you help me with an example of the script to use to call the query up from Opus and show on screen.

Main database Hung1
Users Database: Userinput

Union query: English query

//demo is the name of the ODBC
//Query1 is the name of the query - don't use spaces
//Field1 is the name of your field(s)

var myDB = new Database("DSN=demo;")
var Rset = myDB.ExecuteSQL("SELECT * FROM Query1")
Rset.FirstRecord()

Debug.trace(Rset.Field1)

Mack

Thank you Mack, I have not had time to try it yet, just one thing do I have to list all fields or just the first one (Debug.trace(Rset.Field1) )



Sorry if this is rather basic for you, can you recommend any course for scripting because I have loads of ideas, no idea how to make them happen and getting frustrated and to boot well into middle age where my brain cells are rapidly leaving...........

Not a problem.

The Debug.trace statement will simply display on field in the debug panel. You'd need to add all your fields and eventually add them to the page for on screen as well. Debug is simply a way of checking things are working.

This forum has loads information - a little too much and all over the place, but some brilliant stuff.

Interaktiv are also in the process of going live with our new website and based on the requests for lots of people - will have a business / Opus development focus as well as our original educational focus. Hopefully sometimes towards the end of the week - I'll post a notice here.

We will hopefully have a whole range of starter modules that will help people learn to script in various areas that interest them as well as short screen casts general Opus development.

Mack

Mack,
I for one will be more than happy to pay for such modules to allow me to try and understand scripting, once again thanks for you help

Cheers,

We made it on time. The new site is up and running. I'll post more information in the service section below but the link is www.interaktiv.co.uk

We'll be adding to the Opus Script 101s over the next few weeks and bringing various modules on line.

Mack

Hi Mack went to your web site and its coming up as follows managed to view home page etc but thought I would let you know

Cheers

Index of /

Desktop.ini
_vti_bin/
backup/
cgi-bin/
cms/
demo/
live.zip
live/
media
php.ini
phpinfo.php
shop/
support/
Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_perl/2.0.4 Perl/v5.8.8 Server at www.interaktiv.co.uk Port 80

How odd? Was this today that you tried it?

The site has been tested with:

IE7&8
FF2&3
Chrome
Safari4

Can you post details of the machine you are using?

Cheers

Mack

P.S I've uploaded various quizzes games that introduce different aspects of scripting. I'm working on the DB ones and a few other ideas.

Hi Mack,

there's a "." after uk in one of your links,

eg

http://www.interaktiv.co.uk./ shows the folder contents but

http://www.interaktiv.co.uk/ displays properly.

It's surprising that we can see the folder contents when the "." is appended; maybe it's a webhost configuration issue.

cheers
Paul

Cheers Chaps,

It's fixed although why it occurs nobody seems to know. Our new hosts are absolutely fantastic but the set-up is completely different to our older provider.

Mack