>>>>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...