Link to home
Start Free TrialLog in
Avatar of JP_Goblet
JP_Goblet

asked on

with CDaoRecordSet is it possible to change a field definition ?

i have a table with a text field whose definition does not allow empty string;
now i want to change this field definition to allow empty strings;

the table already has records so i can't simply delete the delete the field with CDaoTableDef::DeleteField
then recreate it  (CDaoTableDef::CreateField).

I don't see how to do that neither by the Cdao classes nor by SQL
ASKER CERTIFIED SOLUTION
Avatar of AndyAinscow
AndyAinscow
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JP_Goblet
JP_Goblet

ASKER

it works, thanks;
and i can also with the same method (accessing the DAO objects hidden within the CDao objects) rename a field, modify attributes of a relation, ...
It's neat, it took me a while to find this functionality some time ago.  Not everything available in DAO is exposed by the CDao classes (unfortunately).