Re: CRecordset::Delete() Error

[Brandon Jensen]

Thanks for the help, but that wasn't it.

I'm using VC++ and for some reason either ODMC32.dll file or MyODBC connector doesn't work with VC++. Take a look at what I tested. (I wish I could just upload my program to everyone :( ) I've created a table as shown below:

create table tag
( tag_id int not null,
contract_id char(6) not null,
crop_year int unsigned not null,
usda_no char(8) not null,
moisture float(5,2), # will delete
sub_std float(5,2), # will delete
b_grade float(5,2), # won't delete
mold float(5,2), # won't delete

primary key(tag_id, usda_no, contract_id, crop_year)
);

When using the above table, I can't delete any records through MyODBC. However, if I remove 'b_grade' and 'mold' for my column list everything works fine. They are implemented in exactly the same way in my code, but somehow are handled differently? I don't get this. Even if I remove 'moisture' and 'sub_std' I still can't update or delete a record. I've even tried changing column types to double and changing the column names, and it still doesn't work.

Has anyone else run into this problem?

Again any help would be greatly appreciated. And thanks again.

- Brandon