creating the database

[akshita]

hi friends,


i am creating database through code in vb.now when i create table i want to give a particular field should have "allow zero length" to be true .i.e it should accept null values

for example in this suppose i want that recdate should accept null values.

strTable = "create table tdialogic1("
strTable = strTable & " srno varchar(50),name varchar(40)NULL,disdate datetime,dudate datetime ,recdate varchar(20)NULL )"
Conn.Execute (strTable)


how can i do it

akshita