addfield.asp

SmartCity远程数据库管理系统 本系统可使您不打开Microsoft Access也能在线轻松操作Access数据库

<!-- #include file="connmdb.asp" -->
<%
	dim tablename,fieldname,fieldtype,charnum,field
	tablename = request("tablename")
	fieldname = request("fieldname")
	fieldtype = request("fieldtype")
	charnum = request("charnum")
	field = "[" & fieldname & "] " & fieldtype
	if fieldtype = "text" then
		field = field & "(" & charnum & ")"
	end if

	sql = "alter table ["&tablename&"] add "&field&""
	conn.execute sql	

	response.redirect "addnewfield.asp?tablename="&tablename&""
%>