Digital Workshop

Welcome to the Digital Workshop Message Boards
It is currently October 6th, 2024, 1:37 pm

All times are UTC [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Database same query
PostPosted: March 29th, 2013, 10:38 am 
Offline

Joined: March 25th, 2013, 4:53 pm
Posts: 14
Opus: Opus Pro v8.10
OS: Windows XP SP3
Hi,

I have one doubt about queries.
I'm doing exercises where first of all appears a screen (picture) with instructions to do it. I did a query for it because I have in a .xls file all the text. After I want that the query stills enable to show, because there is a help button if the user wants to see again the instructions.

However, when I require again the query, second attempt for the same query, doesn't work. I need to put kind of 'end query' in the first one? I've tried giving another name, but didn't solve.
And before the query appears the follow message: [Function constructor], what exactly that means?

How can I do it?

Thanks.


For this message pnrf has been thanked by : mackavi


Top
 Profile  
 
 Post subject: Re: Database same query
PostPosted: March 29th, 2013, 11:22 am 
Offline
Godlike
Godlike
User avatar

Joined: March 21st, 2007, 10:44 am
Posts: 3188
Location: UK
Opus: Evolution
Using actions:

An Opus query returns a record set containing all records that match your query. The fields from that record are mapped to the variables that you specify when defining the query.

It doesn't close until you tell it to using the end query action.

You can use the database actions to navigate the record set - assuming there is more than one record and the fields will update the variables accordingly.

Mack

_________________
When you have explored all avenues of possibilities, what ever remains, how ever improbable, must be the answer.

Interactive Solutions for Business & Education
Learn Anywhere. Learn Anytime.

www.interaktiv.co.uk
+44 (0) 1395 548057


Top
 Profile Visit website  
 
 Post subject: Re: Database same query
PostPosted: March 29th, 2013, 11:44 am 
Offline

Joined: March 25th, 2013, 4:53 pm
Posts: 14
Opus: Opus Pro v8.10
OS: Windows XP SP3
I know that is with actions. I understood how works Database connection and queries.
And I've also defined the variables to receive the input from the query.

I thought the same about the end query action, so I didn't use it.
Navigate I don't need for this case, I already tried that one in other exercise.

Anyway, I found the solution! I just put to show the variables on the 'second help', and works well for what I want.

Thanks for the help!


For this message pnrf has been thanked by : mackavi


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group