A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

@Prompt(,,,,,) ... again



 
 
Thread Tools Display Modes
  #1  
Old December 23rd, 2005, 11:47 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default @Prompt(,,,,,) ... again

Sorry for the very short question. Here is the situation:

I am using BusinessObjects (version 6), which requires the mid-layer namely
Universe. The Universe is a middle layer between database and BusinessObjects
(BO). I am thus designing a Universe for that purpose. However, for some
reasons I cannot deploy it in Oracle, MS SQL, Sybase, Informix, etc. I can
only use MS Access as database layer to deploy Universe.

In the Universe Designer there is a function: @Prompt. It forces a user to
enter a
value for a restriction when that object is used in a query. When the user
runs the
query, a prompt box appears asking for a value to be entered. The syntax of
the function is as follows:

@Prompt(‘message’,‘type’,[lov],[MONO|MULTI],[FREE|CONSTRAINED])

Whe

- ’message’: Text of the prompt message. The text must be enclosed between
single quotes, for example, ‘Choose a Region’, ‘Pick a time
period’, or ’Choose a showroom’. The text appears in the prompt
box when the query is run.

- ’type’: Data type returned by the function. It can be one of the following:
• ’A’ for alphanumeric
• ‘N’ for number
• D’ for date
The specified data type must be enclosed in single quotes.

- lov: List of values (optional). You can specify two types of list of
values:
• Hard coded list. Each value is separately enclosed in single
quotes and separated by a comma. The whole list is enclosed
in curly brackets. For example, {'Australia', 'France', 'Japan',
'United Kingdom', 'USA'}.
• Pointer to a List of Values from an existing object. You invoke
the target lov by double clicking on the object containing the
lov that you want to use in the Classes and Objects panel.
This gives the Class name and the Object name, separated
by a backslash. It must be enclosed in single quotes. For
example: 'Client\Country

- MONO: User can only select only one value from the list of values
(optional).

- MULTI: User can select multiple values from the list of values (optional).

- FREE: User can enter a value of their choice, or select one from the list
of values.

-CONSTRAINED: User must select a value from the list of values.
Syntax Description

Example:
@prompt('What is the Current Year?', 'N', {'2003', '2004','2005'}, MONO,
CONSTRAINED)

My consultant confirmed it works well in Oracle (and maybe in MS SQL), but
not in MS Access.

My question is that how to translate this syntax into MS Access's

Many thanks in advance
Best regards



  #2  
Old December 23rd, 2005, 11:56 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default @Prompt(,,,,,) ... again

You need the PARAMETERS statement. Check it out in F1 help. But it is a
simple "value for symbol" replacement, it does not have any of the
snazzy features that you described for the @prompt statement. Those
could be obtained, if necessary, by coding a form with a suitable
textbox, listbox, or other suitable Access item.

PS: better to have replied in the original thread. Usnet is "threaded"
- there's no guarantee that the peoplke who read your previous thread,
will also read the second thread.

HTH,
TC

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
@Prompt(,,,,) @Prompt Database Design 5 December 23rd, 2005 11:57 AM


All times are GMT +1. The time now is 02:52 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.