Soal UKK Materi MySQL Kelas XI SMK Semester 2 TA 2014/2015

<p><div style="text-align: justify;"> <span style="font-family: inherit;"><b>I. Berilah tanda silang (x) pada salah satu huru diantara a,b,c,d atau e jawaban yang paling benar.</b></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">1. Perangkat Lunak (Software) yang digunakan untuk mengelola kumpulan atau koleksi data, dimana data </span><span style="font-family: inherit;">tersebut diorganisasikan atau disusun ke dalam suatu model data disebut…</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Field b. Record c. DBMS d. Tabel e. Database</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">2. Microsoft Access adalah salah satu program aplikasi DBMS apa singkatan dari DBMS tersebut…</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Database Multiple System c. Database Management System e. Data Management </span><span style="font-family: inherit;">System</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">b. Database Management Supply d. Database Multidata System</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">3. Data yang terletak didalam satu kolom disebut…</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Field b. Record c. DBMS d. Tabel </span><span style="font-family: inherit;">e. Database</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">4. Data yang terletak di dalam satu baris dan mewakili satu objek disebut….</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Field b. Record c. DBMS d. Tabel </span><span style="font-family: inherit;">e. Database</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">5. Data yang menggambarkan kumpulan karakteristik suatu entitas….</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Field b. Record c. DBMS d. Tabel </span><span style="font-family: inherit;">e. Database</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">6. Perintah yang digunakan untuk memanipulasi data adalah….</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Report b. Query c. Form d. Tabel </span><span style="font-family: inherit;">e. Macro</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">7. Manakah dibawah ini yang bukan termasuk kedalam software pengolah data base….</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Ms­ Access b. Ms­ Word c. My SQL d. SQL Server </span><span style="font-family: inherit;">e. Dbase</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">8. Tipe data apakah yang panjang maksimalnya 255 karakter dapat menerima huruf, angka, spasi,</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">dan tanda baca….</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Text b. Memo c. Number d. Yes/No </span><span style="font-family: inherit;">e. Currency</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">9. Manakah yang termasuk cirri­ciri tipe data memo…..</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Panjang maximal 255 karakter, dapat menerima huruf, spasi dan tanda baca</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">b. Panjang maximal 2048 karakter</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">c. Panjang maximal 32000 karakter dapat menerima huruf, spasi dan tanda baca</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">d. Hanya menerima angka</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">e. Angka dalam format mata uang</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">10. Currency digunakan untuk tipe data…</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Huruf, angka spasi dan tandabaca c. Berisi gambar </span><span style="font-family: inherit;">e. Untuk alamat hyperlink</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">b. Angka dalam format mata uang d. Hanya menerima angka</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">11. Karakteristik dari suatu Entity yang menyediakan penjelasan detail tentang entity disebut</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Data Field b. Data Record c. Attribut d. Entity </span><span style="font-family: inherit;">e. Relation Ship</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><b>Gunakan tabel berikut ini untuk No. 12 – 14</b></span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXx6fHIVUuz4ZGFUI1J-WXVIvH-He1zWpIgALDK3-xWS-cVJrtZEQ-ICx6n2rbM-6rqe0XHYXRUtvVNOgkrEyVUrC4adF-FxiAGg3P0O8mL1uQPutkU3vMwXDiHZBFLsxDVLIMs-BOvW0/s1600/BAN+SM.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="82" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXx6fHIVUuz4ZGFUI1J-WXVIvH-He1zWpIgALDK3-xWS-cVJrtZEQ-ICx6n2rbM-6rqe0XHYXRUtvVNOgkrEyVUrC4adF-FxiAGg3P0O8mL1uQPutkU3vMwXDiHZBFLsxDVLIMs-BOvW0/s400/BAN+SM.gif" width="400" /></a></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">12. Tipe data apakah yang sesuai untuk field No_Telp</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Text b. Memo c. Number d. </span><span style="font-family: inherit;">Date/Time e. Currency</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">13. Tipe data apakah yang sesuai untuk field NIS</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Text b. Memo c. Number d. </span><span style="font-family: inherit;">Date/Time e. Currency</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">14. Manakah primary key yang tepat dari tabel tersebut</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. NIS b. Nama c. Alamat d. No_telp e. </span><span style="font-family: inherit;">Tidak perlu Primary Key</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">15.Ciri dari Primary Key adalah ....</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Bersifat unik c. Bersifat umum e. </span><span style="font-family: inherit;">Memiliki kesamaan data dengan</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">b. Mudah dihapal d. Sulit dihapal atribut </span><span style="font-family: inherit;">lainnya</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">16. Sql dipublikasikan oleh :</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. E.F Codd b. D. Chamberlin c. R.F Boyce d. Euler </span><span style="font-family: inherit;">e. Albert eisten</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">17. Berikut ini adalah sasaran dari SQL, kecuali :</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Menciptakan basis data dan struktur relasi </span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">b. Membuat pemrograman terstruktur dengan grafis </span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">c. Melakukan menajemen data tingkat dasaar</span></div> <div style="text-align: justify;"> d. Harus portable</div> <div style="text-align: justify;"> e. <span style="font-family: inherit;">Mengelompokan data yang komplek</span></div> <div style="text-align: justify;"> <br /></div> <div style="text-align: justify;"> <span style="font-family: inherit;">18. Salah satu contoh data manipulation language :</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. ALTER TABLE b. CHAT c. SELECT d. UNLOAD </span><span style="font-family: inherit;">e. REVOKE</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">19. Berikut ini cara penulisan membuat database SISWA yang benar adalah…</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. CREATE DB SISWA c. CREATE SISWA e. CREATE </span><span style="font-family: inherit;">DATABASE SISWA</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">b. CRET DATABASE SISWA d. CREATE DATABASE</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">20. </span><span style="font-family: inherit;">Tampilkan semua data nilai dimana nilai MID lebih besar sama dengan60 atau nilai finalnya leb</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">ih besar 75.maka penulisannya query nya adalah:</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. SELECT * FROM NILAI WHERE MID <= 60 OR FINAL < 75</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">b. SELECT * FROM NILAI WHERE MID >= 60 OR FINAL < 75</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">c. SELECT * FROM NILAI WHERE MID <= 60 OR FINAL > 75</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">d. SELECT * FROM NILAI WHERE MID >= 60 OR FINAL > 75</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">e. SELECT * FROM NILAI WHERE MID 60 OR FINAL < 75</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">21. Ubah panjang kolom MTKULIAH menjadi 30 char, maka penulisannya query nya adalah:</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. ALTER TABLE MKUL VALUES (MTKULIAH char(30));</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">d. ALTER TABLE MKUL UPDATE (MTKULIAH char(30));</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">b. ALTER TABLE MKUL ADD (MTKULIAH char(30));</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">e. ALTER TABLE MKUL MODIFY (MTKULIAH char(30));</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">c. ALTER TABLE MKUL DROP(MTKULIAH char(30));</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">22. Apakah kepanjangan dari SQL …</span></div> <div style="text-align: justify;"> a. System Query Language</div> <div style="text-align: justify;"> b. Standart Quantum Language</div> <div style="text-align: justify;"> c. Standart Query Language</div> <div style="text-align: justify;"> d. Structured Query Language</div> <div style="text-align: justify;"> e. <span style="font-family: inherit;">Scroll Query Language</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">23. Pengembangan MySQL dengan tool database UNIREG dibuat oleh…</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. E.F Codd b. Michael Widenius c. R.F Boyce d. David </span><span style="font-family: inherit;">Artmax e. David Moyes</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">24. Program desktop yang sering dipakai untuk membuat program koneksi database adalah...</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Visual studio b. MySQL Workbanch c. Visual basic d. </span><span style="font-family: inherit;">Autocad e. Ms. Acces</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">25. Tool yang digunakan untuk mengoneksikan database di dalam menu VB 6.0 adalah...</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">a. Adodc b. Datagrid c. SQL Conector d. </span><span style="font-family: inherit;">Toolbox e. Label</span></div> <div style="text-align: justify;"> <br /></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><br /></span></div> <div style="text-align: justify;"> <br /></div> <div style="text-align: justify;"> <span style="font-family: inherit;"><b>II. Jawablah pertanyaan berikut ini dengan benar?</b></span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">1. Jelaskan perbedaan antara MySQL dan SQL ?</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">(point 4)</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">2. Sebutkan fitur­fitur keistemewaan MySQL ?</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">(point 5)</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">3. Sebutkan struktur dasar perintah­perintah table</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">? (point 5)</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">4. Jelaskan pengertian SELECT dan berikan contohnya ?</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">(point 6)</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">5. Buatlah database <namakalian> dengan format : table <customer> , filed< kdcust, nmcust,</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">alamatcust, tgl_lahircust, beratcust, tinggicust, goldarahcust,notelpcust, emailcust> ?</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">(point 10)</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">6. Kerjakan sesuai kelompok masing­masing?</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">7. Kerjakan sesuai kelompok masing­masing?</span></div> <div style="text-align: justify;"> <span style="font-family: inherit;">8. Kerjakan sesuai kelompok masing­masing?</span></div> </p>

I. Berilah tanda silang (x) pada salah satu huru diantara a,b,c,d atau e jawaban yang paling benar. 1. Perangkat Lunak (Software) yang di...

Cara Membuat Koneksi ke MySQL dengan Visual Foxpro

<p><h3 class="post-title entry-title" itemprop="name" style="font-weight: normal; margin: 0.75em 0px 0px; position: relative;"> <span style="background-color: white; font-family: inherit; line-height: 1.4;"><span style="font-size: small;">Pertama buatlah project baru, kemudian pada tab documents buatlah form baru serperti berikut ini :</span></span></h3> <div class="post-body entry-content" id="post-body-7214039578333456091" itemprop="description articleBody" style="line-height: 1.4; position: relative; width: 490px;"> <div dir="ltr" trbidi="on"> <span style="background-color: white; font-family: inherit;"><br /></span><div class="separator" style="clear: both; text-align: center;"> <span style="background-color: white; color: black; font-family: inherit;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKQo9BxrHsXgD0IfYosUNCa6qhV40y23Obbw937RFYhrJBjjVhKlfRPQ7GtyBTIq-b_ZjG-dvWv1W44r9D2p79_pm0X6qxQ-Zla_J4w0ulENNerQs_yW-mdfYy-agvnbjPZ18LuWiZfNYP/s200/krowak.JPG" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(235, 235, 235); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" width="300" /></span></div> <span style="background-color: white; font-family: inherit;"><br /><br />Atur Properties masing-masing object.<br /><a href="https://www.blogger.com/null" name="more"></a><br /></span><table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; border: medium none;"><tbody> <tr><td style="border: 1pt solid windowtext; padding: 0cm 5.4pt; width: 147.6pt;" valign="top" width="197"><div class="MsoNormal"> <b><span style="background-color: white; font-family: inherit;">Object<o:p></o:p></span></b></div> </td><td style="border-style: solid solid solid none; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 91.8pt;" valign="top" width="122"><div class="MsoNormal"> <b><span style="background-color: white; font-family: inherit;">Properti<o:p></o:p></span></b></div> </td><td style="border-style: solid solid solid none; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 203.4pt;" valign="top" width="271"><div class="MsoNormal"> <b><span style="background-color: white; font-family: inherit;">Nilai<o:p></o:p></span></b></div> </td></tr> <tr><td style="border-style: none solid solid; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 147.6pt;" valign="top" width="197"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Form1<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 91.8pt;" valign="top" width="122"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Caption<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Autocenter<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">ShowWindow<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">WindowsType<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 203.4pt;" valign="top" width="271"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Form Koneksi<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">.T.-True<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">1 - In Top-Level Form<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">1 - Modal<o:p></o:p></span></div> </td></tr> <tr><td style="border-style: none solid solid; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 147.6pt;" valign="top" width="197"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Label1<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 91.8pt;" valign="top" width="122"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Caption<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">BackStyle<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 203.4pt;" valign="top" width="271"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Database Name<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">0 - Transparent<o:p></o:p></span></div> </td></tr> <tr><td style="border-style: none solid solid; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 147.6pt;" valign="top" width="197"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Label2<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 91.8pt;" valign="top" width="122"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Caption<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">BackStyle<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 203.4pt;" valign="top" width="271"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">User Name<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">0 - Transparent<o:p></o:p></span></div> </td></tr> <tr><td style="border-style: none solid solid; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 147.6pt;" valign="top" width="197"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Label3<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 91.8pt;" valign="top" width="122"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Caption<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">BackStyle<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 203.4pt;" valign="top" width="271"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Password<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">0 - Transparent<o:p></o:p></span></div> </td></tr> <tr><td style="border-style: none solid solid; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 147.6pt;" valign="top" width="197"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Text1<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 91.8pt;" valign="top" width="122"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Name<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Maxlength<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Special Effect<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Border Style<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 203.4pt;" valign="top" width="271"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Vdata<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">40<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">1-Plain<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">0-None<o:p></o:p></span></div> </td></tr> <tr><td style="border-style: none solid solid; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 147.6pt;" valign="top" width="197"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Text2<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 91.8pt;" valign="top" width="122"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Name<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Maxlength<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Special Effect<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Border Style<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 203.4pt;" valign="top" width="271"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Username<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">40<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">1-Plain<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">0-None<o:p></o:p></span></div> </td></tr> <tr><td style="border-style: none solid solid; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 147.6pt;" valign="top" width="197"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Text3<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 91.8pt;" valign="top" width="122"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Name<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Maxlength<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Special Effect<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Border Style<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;"><o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 203.4pt;" valign="top" width="271"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Passwd<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">40<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">1-Plain<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">0-None<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;"><o:p></o:p></span></div> </td></tr> <tr><td style="border-style: none solid solid; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 147.6pt;" valign="top" width="197"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Command1<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 91.8pt;" valign="top" width="122"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Caption<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Name<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 203.4pt;" valign="top" width="271"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">connect<br /><br /><br /><connect><o:p></o:p></connect></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Command1<o:p></o:p></span></div> </td></tr> <tr><td style="border-style: none solid solid; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 147.6pt;" valign="top" width="197"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Command2<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 91.8pt;" valign="top" width="122"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Caption<o:p></o:p></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Name<o:p></o:p></span></div> </td><td style="border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 203.4pt;" valign="top" width="271"><div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">batal<br /><br /><br /><batal><o:p></o:p></batal></span></div> <div class="MsoNormal"> <span style="background-color: white; font-family: inherit;">Command2<o:p></o:p></span></div> </td></tr> </tbody></table> <span style="background-color: white; font-family: inherit;"><br /><br />Buatlah Method dengan nama nilai_awal pada menu form-> New Method,kemjudian buatlah property dengan nama baru, koneksi dan namakursor pada menu form->New Properties.<br />Kemudian ketikkan code propgram seperti berikut ini :<br /><br />Object : Form1 Procedure : nilai_awal<br />THISFORM.vdata.VALUE=" "<br />THISFORM.username.VALUE=" "<br />THISFORM.passwd.VALUE=" "<br />THISFORM.REFRESH<br />thisform.vdata.SetFocus<br /><br />Object : Form1 Procedure : Activate<br />_screen.visible=.f.<br /><br /><br />Object : vdata Procedure : valid<br />IF EMPTY( THISFORM.vdata.VALUE )<br />RETURN 0<br />ENDIF<br /><br />Object : username Procedure : valid<br />IF EMPTY( THISFORM.vdata.VALUE )<br />RETURN 0<br />ENDIF<br /><br />Object : passwd Procedure : valid<br />IF EMPTY( THISFORM.vdata.VALUE )<br />RETURN 0<br />ENDIF<br /><br />Object : command1 Procedure : click<br />vdbase = ALLTRIM(thisform.vdata.Value)<br />vuser = ALLTRIM(thisform.username.Value)<br />vpass = ALLTRIM(thisform.passwd.Value)<br />vport = "3306"<br />mstr = [DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Port=&vport;Database=&vdbase;User=&vuser;Password=&vpass;]<br /><br />THISFORM.Koneksi = SQLSTRINGCONNECT( mstr )<br />IF THISFORM.Koneksi <= 0 =MESSAGEBOX("Koneksi Ke Server Database MySQL Gagal", 0+16, "Konfirmasi") ELSE =MESSAGEBOX("Koneksi Ke Server Database MySQL Berhasil", 0+64, "Konfirmasi") ENDIF THISFORM.namakursor = "QT"+SUBSTR(SYS(2015), 5) thisform.nilai_awal() koneksi = thisform.koneksi namakursor=thisform.namakursor thisform.Release Object : command2 Procedure : click thisform.</span></div> </div> </p>

Pertama buatlah project baru, kemudian pada tab documents buatlah form baru serperti berikut ini : Atur Properties masing-masing objec...