Zeos and Autoincrement
Posted: 04.09.2012, 07:41
I try to use Zeos with ado protocol to fill a small table with DBGrid. Database is MSAccess and have one autoincrement field. In dbgrid I leave that field empty and on post I receive a error message "try to assing a null vaalue to a variable that is not a Variant data type".
But when I try the same combination with Delphi ADO driver, everything works without problem and the autoincrement field get (automaticly) corect value.
Did I miss something? I use Zeos with MSSQL and MySQL and there are Sequencies that you could use for autoincrement, but there is no Seq in Access.
How to get autoincrement value in Zeos?
Thanks in advance
But when I try the same combination with Delphi ADO driver, everything works without problem and the autoincrement field get (automaticly) corect value.
Did I miss something? I use Zeos with MSSQL and MySQL and there are Sequencies that you could use for autoincrement, but there is no Seq in Access.
How to get autoincrement value in Zeos?
Thanks in advance