在线数据库管理工具(db007) v1.5

可能会导致数据损坏或丢失。</font><br>"
echo "你可以将："
echo "<select name=''keyname''>"
For i=0 to rs.fields.count-1
echo "<option value=" & rs(i).name & ">" & rs(i).name & "</option>"
next
echo "</select> "
echo "<input type=button value=设为主键 onclick=""location.href=''?key=sql&sql=ALTER TABLE ["&table_name&"] ADD PRIMARY KEY ([''+keyname.value+''])'';"">"
echo "<br><br>"
end if
''显示修改字段名
echo "<select name=''fieldsname''>"
echo "<option value=''''>选择字段</option>"
echo editstr
echo "</select> 改名为 " & chr(10)
echo "<input type=''text'' name=''newfieldsname'' size=''20''> " & chr(10)
echo "<input type=button value=修改字段名 onclick=""location.href=''?key=reobj&obj=field&tablename="&table_name&"&fieldsname=''+fieldsname.value+''&newfieldsname=''+newfieldsname.value"">"
echo "<br><br>"
end if
rs.close
set rs = nothing
%>
<font color=red>增加字段：</font><br><br>
<form action="?key=addfield" method="post">
<table width="600" height="39" border="0" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="60" height="20" align="center">字段名</td>
<td width="50" height="20" align="center">类型</td>
<td width="58" height="20" align="center">设定大小</td>
<td width="64" height="20" align="center">允许空值</td>
<td width="66" height="20" align="center"> 自动编号</td>
<td width="96" height="20" align="center"> </td>
</tr>
<tr>
<td width="60" height="20" align="center">
<input type="text" name="fldname" size="10">
</td>
<td width="50" height="20" align="center">
<% fieldtypelist(0) %>
</td>
<td width="58" height="20" align="center">
<input type="text" name="fldsize" size="10">
</td>
<td width="64" height="20" align="center">
<input name="null" type="checkbox" value="ON" checked>
</td>
<td width="66" height="20" align="center">
<input type="checkbox" name="autoincrement" value="ON">
</td>
<td width="96" height="20" align="center">
<input type="hidden" name="table_name" value="<%=table_name%>">
<input type="submit" value="提交">
</td>
</tr>
</table>
</form>
<%
end sub

''==================================================================修改字段属性的界面
s