Look at this problem? Rs.open sgl, conn,3,3 When asked, what is meant by that 3,3, 1,3 met before as if Who can help me explain under ah, thank you

RS.OPEN SQL, CONN, A, B SQL database query code such as : "select * from user" user query from the table -- all records CONN database connection parameters : A : ADOPENFORWARDONLY (0) CD, and the current record only to scale down action ADOPENSTATIC (= 3) read-only, free movement of current data records ADOPENKEYSET (= 1) reading and writing, the free movement of current data records ADOPENDYNAMIC (= 2), literacy, free movement of current data records, we can see new record B : ADLOCKREADONLY (= 1) default values used to open the CD recording ADLOCKPESSIMISTIC (BMD) pessimistic locking ADLOCKOPTIMISTIC (= 3) optimistic locking ADLOCKBATCHOPTIMISTIC (= 4) installment optimistic locking

I know the meaning, but the specific time for a particular ah? Which is generally used?

General and often used is 1,1 1,3 If you just sensed data from the database, without any changes, then we use 1,1 If the library needs to delete, insert, modify, etc, using 1,3 Of course, I just used. .

That is the meaning of 3,3 ah, I usually use 3,3

[ Closed window ]