Uhlelo luhlelwe ngeGambas3 ne-Sqlite3: Isinyathelo ngesinyathelo.

Ngikulethela namuhla, isibonelo esenziwe ngelungu esikulesi sithangami http://www.gambas-es.org/, UDani26, owadala izifundo eziningi zamavidiyo ukuze achaze uhlelo lwakhe I-Agenda esebenzisa umphathi we-Sqlite3 database, ukuphatha idatha.

Uhlelo lwakho lwenza imisebenzi ejwayelekile:
- Faka Amarekhodi
- Hlela Amarekhodi
- Sesha Amarekhodi, ngegama.
- Susa Amarekhodi
- Dala umbiko, ngengxenye ye-gb.report

Umbiko odala uhlelo lwe-Ajenda

Ngikushiyela iphakethe lokufaka (.deb) ukuze ukwazi ukusebenzisa lolu hlelo, nekhodi yomthombo ukuyifunda, ukuze ukwazi ukulandela kangcono ukuphawula kwezifundo zevidiyo zeDani26.

Nazi izifundo zevidiyo zohlelo, ezenziwe igxathu negxathu:

Ividiyo 1: Ukwakha i-database

Ividiyo 2: Faka Amarekhodi

Ividiyo 3: Hlela futhi ususe amarekhodi

Ividiyo 4: Thola bese Ubika

Amanothi:
1) Sesha: Kwikhodi yomthombo ongayilanda, umusho we-sql wevidiyo:

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

Ngiyishintshele

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

Njengoba uphawu "%" lusebenza njengekhadi lasendle lisesha okuqukethwe. Ngakho-ke uma ngifuna igama elithi «ul«, Sizobonisa amarekhodi aqukethe igama elithi« Julio »,» uJulian »,» Zulan ', njll.

2) IGambas3 inenketho "yokungena okuzenzakalelayo", uDaniel angayisebenzisanga kumavidiyo akhe.

Lokhu kufakwa okuzenzakalelayo kungenziwa kusebenze kwimenyu «Ithuluzi / Okuncamelayo / Ukufomatha ikhodi / ukufometha lapho kulayishwa futhi kugcinwa»

Nika Amandla Ukufometha Kwekhodi Yomthombo Ozenzakalelayo

Fuentes: intambo yesithangami ukugembula-es.org & Gambeando Blog