RE: [sqr-users] LOAD-LOOKUP: Using BETWEEN in WHERE clause

["Alexander, Steve" <Steve.Alexander@ci.sj.ca.us>]

I use load-lookup in ordinary procedures, not in begin-setup.  There it is
not a compile time function, it is executed when the program reaches it,
like any other command.

-----Original Message-----
From: the dragon [mailto:ceprn@hotmail.com]
Sent: Monday, May 19, 2003 10:35 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] LOAD-LOOKUP: Using BETWEEN in WHERE clause


I may be wrong, but since load-lookup is a compile time function, the only 
way to pass a variable would be by using the compile time input command, 
ASK, if it is possible at all.  I am pretty sure you couldn't use a selected

value from a database table.

Besides, what would be the point, really?  You're just loading a 2 column 
table in memory.

clark 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your

services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)



----Original Message Follows----


Hello.

Is it allowable to pass an SQR variable to use in a BETWEEN of the WHERE 
clause of a LOAD-LOOKUP?

For example, I'd like to model the following SQL:

SELECT VALUE
FROM TABLE
WHERE $account BETWEEN COLUMN_FROM
                    AND COLUMN_TO



Thank you!

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users