最近几年来，地理信息系统无论是在理论上还是应用上都处在一个飞速发展的阶段。 GIS被应用于多个领域的建模和决策支持，如城市管理、区划、环境整治等等，地理信息成为信息时代重要的组成部分之一； “数字地球”概念的提出，更进一步推动了作为其技术支撑的GIS的发展。 与此同时，一些学者致力于相关的理论研究，如空间感知、空间数据误差、空间关系的形式化等等。 这恰好说明了地理信息系统作为应用技术和学科的两个方面，并且这两个方面构成了相互促进的发展过程。
We can use SQL’s We hope to offer When the user presses the confirm button, the form is sent to a file named “demo_add.asp”. The file “demo_add.asp” contains files that can be directed to Before you use the If the table contains a primary key, make sure that the value added to the primary key field is unique and not empty (otherwise If the table contains an auto-numbered field, do not use the In the MS Access database, if you set the Note: not all databases support zero-length strings, so errors may occur when adding records with blank fields. Therefore, it is important to check the data types supported by the database you are using. INSERT INTO command to add records to the table in thedatabase.Add records to tables in the database ¶
Northwind in the database Customers table to add a new record. We start by creating a form that contains the input fields from which we need to collect data:<html> <body> <form method="post" action="demo_add.asp"> <table> <tr> <td>CustomerID:td> <td><input name="custid">td> tr><tr> <td>Company Name:td> <td><input name="compname">td> tr><tr> <td>Contact Name:td> <td><input name="contname">td> tr><tr> <td>Address:td> <td><input name="address">td> tr><tr> <td>City:td> <td><input name="city">td> tr><tr> <td>Postal Code:td> <td><input name="postcode">td> tr><tr> <td>Country:td> <td><input name="country">td> tr> table> <br><br> <input type="submit" value="Add New"> <input type="reset" value="Cancel"> form> body> html>
Customers the table adds the code for a new record: <html> <body> <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open "c:/webdata/northwind.mdb" sql="INSERT INTO customers (customerID,companyname," sql=sql & "contactname,address,city,postalcode,country)" sql=sql & " VALUES " sql=sql & "('" & Request.Form("custid") & "'," sql=sql & "'" & Request.Form("compname") & "'," sql=sql & "'" & Request.Form("contname") & "'," sql=sql & "'" & Request.Form("address") & "'," sql=sql & "'" & Request.Form("city") & "'," sql=sql & "'" & Request.Form("postcode") & "'," sql=sql & "'" & Request.Form("country") & "')" on error resume next conn.Execute sql,recaffected if err<>0 then Response.Write("No update permissions!") else Response.Write("
" & recaffected & " record added") end if conn.close %> body> html>
Important matters ¶
INSERT command when using the command, please note the following:
provider this record will not be appended, or an error will occur) INSERT . This field is involved in the command (the value of this field is determinedby the provider responsible) About No data Field ¶
AllowZeroLength property is set to “Yes”, and you can enter zero-length strings (“”) in text, hyperlinks, and memo fields.