Board index » delphi » New to IB - Says table doesn't exist

New to IB - Says table doesn't exist

Hello Everyone,

I'm in the process of checking out IB6 to move from MS Access.  I've used
the a utility to migrate my Access DB to IB6.  When I run a simple query
like:

SELECT * FROM Orders

...in the Windows ISQL, it says that the table doesn't exist.  Yet, when I
browse to the table in the IB Tool that comes with IB, I see the table and
can also see the data in it too.

Any ideas?

Thanks,

Lee

 

Re:New to IB - Says table doesn't exist


Is Orders mixed case like you typed?  If so you have a Dialect 3 database and
the table was created quoted which makes it case sensitive.  Try

  Select * from "Orders"

Quote
Lee Jenkins wrote:

> Hello Everyone,

> I'm in the process of checking out IB6 to move from MS Access.  I've used
> the a utility to migrate my Access DB to IB6.  When I run a simple query
> like:

> SELECT * FROM Orders

> ...in the Windows ISQL, it says that the table doesn't exist.  Yet, when I
> browse to the table in the IB Tool that comes with IB, I see the table and
> can also see the data in it too.

> Any ideas?

> Thanks,

> Lee

--
Jeff Overcash (TeamB)   | Talk about failure
(Please do not email    | To fall is not to fail
 me directly unless     | Failure isn't about falling down
 asked.  Thank You)     | Failure is staying down (Marillion)

Re:New to IB - Says table doesn't exist


Yes, thanks Jeff

Lee

Other Threads