View Complete Thread | FoxWeb Forum Home
Date:    Msg ID:   
From:    Thread:   
I'm just trying this product so you don't have to answer the questions ;-)

Well, I have an ordinary DBF file and I made the HTML search engine which gives the user the possibility to display certain records in a <TABLE> ... </TABLE>
The page is dinamically created by a foxweb script using an ordinary "SELECT * from sometable INTO CURSOR somecursor WHERE somecondition".
The results are ok, the 'search-engine' works fine and yet I need a little more.
The 'user' needs to perform a new selection inside the 'somecursor'.
In other words, a selection 'inside' another selection and so on
Step1. select * from all-the-fruits-table into cursor somefruits where fruitname='apple'After selecting and displaying all the apples :-) the user wants to see a new list of all the red apples.
And after selecting the red apples from the whole list of apples maybe he will want to select only the red apples that are not about to get rotten :-)

Well, as long as 'cursor' is a temporary file, how can I remember from step to step what to select in the new 'SELECT' sentence ?
It's like making multiple SET FILTER commands, allways adding new conditions to the previous SET FILTER command.
I have to warn that 'selecting-some-apples' task may be involve in reallity a complex condition (based on more fields or more AND's or more OR's, etc)

If someone understands what I want, and knows how to do it in a simple way without writing tables onto the user's computer in temporary folder, then please help me.