>>I have a cursoradapter class (ADO), i make a query on a table and i set buffering=3, i have set conversionfunc to convert empty date value to null, when i insert a new record i have an error. But if i use a little table (5 fields) no problem, i receive the error with another table (more than 100 fields in it).......where can be the problem ? The error is "Multiple-step OLE DB operation generated errors.
>>Check each OLE DB status value, if available. No work was done."........i have compiled the updatablefieldlist, but the updatenamelist is empty...because it is truncated with many fields...so i don't fill it.
>>Thanks
>
>You need updatablefieldlist and updatenamelist. You can do that in code. ie:
>
>

Define Class Ca_Person As CaBase Of ("CaBase.prg")
>  Alias = "Person"
>  SelectCmd = ;
>    "select personID, Firstname, Midname, Lastname, "+;
>    "Phone, Email, Address, City, State, Zip, "+;
>.............
>      Endif
>    Endif
>  Endproc
>Enddefine

My cursoradapter class is similar to your, but now i have this problem. My table has 3 fields (all char). I insert a new record and i compile only two fields. When i run the update command the return value is false and the update fails. I have set the conversionefunc for all the fields, but i have seen that the function E2n is launched only for the two compiled fields and not for the third that is empty, so i can trim this last field so the update fails...if i browse the table and i edi the third field without compiling it, but only deleting it, the update runs without problems.....where is my error ? Which values have you inserted in CaBase.prg ?