[fpc-pascal] MSSQL and ftAutoInc: FPC 2.6.5 changes the behavior of 2.6.2 but AutoInc not works yet

Marcos Douglas md at delfire.net
Fri Apr 25 17:35:17 CEST 2014


On Fri, Apr 25, 2014 at 2:46 AM, LacaK <lacak at zoznam.sk> wrote:
> Do you have tried for ftAutoInc field simply set ReadOnly:=False; ?
> -Laco.

Errr... I forgot this option... worked, thanks!  :)


> P.S. there is feature request about automatic fetching of new values of
> idnetity columns, but implementing it in generic way for all supported
> SQLConnections is not trivial ;-)

Why not only start the implementation?
I think some property "UpdatePrimaryKey". This property could be use
in an automatic way for some DBMS eg MSSQL that you have to call
"select scope_identity() as id".
Maybe, for some DBMS, the programmer could write some SQL to execute,
similar to "UpdateSQL".

Martin Schreiber, has many good ideas too.  ;-)

Regards,
Marcos Douglas


More information about the fpc-pascal mailing list