torque and nullable foreign keys

[Tillich, Adrian]

Hi,

I have this problem:
an insert on a simple database table 
like this:
        CREATE TABLE CITY_MAP
        (
                CITY_NAME       varchar(20)     NOT NULL,
                CITY_ID int             NULL,
                
                CONSTRAINT PK_MAP
                        PRIMARY KEY NONCLUSTERED (CITY_NAME)
        )
        go

        ALTER TABLE CITY_MAP
             ADD FOREIGN KEY (CITY_ID)
                    REFERENCES CITY_ID
        go

fails, because Torque sets the foreign key field CITY_ID to a numeric 0
instead of NULL.
This is probably because the corresponding Torque-Peerclass uses the flat
datatypes instead of the Objects for numeric datatypes.

Can I somehow configure this behaviour or is there a workaround?

Changing the database model is not really an option because I use an
existing one.

Thanks,
Adrian


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]