QBF Knowledge base article 304428

  • Thread starter Thread starter george
  • Start date Start date
G

george

I used the knowledge base article 304428 to construct a
QBF form. When I tried the example (with 2 search fields)
on Northwind database it worked as expected, however I
noticed that after using the query when I opened it in
design mode the criteria lines where changed (they were
split in two or more lines and some new query fields were
created). When I looked at the sql view the WHERE clause
reminded me something of a cartesian product of different
combinations.

When I applied the example in my db I created a form with
10 search fields. The first time I used the form it worked
well but when I tried to open the query behind the form in
design mode, it could not be opened and I got the message
that I need more memory to open the query. When I tried to
close the query it could not be saved (again the same
message) Ultimately the form doesn't work at all now due
to memory problems.

What has happened? Have I created a cartesian product? Why
the newly created query worked the first time I run it? Is
there a better way to do this job, lets say by using code?

thanks in advance, george
 
Back
Top