Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Open)
 Bug: admin_mod_dbsetup (minor)
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Nathan
Help Moderator

USA
7664 Posts

Posted - 06 April 2002 :  14:02:35  Show Profile  Visit Nathan's Homepage
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

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 06 April 2002 :  17:51:04  Show Profile  Visit HuwR's Homepage
we spotted, I gues I missed that when I merged the functions together.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07