Digital Workshop

Mainly, pay close attention to the path used for the DB file. You've got to get it right -- where it will be when published -- in the DNS set-up fields and options, and in the methods you use for including Additional Resources to the Published folder or package.

Hi Lars,

Thanks again for your response
I have the database being published to the SYSTEM_PUBLICATION_DIR - and it is publishing there ok.

I don't have any Additional Resources being published - similar to the Sample Access Database....

I have compared both Pubs and cannot see any difference - so have hit a bit of a wall.....
The crazy thing is - it plays back fine on 3 of my systems (creating a .ldb file) - just not on the machine that I will be using when the project is finished....

Hi Pete,

Sorry manic week week...

Not sure if it's want you need, but here's an example of what I was trying to explain. If you extract the IMP and MDB to C:\, then the database should work as well.

Regards,

Mack

Mack,

Thanks very much that is perfect.
I was adding the < and > to the variables ...

Yours (as always) worked!! Thank you so much.

Now if I can only work out why the end user PC is not connecting to the database - I will be sweet.

I am baffled as to why the sample access pub works on the end user PC (creating the .ldb etc) but not for my pub.
And yet mine does work on all my other systems (creating the .ldb etc) on the network????

Regards

Pete

Sorted it...

Just had to toggle the INSERT SPECIAL FOLDER for the SYSTEM_PUBLICATION_DIR path and then republish and the end user PC is now seeing the database
Thanks Mack and Lars...
Hope to be able to return the favour some time

Warm regards

Pete

Hi again,

I now have my publication working well....
And then had another thought.....
If a search is made for a name that does not exist - what code would I need to show a text box saying something like - sorry no record found.

ie. If I type in Smith - I get all the Smith records
IF I type in Smithies - I just currently get a page with no data showing.....

Thanks again in advance

Warm regards

Pete

Pete,

You could use any of several Opus Actions related to a DB query. Do a simple search in the Help-file for database.
Will show:
Get Number of Records action
Get Record Number action
Get First Record action

Any of those could have a result stored to a variable, then use that in an IF Test action. (could also use the Select / Case combination of actions).

BTW, more generally... a Button label can be a variable. That is an easy way to advise the User what to do next.
Depending on how you need/want to structure the interaction, the above IF Test could be placed under this button trigger.

Here's an example using the Record Count to display different messages. I've added the action to the query button.

Mack

Many thanks guys....
AWESOME help as usual

Happy Christmas

Pete

Hi again,

The project that Mack and Lars helped me with is now working really well, however, I would now like to add the following enhancement.

IF I have a database with, for example, Brown R, Brown L, Brown S and Brown T in it.
And the user does a search for "Brown"
Can I list all four "Browns" on a results page - so the viewer can see the results in a list view and then click on the correct "Brown" to proceed and show more info?

I am assuming it would involve the population of an array?

Many thanks

Pete

Are you using SQL Query here?
If so, the answer is (I think)... 'yes'. You would just use the query phrase for 'contains'.

Or maybe more specifically, a query phrase for 'begins' (is that part of SQL... I forget).

I'm not very familiar with Access DB, but guess that it would behave like most other DBs... you could also try the 'LIKE' operator.

Hi Lar,

Currently I am using a reworking of the code that Mack provided me with in combination with the SQL Wizard (see db2.zip attachment to Macks last post)
It is working really well - locating a name and using the next and previous buttons to go forward and back to list the "Browns", but I am not sure how to achieve a "list" of all the Browns together on one page.
Hope that makes sense?

Regards

Pete

Either an array or populate a list box. There is loads of posts on the latter.

As you're using DB actions not script, you'll probably have to mix and match for a solution.

1. Create a new Array variable. IE myArray

2. Create a counter variable set to zero. IE myCounter = 0;

3. Use the Get Number of Records action for your query and store in a new variable.

4. Create a loop from zero to value above #3.

5. As the loop increments, use Next Record to read value from query into an array.

6. Increment value in variable at #2

NB. The loop / array index is the value in the first variable. Opus actions don't permit a variable as an index so you'll have use a script object. EG:



Mack

Hi Mack

I have tried to follow your instructions below - but not having much success.
I can follow your logic - but transferring that into code is proving to be beyond me.

By looking at your db.imp files that you attached to previous solutions as mentioned earlier in the thread - I was able to understand what you were saying and rework the elements to achieve what I wanted.
I have been looking through the forum for other examples and have done the tutorial that Robin Garrett posted years ago.
But what I want to achieve appears to be beyond what I have found so far.

I do really appreciate your help and expertise. This forum would be much poorer without people like you on it.

Warm regards

Pete

Hi Mack

Having now dug a little deeper on the forum - I have found this thread that you answered
viewtopic.php?f=4&t=2801&hilit=arrays+array+arrays
So I will take a look and will try and see if I can follow that - Regards

Pete