I often develop asp, but I am not very clear about the detailed statements. Here is a brief introduction.
Generally
Rs. open SQL, conn, are used to read data.
Modify data: rs. open SQL, conn, 1, 3
Delete data: You can directly delete data such as
Often develop ASP but for the meticulous statement, the truth is not very clear, here a simple introduction.
Under normal circumstances
Read the data with Rs.Open sql,conn,1,1
Modifying data: Rs.Open sql,conn,1,3
Delete data: Directly to
Rs. Open
SQL, Conn and conn.exe cute (SQL)
Use conn.exe cute (SQL)If you want to perform complex operations on the database! It is better to use Rs. Open SQL, Conn
Rs. Open SQL, Conn: A record set is returned. This record set can be moved before
Transaction operation data:
(1)
Eg:
Assume that the Bank Transfer System
Transfer from Michael Jacob's account to Mr. Luo's account of 1000 yuanThis operation takes two steps.1. Michael's account is reduced by 1000 RMB2. Mr. Luo's account was
Reference: Rs. open SQL, Conn, A, B A: adopenforwardonly (= 0) read-only, and the current data record can only be moved downward adopenkeyset (= 1) read-only, the current data record can be freely moved to adopendynamic (= 2) and read/write. The
Rs. Open SQL, Conn, are used to read data.
Modify data: Rs. Open SQL, Conn, 1, 3
Delete data: You can directly delete data such as conn.exe cute ("delete * From New where id = 1.
Rs. Open Syntax: Rs. Open source, activeconnection, cursortype,
SQLite3 database operations related to Python development [connection, query, insert, update, delete, close, etc.], pythonsqlite3
This article describes how to develop a SQLite3 database using Python. We will share this with you for your reference.
Problem:Sql> Conn/as SYSDBAERROR:Ora-09817:write to audit file failed.Linux-x86_64 Error:28:no space left on deviceAdditional Information:12Ora-01075:you is currently logged onAnalysis Reason: (after Baidu query cause is audit the file system is
Prototype:
Recordset. Open source, activeconnection, cursortype, locktype, options Parameters:
The first parameter is an SQL statement.
Number 2: Conn, that is, database connection
Third parameter: cursortype | cursor type-1 --
Rs. Open SQL, Conn, a, BParameter A is the type of the Set cursor, and its value is:0: Only forward cursor. Only forward browsing records are supported. pagination, recordset, and bookmark are not supported.1. keyset cursor. The changes made by
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.