Hi Andrei,
Use the Offset and Limit in the SQL query. [...] SELECT select_list FROM table_expression WHERE condition LIMIT 50 OFFSET 10000
This query will return 50 elements starting with the 10000 elements... so
the elemenst from 10000 to 10050.
That isn't the issue since I only need a specific few of the lines at all. I need a dynamic WHERE clause.
It's more like this :
SELECT customer_id, and, some, more, fields
FROM table1
JOIN table2
JOIN table3
....This results in the "huge" set.
On the Access-form I only need the orders, or contact history for 1 customer.
As of now I only know 2 ways to solve this.
1) Load all the tables over the net into Access and let the JOIN run locally. That way I can filter dynamically by adding a WHERE customer_id = x to the select above.
2) Let the JOINS run in a server based view and transfer the whole result into Access to fetch the few lines regarding the customer.
There should be something like:
3)
a) Access calls a server based function with the customer_id as parameter.
b) The function calls the server based view and filters the result acording to it's parameter.
c) The function sends only the actually wanted lines back to Access.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
