>>>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 ?
Sorry I don't understand 'compile' part.
Cetin