At 10:51 AM 07-08-01 +0200, you wrote:

>I have two problems:
>
>Firstly, I manually insert records to a dataset using methods like
>TIB_Query's Insert method. Even though I do have the KeyLinks property
>correctly set to the primary key of the table, the row cursor moves to the
>previously selected record after the post. I would like it to stay at the
>newly created record. I've tried setting the KeyLinksAutoDefine property to
>true instead of specifying the LeyLinks also, but it still doesn't work.
>What am I missing?

Set the RefreshAction property to raKeepDataPos.

>Also, I have a simple generator which increments the primary key of a table
>when inserting a new record. For some reason the generator add's 2 to the
>previously created value instead of 1. Am I doing something stupid again
>which will cause this behaviour?

You are probably doing something...um...fairly typical for a newbie.

You probably have GeneratorLinks set. This will fetch the key value from the generator as the dataset is going into Insert mode. All is well at this stage.

Then, your "simple trigger" is probably just TOO simple. It is saying "new.ID = gen_id(mygen, 1)" when it should be testing for NULL, viz

if (new.ID is NULL) then
new.ID = gen_id(mygen, 1);

You only want the trigger to fire the generator if the value isn't supplied, do you see?

The FAQ on the IBO website is a fairly useful resource for problems like this...

Regards,
Helen

>Best Regards,
>Don Schoeman
>
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________