读书人

怎么用语句修改ACCESS2000字段允许空字

发布时间: 2013-03-27 11:22:42 作者: rapoo

如何用语句修改ACCESS2000字段允许空字符串?
如何用语句修改ACCESS2000字段允许空字符串?
[解决办法]
ses
ADOX_TLB;

procedure TForm1.Button1Click(Sender: TObject);
var
DS: string;
Catalog: _Catalog;
DBName : string;
begin
DBName := 'c:\test\test.mdb';
Catalog := CoCatalog.Create;
DS := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + DBName + ';Jet OLEDB:Engine Type=5';
Catalog.Set_ActiveConnection(DS);
Catalog.Tables['MyTable'].Columns['MyField'].Properties['Jet OLEDB:Allow Zero Length'].Value := True;
Catalog.Tables['MyTable'].Columns['MyField'].Properties['Nullable'].Value := True;

end;

读书人网 >.NET

热点推荐