Hi,

I'm trying to execute a Select query with a Where clause in a JSP page and I
get the error listed below. From what I've been able to tell by checking
the news groups is that Btrieve doesn't use standard SQL.

javax.servlet.ServletException:
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]
Syntax Error: SELECT Chart Number, Last Name, First Name FROM LYTEC.Patient
WHERE (Chart Number<< ??? >> = '04M00007')

I've tried many different combos but I keep getting the same error except
that <<???>> gets moved around in the err msg. For example, I added table
name (Patient.) to all col names.

Any help would be greatly appreciated!

Regards,
Keith

In ANSI SQL you need to put the Chart Number column name in double
quotes since it contains a space. Try "Chart Number" .

--
_Bill_