Digital Workshop

Hi All

I have looked at Robin Garett's posts on Databases and found them most helpful, BUT I still don't understand how to set up the database tab in the publication. I feel very stupid having to ask for help with this, but if anyone out there can help I would be most grateful.

bizzybee

It has been a while since I played with Access database in Opus. I think mainly what you are asking is how to set-up the DB connection. Part of the set-up is done in Publication Properties >>> Database tab. And depending on what options you select there, you may need to establish a DB connector in Windows Control Panel (as administrator).

I think you need to provide more information if you want specific help.
viewtopic.php?f=6&t=3514

Several people have posted related questions on the forum previously, and those threads can be found by searching. Terms that might help: database connection ODBC Access Excel (or some combination of those)

Many thanks for your response. I have made some progress; I can read from and write to my access database, but have struggled for hours (to no avail) to be able to edit / delete records. Are there any scripting examples of this. I'm rapidly going grey. Thanks for listening.

How well do you know SQL? What is your skill level, comfort level with scripting (ECMA/opusscript)?

Let me try to help a bit, but really I would ask you post your current question fresh over in the Advanced section. Good to add a note and link at the end of this thread so people can jump over there to. This will keep the Tutorial area clean, and maybe the Mods can move this thread too.

So one little 'gotcha' in Opusscript that sometimes bites me in the ass. Just when I think some coding I wrote is fairly simple and direct -- and should work, but does not -- I find I have used a variable where a numerical value is expected by the command or function, but the contents of the variable is a string value e.g. 1, 2, 34. And there is a related situation where I add what I think are numbershowever with the numbers above as an example, I get concatenation result: 1234 rather than a sum: 37.
The solution to these nuances is twofold.
1) use Debug.trace( "Here is the result of my addition: " + mytest +"\n")
In other words, monitor results as various points of progress. You actually need to be clever to check whether you have a string or a number value.
2) add extra code to force a variable to be a numeric value.

You'll have to Search
delete record
or
edit record
...and see what Threads pop up. Others here may readily recall where the desired script is, but I myself do not work with Access or Excel through Opus.

I'll continue to try to help, but please do bring your Profile up and follow other posting guidelines.
Cheers.

Thanks once again for your quick response. I will follow your advice and see if I can beat this problem.