Helen Borrie wrote:

> At 08:50 PM 3/03/2005 +0000, Richard Mace wrote:
>
>
>>Hi,
>>I have the following code:
>>
>>CREATE DATABASE '192.168.0.190:/var/lib/firebird2/dbase.fdb' page_size
>>8192 user 'SYSDBA' password 'masterkey';
>>
>>/*CONNECT '192.168.0.190:/var/lib/firebird2/dbase.fdb' user 'SYSDBA'
>>password 'masterkey';*/
>>
>>/*CREATE Departments Table*/
>>
>>CREATE TABLE "Departments"(
>> "Id" INTEGER NOT NULL,

<snip>

>
> Ah, you should read the warnings (frequent) about using quoted identifiers
> to define your objects.
>
> There is no field called ID in that table, because you named it "Id".
>
> ./hb

Thanks Helen.
That was it.
For some reason I thought I had to put quotes round everything because
it was dialect 3.
I am now going to put down the compiler and start reading your book from
scratch.

Richard Mace