createtable.asp

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

<!-- #include file="connmdb.asp" -->
<%
	if session("tablename") = "" then
		response.redirect "createnewtable.asp?error=1"
	end if
	if session("fieldname") = "" then
		response.redirect "createnewtable.asp?error=2"
	end if
	if session("charnum") = "" then
		response.redirect "createnewtable.asp?error=3"
	end if
	if session("primarykey") = "" then
		response.redirect "createnewtable.asp?error=4"
	end if

	dim tablename,fields,primarykey
	tablename = session("tablename")
	fields = session("fields")
	primarykey = session("primarykey")

	sql = "create table ["&tablename&"] ("&fields&"primary key (["&primarykey&"]))"
	conn.execute sql	
	
	session("tablename") = ""
	session("fieldname") = ""
	session("charnum") = ""
	session("fields") = ""
	session("primarykey") = ""

	response.redirect "tablelist.asp"
%>