It's a pain to accomplish, and would probably be faster just to create the
cursor in code
CREATE CURSOR tempCursor (selected l)
INSERT INTO tempCursor VALUES (.T.)
SELECT "short" as desc, 0 as min, 60 as max FROM tempCursor ;
union SELECT "medium" as desc, 60 as min, 120 as
Hi!
>From my experience Query Results may be redirected to Array, Cursor, Table
& more options as required.
Usage
SELECT [ ALL | DISTINCT ]
[ TOP nHowMany [ PERCENT ] ]
eColumn1 [ AS ColumnName1 ]
[, eColumn2 [ AS ColumnName2 ] ... ]
FROM [ FORCE ]
The short answer (as you've seen firsthand): No, you cannot do that.
You can do subqueries like this:
select * from MySource where id in (select id from SomeOtherSource where
condition=whatever)
On 4/15/2022 9:49 AM, Jeff Roberts wrote:
I've been watching a video tutorial called "Mastery
3 matches
Mail list logo
