Open
ADO Open metodi
❮ Record obyektining to‘liq ma’lumotnomasi
Open metodi mavjud Record obyektini ochadi yoki yangi fayl yoxud katalog yaratadi.
Sintaksis
Open(source,actconn,mode,createopt,opt,username,psword)
| Parametr | Tavsif |
|---|---|
| source | Ixtiyoriy. source parametri quyidagilardan biri bo‘lishi mumkin:
|
| actconn | Ixtiyoriy. Ulanish stringi yoki Connection obyekti |
| mode | Ixtiyoriy. Record obyektining kirish rejimini bildiruvchi ConnectModeEnum qiymati. Standart qiymati: adModeUnknown |
| createopt | Ixtiyoriy. Mavjud fayl/katalog ochilishi yoki yangi fayl/katalog yaratilishi kerakligini bildiruvchi RecordCreateOptionsEnum qiymati. Standart qiymati: adFailIfNotExists. Agar source parametri URL bo‘lmasa, bu parametr e’tiborga olinmaydi |
| opt | Ixtiyoriy. Record’ni ochish parametrlarini belgilovchi bir yoki bir nechta RecordOpenOptionsEnum qiymati. Standart qiymati: adOpenRecordUnspecified |
| username | Ixtiyoriy. source’ga kirishga ruxsat beruvchi foydalanuvchi ID’si |
| psword | Ixtiyoriy. username’ni tasdiqlovchi parol |
Misol
Example 1: source as the URL of a folder:
set rec = Server.CreateObject("ADODB.record")
rec.Open("https://www.w3schools.com/asp/")
Example 2: source as a relative URL in a Connection object:
set conn=Server.CreateObject("ADODB.Connection")
set rec = Server.CreateObject("ADODB.record")
conn.Open "URL=https://www.w3schools.com/asp/"
rec.Open("test.doc", conn)
Example 3: source as a row in a Recordset object:
set rs = Server.CreateObject("ADODB.recordset")
set rec = Server.CreateObject("ADODB.record")
rs.Open "test.doc", "URL=https://www.w3schools.com/asp/",,,adCmdTableDirect
rs.MoveLast()
rec.Open(rs)
ConnectModeEnum qiymatlari
| Konstanta | Qiymat | Tavsif |
|---|---|---|
| adModeUnknown | 0 | Standart qiymat. Ruxsatlar o‘rnatilmagan yoki ularni aniqlab bo‘lmaydi |
| adModeRead | 1 | Faqat o‘qish |
| adModeWrite | 2 | Faqat yozish |
| adModeReadWrite | 3 | O‘qish/yozish |
| adModeShareDenyRead | 4 | Boshqalarning o‘qish ruxsati bilan ulanish ochishiga yo‘l qo‘ymaydi |
| adModeShareDenyWrite | 8 | Boshqalarning yozish ruxsati bilan ulanish ochishiga yo‘l qo‘ymaydi |
| adModeShareExclusive | 12 | Boshqalarning ulanish ochishiga yo‘l qo‘ymaydi |
| adModeShareDenyNone | 16 | Boshqalarga istalgan ruxsatlar bilan ulanish ochishga imkon beradi |
| adModeRecursive | 0x400000 | Joriy Record’ning barcha quyi yozuvlariga (sub-records) ruxsatlarni o‘rnatish uchun adModeShareDenyNone, adModeShareDenyWrite yoki adModeShareDenyRead bilan birga ishlatiladi |
RecordCreateOptionsEnum qiymatlari
| Konstanta | Qiymat | Tavsif |
|---|---|---|
| adFailIfNotExists | -1 | Standart qiymat. Agar source parametri mavjud bo‘lmagan tugunga ishora qilsa, muvaffaqiyatsiz tugaydi |
| adCreateNonCollection | 0 | adSimpleRecord tipidagi yangi Record yaratadi |
| adCreateCollection | 0x2000 | source parametri ko‘rsatgan yangi Record yaratadi. Agar u mavjud tugunga ishora qilsa, xato yuz beradi. Xatoning oldini olish uchun bu qiymatni adOpenIfExists yoki adCreateOverwrite bilan birlashtiring |
| adOpenIfExists | 0x2000000 | Agar source mavjud tugun yoki Record obyektiga ishora qilsa, provayder yangisini yaratish o‘rniga mavjud Record’ni ochishi kerak. Bu qiymatni adCreateOverwrite bilan birga ishlatib bo‘lmaydi |
| adCreateOverwrite | 0x4000000 | Agar source mavjud tugun yoki Record’ga ishora qilsa, mavjud Record qayta yoziladi va uning o‘rnida yangisi yaratiladi. Bu qiymatni adOpenIfExists bilan birga ishlatib bo‘lmaydi |
| adCreateStructDoc | 0x80000000 | adStructDoc tipidagi yangi Record yaratadi |
RecordOpenOptionsEnum qiymatlari
| Konstanta | Qiymat | Tavsif |
|---|---|---|
| adOpenRecordUnspecified | -1 | Standart qiymat. Hech qanday parametr ko‘rsatilmagan |
| adOpenAsync | 0x1000 | Record obyektini asinxron rejimda ochadi |
| adDelayFetchStream | 0x4000 | Record bilan bog‘langan standart oqimni (stream) dastlab olish shart emas |
| adDelayFetchFields | 0x8000 | Record bilan bog‘langan maydonlarni dastlab olish shart emas, ular maydonga birinchi marta murojaat qilishga urinilganda olinishi mumkin |
| adOpenExecuteCommand | 0x10000 | source bajarilishi kerak bo‘lgan buyruq matnini o‘z ichiga oladi |
| adOpenOutput | 0x800000 | Agar source bajariladigan skriptni o‘z ichiga olgan tugunga ishora qilsa, ochilgan Record bajarilgan skript natijalarini o‘z ichiga oladi. Bu qiymat faqat kolleksiya bo‘lmagan yozuvlar bilan amal qiladi |
❮ Record obyektining to‘liq ma’lumotnomasi
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!