I am running an SQL query with some strings and am getting an error.   I've narrowed down the issue to having a quote in one value and a colon in
the other.  Here is a sample:

select * from TEST_TABLE
where TEST_NAME = "Joe's form"
and TEST_VALUE = "a:b"

In my application I am getting error "11949 SQL Error - ..." with different error text, depending upon which fields in my update statement have
quotes and colons.
When I run the SQL in the DBsys, I get an error message of "Indexes on table(s) in the query are either missing or appear invalid.  Would you like
me to create empty ones for you?", even though there is no problem with the index.
If I remove either the quote mark or the colon, then it works fine.

I am going to change my SQL to use parameters, but do you know why the parser is having problems with the above values?

Hi Walter

Try this:
select * from TEST_TABLE
where TEST_NAME = 'Joe''s form'
and TEST_VALUE = 'a:b'

Malcvolm

Walter,

<< I am running an SQL query with some strings and am getting an error.
I've narrowed down the issue to having a quote in one value and a colon in
the other. >>

What version of DBISAM are you using ?

--
Tim Young
Elevate Software
www.elevatesoft.com