Jadawalin da aka tsara tare da Gambas3 da Sqlite3: Mataki zuwa mataki.

Na kawo muku yau, misalin da wani ɗan ƙungiyar memba ɗin ya yi http://www.gambas-es.org/, Dani26, wanda ya kirkiro koyarwar bidiyo da dama don bayyana shirin sa Tsari wanda ke amfani da mai sarrafa bayanan Sqlite3, don ɗaukar bayanan.

Shirye-shiryen ku yayi ayyukan yau da kullun:
- Recordara Rikodi
- Shirya Rikodi
- Binciken Bayanai, da suna.
- Share Rikodi
- Createirƙiri rahoto, tare da ɓangaren rahoton gb.report

Rahoton samarda tsari

Na bar muku kunshin shigarwa (.deb) don ku sami damar amfani da shirin, da lambar tushe don nazarin shi, don haka kuna iya bin ra'ayoyin koyarwar bidiyo ta Dani26.

Da ke ƙasa akwai koyarwar bidiyo na shirin, an yi mataki zuwa mataki:

Bidiyo na 1: Creatirƙirar bayanan

Bidiyo 2: Addara Rikodi

Bidiyo na 3: Shirya da Share Rikodi

Bidiyo ta 4: Nemo kuma Ka Ba da rahoto

Bayanan kula:
1) Bincika: A cikin lambar tushe wanda zaku iya zazzagewa, hukuncin sql na bidiyo:

Select * from Amigos where nombre like '" & filtro & "'"

Na canza shi ne don

Select * from Amigos where nombre like '%" & filtro & "%'"

Tunda alamar "%" tana aiki azaman katin daji don bincika abubuwan ciki. Don haka idan na nemi kalmar «ul«, Zai nuna bayanan da ke ɗauke da suna« Julio »,» Julian »,» Zulwani ', da dai sauransu

2) Gambas3 yana da zaɓi na "shigar da kai tsaye", wanda Daniel bai yi amfani da shi ba a cikin bidiyonsa.

Ana iya kunna wannan shigarwar ta atomatik a cikin menu «Kayan aiki / Zaɓuɓɓuka / Tsarin Tsarin / Tsara lokacin lodawa da adanawa»

Enable Tsarin Tushen atomatik Tsarin

Harshen Fuentes: dandalin zare gambas-es.org & Gambeando Blog