sql query

[akshita]

hi friends,

i am having one problem.i want to asign the value to a field when the table is created.

for eg in the query given below i want that password field should be assigned the value "doll" at the time when table is created.

strTable = "create table password1("
strTable = strTable & " password varchar(25),username varchar(50))"
Conn.Execute (strTable)


plzzzz suggest me the sol

akshita

 

[MarkSweetland]

Assuming you have the User's UserName (second column of your table) of you can do an INSERT right after the table is created by adding the following:

strTable = strTable & " GO INSERT INTO password1 VALUES ('doll','" & strUserName & "') GO"

Conn.Execute (strTable)


Mark