When altering a column the 'printout' sais "Adding Column."
The if structure shown in red below should fix this minor quirk.
if fAction = "ADD" or fAction = "ALTER" then
select case strDBType
case "access"
fType = replace(fType,"varchar","text")
case "sqlserver"
select case sqlVer
case 7
fType = replace(fType,"memo","ntext")
fType = replace(fType,"varchar","nvarchar")
fType = replace(fType,"date","datetime")
case else
fType = replace(fType,"memo","text")
end select
case "mysql"
fType = replace(fType,"#int","#int (11)")
fType = replace(fType,"#smallint","#smallint (6)")
end select
if fNull <> "NULL" then fNull = "NOT NULL"
strSql = strSQL & fName & " " & fType & " " & fNULL & " "
if fDefault <> "" then strSQL = strSQL & "DEFAULT " & fDefault
if fAction = "ADD" then
response.write "<b>Adding Column " & fName & "...</b><br>"
else
response.write "<b>Altering Column " & fName & "...</b><br>"
end if
else
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's