Re: Nullable attribute on field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Val Mazur (group51a_at_hotmail.com)
Date: 10/06/04 

Date: Tue, 5 Oct 2004 22:27:19 -0400

Hi,

Do you need to change it is a recordset or database? In case of the
recordset, you cannot do this on opened recordset. Once recordset is opened,
you are not allowed to change datatypes of the fields or their attributes.
To do this, you would need to save recordset as XML into XML DOM and modify
that XML representation of the recordset. Then load XML back into recordset.
In a case if you need to change attribute of the column in a database, then
you could use ALTER TABLE data definition statement to do this 

-- 
Val Mazur
Microsoft MVP
"Sławomir Dobrzański" <dobrzanskinews@wp.pl> wrote in message 
news:cjs1am$n27$1@atlantis.news.tpi.pl...
> Because of my client wish I have to turn on and off (when client click on
> button i dialog) nullable attribute of a field. How to do this in the most
> safe way achieving best performance results?
> Please help! I tried some simple attribute setting but it doesn't seem to
> work.
>
> Thanks
>
>
Quantcast