> as there's no way in FB to know that the PK column is autogenerated > using generator (at least I don't), you have to tweak the model to set > this up. Unfortunately every update of model will remove this. I'm > thinking about some special mark (anywhere) in comment to let me know > to mark this as generated PK column. What do you think? > > What about "#PK_GEN#"?
I think that: 1) This question should be discussed in fb-devel and i think that new feature should be added to server for this 2) I think that special table will be better solution than comments 3) Have you thought about views? There are big problems with views too, because provider dont't know abbout any relations, key fields and autoincrements for wiews. So, i'd like to propose to make some special tables like this: _AUTOINCREMENTS (FIELD_NAME, GENERATOR_NAME) _VIEW_PRIMARY_KEYS (VIEW_NAME, FIELD_NAME) _VIEW_FOREIGN_KEYS (VIEW_NAME, FIELD_NAME, REFERENCE_RELATION, REFERENCE_FIELD_NAME) ------------------------------------------------------------------------------ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
