Hi Folks,
If I try a FulltextSearch with searchStrings that are in different tables I
get the Error-Message
16945 SQL ERROR, The cursor was not declared.
Why do I need a cursor here because I wont the whole result at once! And I
have no clue how to use a cursor.
SELECT DISTINCT cs.id
FROM context_gst cg, context_sst cs
WHERE cg.id=cs.id
AND CONTAINS(cg.*,' "first*"')
AND CONTAINS(cs.*,' "second*"')
Harry
If I try a FulltextSearch with searchStrings that are in different tables I
get the Error-Message
16945 SQL ERROR, The cursor was not declared.
Why do I need a cursor here because I wont the whole result at once! And I
have no clue how to use a cursor.
SELECT DISTINCT cs.id
FROM context_gst cg, context_sst cs
WHERE cg.id=cs.id
AND CONTAINS(cg.*,' "first*"')
AND CONTAINS(cs.*,' "second*"')
Harry