Hello Thomas.

Yes, axcys is a schema. I removed the word to now use this command
DatabaseQuery(1, "SELECT * FROM contacts;") and the error -104 was
replaced with error -204 Table unknown. I checked the DB with
FlameRobin, there is in fact a table called "contacts". Clicking DDL in
FlameRobin yields the following (wanted to show the table and its
columns to you and not sure another way to do so). Why does TB
think there is no contacts Table?

Thank you
Tim


CREATE TABLE "contacts"
(
"Contact_Name" Char(30) NOT NULL,
"ContactDesc" Char(50) NOT NULL,
"Contact_Phone" Char(20) NOT NULL,
"ContactFax" Char(20) NOT NULL,
"Contact_Fax_2" Char(20) NOT NULL,
"Contact_Fax_3" Char(20) NOT NULL,
"EmailAddress" Char(50) NOT NULL,
"EmailAddress1" Char(50) NOT NULL,
"EmailAddress2" Char(50) NOT NULL,
"Frequency" Integer NOT NULL
);
GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
ON "contacts" TO TSEYFARTH WITH GRANT OPTION;

On 1/31/2011 12:30 AM, Thomas Steinmaurer wrote:
>
> > Thank you for your reply!
> >
> > Yes, there is a quote after the semi colon. Should it be elsewhere?
> >
> > This is part of a function DatabaseQuery(1, "SELECT * FROM
> > axcys.contacts;") where the whole SQL command is grouped in between
> > quote marks.
>
> Firebird doesn't support so-called schema. I guess axcys is a schema in
> your PostgreSQL database?
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>
>


[Non-text portions of this message have been removed]