MYSQL

[homer111]

hi, i'm using the last CVS version (downloaded yesterday).
The problem is: i could retrieve records from a mysql database but i couldn't insert it.
The debug windows show:

SELECT t1.oid AS t1_oid, t1.codproveedor AS t1_codproveedor, t1.nombre AS t1_nombre FROM recuento.proveedores as t1 WHERE  t1.codproveedor = @p1
Select statement returned 0 row(s)
Cache: ObjectsLoading turned off so now resetting m_originalobject for all cache entries
BEGIN TRANSACTION
Nested BEGIN TRANSACTION - not actually called
Nested COMMIT TRANSACTION - not actually called
Nested BEGIN TRANSACTION - not actually called
Saving object Proveedor
@p1: 000000010001
@p2: 000002
@p3: CARRO
INSERT INTO proveedores (oid, codproveedor, nombre) VALUES (@p1, @p2, @p3)
Couldn't insert object in unknown state, trying to update...
@p1: 000000010001
@p2: 000002
@p3: CARRO
@p4: 000000010001
UPDATE proveedores SET oid=@p1, codproveedor=@p2, nombre=@p3 WHERE  proveedores.oid = @p4
Couldn't update object in unknown state, throwing initial exception
Nested ROLLBACK TRANSACTION - not actually performed
ROLLBACK TRANSACTION
Excepcin no controlada del tipo 'AToMSFramework.SaveException' en microsoft.visualbasic.dll

Informacin adicional: #23000Column 'oid' cannot be null
Inner Exception message : #23000Column 'oid' cannot be null
Inner Exception message : #23000Column 'oid' cannot be null
Inner Exception message : #23000Column 'oid' cannot be null

i'm using mysql 4.1.0 not the max version but i believe that with innodb the transactions was supported.

TIA

[homer111]

update: i only could retrieve records with a cursor and retrievefullobjects but all the SELECT ... WHERE returns 0 records.

TIA