DB-result FP2003/FP2000 problem??????????

T

Ted

Hi
Is there a problem with DRW in FP2003 compare to FP2000. I have a site with
a dbsearch that have worked ok for years now, it was built with FP2000. Now,
I am running FP2003 and suddenly when I edit those sides with FP2003 they
stop working.

I get this errormessages:
Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

I have a lots of "OR" in the query and if I reduce it to be max 5 "OR" it
works. Look at this query, there are 5 "kategori" (1-5) and 6 "lakspec"
(1-6). With this I get the errormessages but if I delete one lakspec it
works. The problem is that I need to put in about 20 kategori and 20
lakspec.

SELECT * FROM kunder WHERE( Kategori1 = '::Kategori::' OR Kategori2 =
'::Kategori::' OR Kategori3 = '::Kategori::' OR Kategori4 = '::Kategori::'
OR Kategori5 = '::Kategori::' )AND (Lakspec1 = '::Lakspec::' OR Lakspec2 =
'::Lakspec::' OR Lakspec3 = '::Lakspec::' OR Lakspec4 = '::Lakspec::' OR
Lakspec5 = '::Lakspec::' OR Lakspec6 = '::Lakspec::' ) AND (lan =
'::Lan::' OR kommun = '::kommun::' OR ort = '::eek:rt::') ORDER BY Efternamn
ASC

I really need some help with this
Ted
 
Top