Recommended: Asp timed execution operations, Asp timed reading database (detailed explanation of web page timing operations) Asp timing operation, Asp timing reading database (detailed explanation of web page timing operation) '----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Generally, when operating Access databases, there are Alter statements, and the basic syntax difference between them and MsSQL2k is not too much. For example, create a new column statement in a certain table:
| Dimsqlstr sqlstr=altertablel_infoaddcolumninfo_filevarchar(200)defaultNULL conn.execute(sqlstr) |
The above statement creates the column info_file in l_info, which is the text type, and the length is 200. If there is no other setting, the default is:
Required fields: No
Allow empty characters to be created: No
If this empty string is generally not satisfied if it is allowed, then there is ADOX space processing.
For details, please visit: Introduction to Microsoft ADOX
This examples is surprisingly surprising, you can visit here to view all of them.
Here is one example: many functions can be implemented:
| SubAddHelpColumn() DimoConn, oCat, oColumn 'Open the database SetoConn=Server.CreateObject(ADODB.Connection) oConn.OpenMM_conn_STRING 'Open the table SetoCat=Server.CreateObject(ADOX.Catalog) SetoCat.ActiveConnection=oConn 'Create a column SetoColumn=Server.CreateObject(ADOX.Column) WithoColumn Set.ParentCatalog=oCat'Mustsetbeforesettingproperties .Name=memHelp .Type=adLongVarWChar .Properties(Nullable)=True .Properties(JetOLEDB:AllowZeroLength)=True EndWith oCat.Tables(MetaExternalFields).Columns.AppendoColumn 'Finish SetoColumn=Nothing SetoCat=Nothing oConn.Close() SetoConn=Nothing EndSub |
The members of the collection Column are:
| Ittemproperty Countproperty. Deletemethod. Refreshmethod. |
For details, please refer to: Column object, not table.
Share: Teach you how to use ASP to create website forums DIY(1) Preface: There are now forums everywhere on the Internet, but I wonder if you have encountered this situation: finding what you want in the messy discussion information is a time-consuming and laborious thing. Later, you don’t want to go to any forums. So can we be right