Hi,

We wanna use dbExpress with Interbase.

We have a database with tables where we use triggers\generators to get a value for a unique field in our tables.
We are using a SQLClientDataSet for getting\editing the data.
When we try to append a record and don't put a value in the unique field ( the value is generated by the trigger\generator combination on the IB server) and apply the updates we get an error which tells us we need to put a value in the unique field.

It seems to me you don't want to do this. For this I've created the trigger etc in IB. I don't want to get the value from IB with a stored proc and put it in the clientdataset because I don't need it anywhere in the application. It's not a problem for one or two records, but when you must put a lot of data in the table it seems a waste of time to me. It only gives more network traffic. There must be a better solution for it (I hope).

The help tells something about autogeneratedvalue property for a tfield. When we put it on arAutoInc it does make no difference.

The table is created like this :
create table Test (
 id         INTEGER NOT NULL,
 name       varchar( 30 ),
PRIMARY KEY( id ));

In an earlier version of the software based on the BDE, with the same IB database in combination with a clientdataset there where no problems.

Can any give a solution for this problem,

Thanks, Jef

I was told that there are some known bugs preventing this AutoRefresh from working correctly. I haven't looked into it but we will look into in the next release.

T.Ramesh.

--
This e-mail, and any attachments thereto, is intended only for use by
the addressee(s) named herein and may contain legally privileged and/or
confidential information.  If you are not the intended recipient of
this e-mail, you are hereby notified that any dissemination,
distribution or copying of this e-mail, and any attachments thereto, is
strictly prohibited.  If you have received this e-mail in error, please
immediately and permanently delete the original and any copy of any
e-mail and any printout thereof.

Accelerate your Linux? application development with Kylix(TM), the RAD
tool for Linux. Easily integrate web, desktop and database development
to quickly deliver fast Linux applications. Kylix is the only Linux
development tool that combines the world's fastest compiler with the
most productive visual design environment for GUI, web and database
programming. Order your copy now!
http://www.borland.com/kylix/