I don't think that you can use & when defining your form var's or in the where
clause for popups.
But you can run an eep in table settings that set those table vars up and then
an eep that uses choose box and the var you setup in the other eep and get the
same afect as a popup
This is a piece of a work exsample from my database. You could use the basic
logic just about anyway you would like.
eep 1
SET VAR vWhereStyle_1 TEXT = 'WHERE CatID = .vCatID'
SELECT Width_PCat_YN INTO vWidth_PCat_YN INDIC ivWidth_PCat_YN FROM Categories
WHERE CatPrefix = .vCatPrefix
IF .vWidth_PCat_YN = 'N' THEN
SET VAR vWidthWhere TEXT = .vWhereStyle_1
ELSE
SET VAR vWidthWhere TEXT = .vWhereStyle_2
ENDIF
-------------------------------------------------------------------------------
eep 2
IF vOptions = 3 THEN
CHOOSE vWidthID1 FROM #Values FOR(WidthDesc),WidthID FROM ProductWidth
&vWidthWhere
IF vWidthID1 FAILS OR vWidthID1 = '[Esc]' THEN
GOTO DONE
ENDIF
SET VAR vWidthID INTEGER = .vWidthID1
UPDATE PartsList SET WidthID = .vWidthID WHERE ItemID = .vItemID
GOTO Done
ENDIF
On 17 Oct 2003 at 8:52, Dan Champion wrote:
> Hi all,
> I have a program that sets 90 variables that I use in a form:
>
> Set V Tech10 = .techview FROM &techtable1 +
> WHERE &techwhere AND serdat = .vardate1 AND cellno = "a0"
>
> I decided for speed that it would be better to create the variable in a
> form rather than in the command file.
> I tried to ADD/EDit variable:
>
> Tech10 = .techview FROM &techtable1 WHERE &techwhere AND serdat =
> .vardate1 AND cellno = "a0"
> And I get the error that the table &Techwhere doesn't exist. I use a
> variable to describe which table, so that I can change the table on the fly.
> Any work-arounds come to mind?
> I need to be able to use either of two tables for that (and all other 89
> variables)
> Thanks for your help
> Dan
>
>
> Dan Champion
> www.championsolutions.net
>
>
Victor Timmons
Tiz's Door Sales, Inc
425-258-2391
