I think that is what I am doing. The two fields are a compound primary key
and are:

PCAT_UNIQUE_REF
PCAT_SYSTEM_REF

The generator links is PCAT_UNIQUE_REF=NN_PRODCATS

There is a trigger on the table:

IF (NEW.PCAT_UNIQUE_REF IS NULL) THEN
NEW.PCAT_UNIQUE_REF = GEN_ID(NN_PRODCATS, 1);

PCAT_SYSTEM_REF is set by the dataset's OnNewRecord method.

Unless I have misunderstood it, I am doing it precisely as you recommend but
the "invalid variant type conversion" still occurs.

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: 28 August 2001 21:02
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] DML Caching


If you use the generatorLinks property to get your key values and make the
trigger only assign a generator value when the new.value is null then you
should be just fine.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <mkl20uk@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, August 28, 2001 12:34 PM
Subject: [IBO] DML Caching


> Using Delphi 6 and IBO 4 I have experienced a problem implementing
> DML caching and any help would be much appreciated.
>
> The query is an IB_Query component and it is within an application
> which works fine. The table is a simple table and the primary key
> comprises 2 fields (both of type Int64).
>
> My understaanding is that to implement caching with the scope of a
> user's context is as simple as setting the DML caching flags on the
> relevant datasets. Setting the datasets DML flag to announce inserts
> causes an error when the dataset is posted. The error is "Invalid
> variant type conversion". One of the keys is provided by a generator
> so I image its value may only be known on the server.






Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/