>>>>What is the error message?
>>>
>>>The error message is :
>>>"Microsoft Cursor Engine: Multiple-step operation generated errors. Check each status value. "
>>
>>As usual very informative message.
>
>Thomas is on the right track. We need to see what command which is generated.

With Fox Tables now the problem is resolved....
I have added to the code fo the class:

	PROCEDURE BeforeInsert
		LPARAMETERS cFldState, lForce, cInsertCmd
		DoDefault(cFldState, lForce, cInsertCmd)

and at the beginning where i define the properties of the class

	InsertCmdDataSourceType = "ADO"
	UpdateCmdDataSourceType = "ADO"
	DeleteCmdDataSourceType = "ADO"

And in the Init method

		loCommand = Createobject('ADODB.Command')
		loCommand.ActiveConnection = loConnDataSource
		This.UpdateCmdDataSource=loCommand
		This.InsertCmdDataSource=loCommand
		This.DeleteCmdDataSource=loCommand

after the creatione fo the recordset
The last two corrections have been suggested some time ago by Çetin Basöz

I have still to verify if all the three insertions are necessary...

With SQL i have also the same problem even if i have to try to create again the table and test it with attention...