When you are using application express you can put @ symbol to get input
from the user:
For example, when you want to edit an invoice(form) by an invoice number you
put this in the where clause.
invoice_number = @ 'Enter invoice number'
This will
I have taken this from the R:base help screen:
When you assign actions to menu options in the Application Designer, you can
specify WHERE clauses to limit the rows of data for that action. You can
also use a feature that allows you to prompt the user for WHERE
conditions--enter the following line in a WHERE clause: @'prompt'.
For example, you want to prompt the user for a customer ID number from the
Customer table. In the "Where Builder" dialog box, select the custid column
and use the @'prompt' feature.
The problem I have is the parentheses around the 'prompt' part. If my quote
settings are the double quotes (") it will not convert it when it
compiles(saves).
Dan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Bernie Corrigan
Sent: Wednesday, January 09, 2002 1:28 AM
To: [EMAIL PROTECTED]
Subject: Re: Applications Express and the '@' symbol with quote setting
6.5++ patch 1 for windows
Dan -
I've never seen @ used in this fashion before. Is this documented
anywhere?
Bernie
======================================
At 11:38 AM 1/8/2002 -0800, you wrote:
>I have found a problem with using applications express with the quotes
>setting at double quotes.
>
>When you use the @ symbol in the forms where clause with the double quotes
>setting, it will not convert to a user dialog box when it compiles.
>
>This is what is looks like in the app file:
>
>EDIT USING vendorinsp +
> WHERE vendorinsp.inspect_date contains @ "Enter date"
>
>It should look something like this:
>
>SET VAR WHVAL1 TEXT
> DIALOG "Enter Date"+
> WHVAL1 WHTEMP 1
> EDIT USING vendorinsp +
> WHERE vendorinsp.inspect_date = .WHVAL1
> CLEAR VAR WHVAL1
> CLEAR VAR WHTEMP
>
>
>But if you change to the single quotes setting, delete it, reenter it, and
>save it work work fine but will not convert the previously made @ clauses
>that were done in double quotes in the previous version of R:base.
>
>I have have done it with 6.5+ and previous versions but in 6.5++ and in
>6.5++ patch 1 it don't work.
>
>Has anybody ran across this or can duplicate this??
>
>
>Dan Goldberg
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD>
><META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
><META content="MSHTML 6.00.2712.300" name=GENERATOR></HEAD>
><BODY>
><DIV><SPAN class=522120119-08012002><FONT face=Arial size=2>I have found a
>problem with using applications express with the quotes setting at double
>quotes.</FONT></SPAN></DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial
>size=2></FONT></SPAN> </DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial size=2>When you use
the @
>symbol in the forms where clause with the double quotes setting, it will
not
>convert to a user dialog box when it compiles.</FONT></SPAN></DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial
>size=2></FONT></SPAN> </DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial size=2>This is what is
>looks like in the app file:</FONT></SPAN></DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial
>size=2></FONT></SPAN> </DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial size=2>EDIT
USING
>vendorinsp
>+<BR> WHERE
>vendorinsp.inspect_date contains @ "Enter date"</FONT></SPAN></DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial
>size=2></FONT></SPAN> </DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial size=2>It should look
>something like this:</FONT></SPAN></DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial
>size=2></FONT></SPAN> </DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial size=2>SET VAR WHVAL1
>TEXT<BR> DIALOG
>"Enter Date"+<BR> WHVAL1
WHTEMP
>1<BR> EDIT
>USING vendorinsp
>+<BR> WHERE
>vendorinsp.inspect_date = .WHVAL1 <BR>
CLEAR
>VAR WHVAL1 <BR> CLEAR
VAR
>WHTEMP</FONT></SPAN></DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial
>size=2></FONT></SPAN> </DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial
>size=2></FONT></SPAN> </DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial size=2>But if
>you change to the single quotes setting, delete it, reenter it, and
save it
>work work fine but will not convert the previously made @ clauses that
were
>done in double quotes in the previous version of
R:base.</FONT></SPAN></DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial
>size=2></FONT></SPAN> </DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial size=2>I have have
done it
>with 6.5+ and previous versions but in 6.5++ and in 6.5++ patch 1
>it don't work. </FONT></SPAN></DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial
>size=2></FONT></SPAN> </DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial size=2>Has anybody ran
>across this or can duplicate this??</FONT></SPAN></DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial
>size=2></FONT></SPAN> </DIV>
><DIV><SPAN class=522120119-08012002><FONT face=Arial
>size=2></FONT></SPAN> </DIV>
><DIV><FONT face=Arial color=#008000><STRONG><EM>Dan
>Goldberg</EM></STRONG></FONT></DIV>
><DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
