Table has a primary key RID (row id, like OID) to identify the row. Devart DataTable is connected to data grid of VC2008.
I just want to insert fields into table except RID but I can not.
The RID should return from DB as a refresh after insert because DB generates RID automatically IF RID is null during insert/update and default value comes from sequence. This RID is needed because the other fields can be anything, like empty (null) .
I have no way to insert data into table . If ROW field is null, there is a exception. PK field can not be null in devart SW.
I tried to use RID as a normal field, not as PK, but no help.
I tried to use read only, default value -1 in devart SW and all variations...
I tried to change the insert SQL but I did not get it running.
How can anybody insert a record into DB and get sequence row ID with devart SW ?
(I don't want to use postgres OID because it is not safe. )
Sequence is here :
CREATE SEQUENCE flexmat_rid
INCREMENT 1
MINVALUE 1
MAXVALUE 2147483647
START 10000
CACHE 1
CYCLE;
ALTER TABLE flexmat_rid OWNER TO flx_admin;
RID integer has default value nextval('flexmat_rid'::regclass).
RID is primary key of this table.
I noticed Devart SW has a own incrementing system (for OID or RID ) but then the sequence current number is not in the DB for back ups.
Is anyone using this postgres version for real commercial projects ?
************************************
Devart sample programs do not operate on VC 2008.
Don't help much.

************************************
The document (help) is very limited. It indicate mostly syntax, not descriptions. I miss samples.
***********************************
It seems that when the "Live data" is set True and the DB connection is disconnected or server is down the devart SW craches at start up.
I happened repeatedly for me.
***********************************