can i change a filled dataset's column from type string to boolean?
Posted on 2004-11-08
hi,a field in my database is not boolean and i cant change it.
instead, it is filled with Y or N values.
now what i need to do is fill MyDataset from a dataadapter.
but now the MyBoolean field of MyDataset is of type string
now i say
for i = 0 to MyDataset.MyTable.Count -1
if mydataset.mytable(i)(MyBoolean) = Y then
mydataset.mytable(i)(MyBoolean) = True
mydataset.mytable(i)(MyBoolean) = False
can i change this type from string to boolean somehow?