sql update

[avert]

Hi--

this is going to sound dumb...BUT I can't get it running (in BDE qith tQuery it's fine)

sql:

Update myTable
Set MostRecent='F'
where EQ='1'

results in a "ORA-00936: missing expression" when I do an ExecSQL on the query.

What's wrong?

thanks
Kelly

 

[avert]

Found it.

The SQL I was using was more complicated than posted AND I just figured it out.

Thanks anyway.
Kelly

 

[jayouzts]

Originally posted by avert:
Found it.

The SQL I was using was more complicated than posted AND I just figured it out.

Thanks anyway.
Kelly

Could you elaborate on the nature of the problem? I am getting the same message in a similar query and cant figure out what is wrong.