Subject I'm a goose (was Embedded SQL anyone?)
Author Peter Faulks
I wrote:
3) I have a query that works fine in insql but barfs in embedded sql -

I had hard-coded the connect string in my app for testing purposes
(temporarily bypassing my login screen procedure)
The connect string was connecting to an old version of the db that didn't
have the table defined - DOH!

I need more sleep.

It now works fine.....But a more concise error message 'table doesn't
exist' would have been helpful :-)