Daata
Daatu giggishsho qooli dooramino qorqorshiwidira daatu bue gaama fajjanno.
daatu beezete ledo xaadi formera, fiixoonsantino daata beeze xawisantanno dargiFormete Akatta. Tennera assoote afi'rattohuData giggishshote qoolira aanaati.
Dandaantannoti daatu giggishsho qooli qorqorshiqinaawo kaima assidhannohu lasaawanno qorqorshi aanaati.La"a dandiinannihu xaa qorqorshira afantanno doodho callatenna eigaraho.
Buete bisicci hakki-geeshsho
Eo amadino bisicci hakkigeeshsho dirtote saaxinera woy xaadisaaxinete ispiriidishittete aana eessi. Miteekkine baci-caccafo hakkigeeshshoeessiniha ikkro, caccafonniti rooriidi guraadi widi amado calla qorqorsha wonshate horoonsantanno.
Daatu bare
Qorqorshu maqishshantino daati bue shae badanno. Daatabeezete formuwinni, qorqorshuwa daatu bare ledo xaadisa dandiinanni.
Fakkana injo heedhannohe:
-
Umi hajo: Formete giddo mitte shae calla heedhanno.
Daatu bare hunda, amadosi reqeccishshantara hasi'nanni shae bare daatibue badanno.
-
Layinki hajo: Qorqorshu SQL xa'monni kalaqantino cinaancho formeho.
Daatu bare hunda,amadosi reqeccishantara hasi'nannita SQL yaatto bare badanno.
-
Saki hajo: Xaadi saaxinna
xaadi saaxinnate, hornyo e'annowi daatu bue shae bare hornyo e'annowi woy horoonsi'raanchunni doorantinoti kuusama hasiissannosetidaati bare hundabadantinota ikka noose. Xaadi saaxinete dirto giddo reqeccishantino hornyuwi SQL yaatto kaima assidhinote,hattino e'inohuAmado Dirtohundaati.
-
Shoolki hajo: Dirtote Saaxinna
Daatu bue shae reqeccishama hasiissannosi daata giddose diamaddino, kayinni hakkunninninni shae gutu daati bare giddoonni daatu buewa xaaddinote.
Xaa daati bue shae ledo xaadooshshu noosi dirto saaxine shaete giddonni reqeccishantara hasi'nanniha ikkro,Daat bare hunda dirtote saaxinna amdo maqishantannoha daatu bue dirto bare baddanno. Woy formete giddo daatu reqeccishsho qorqorannoha daatubeeze bare bada dandiinanni. Tini daatu bare wole shae ledo xaadu hee'ranno gede assiissannohu lamenti shauwi guti daati barenni xaada dandiirooti. Duuchawote tini baxxitino badooshshi kiiro kuusantanno daati bareeti.Formete giddo amadosi reqeccishantanno daati bare SQL yaattonni badantannoti Amado Dirtohunda badante egennantannote.
Dirtote saaxinna maqishshuwatenni loossaanno.Insano mittowidoo assamate dandiitanohu xaaddino sha'anni SQL yaattonni (shoolki hajo) woy hornyote dirto giddoonni:
Maqishshamannohu xaaddino sha'a widoonniiti(SQL yaattuwi)
Forme kaima assidhinoti gutu daati barenni shaete ledo xaaddinota dirtote saaxine daatubeeze shae aana reqeccishate hasi'niha ikkiro, xaadisantinoti formete shaeDaati barehunda badante egennantanno.
Xaadooshshu kalaqaminohu SQL Dooramanniiti, hakkuno, "SQL" doorriha ikkiro woy "Native SQL" doortoro hunda dirtote amado dani hunda badante xawisantanno.lawishshu gedera, "Aantuwu" xaa forme qorqorshi ledo xaadinoho, nna daatabeezete giddo "Woyyeessaanchu" shae "aantuwate" shae ledo xaaddinote. SQL yaatto aananno garinni horoonsi'ra dandiinanni:
SELECT CustomerName, CustomerNo FROM Woyyeessaano,
"CustomerName" Xaadisantino shae wiinni fulanno daati bare ikitanna "Woyyeessaano", nna "CustomerNo" shaete bare "Woyyeesaano" formete shae ledo xaaddino shae "Aante"Daatu barehunda baddanno.
Hornyu Dirto Horoonsidhanno Maqishshuwi
Dirtote saaxinnara, hornyote dirto horoonsi'ra dandiinani. Hornyote dirto yaamantannoti maqishshu hornyuwa xawisseemme honyuwaati. Konni garinni, formete giddo qorqorshi daatabeezete bare amado daggu garinni reqeccishanno yaa dikkino, kayinnilla hornyote dirto giddo gaamantinota reqeccishanno.
If you work with reference values of a value list, the contents of the data field that you specified under Data Field in the form are not visible, but rather the assigned values. If you chose "Valuelist" on the Data tab under Type of list contents and assigned a reference value to the visible list entries in the form under List entries (entered in the General tab), then the reference values are compared with the data content of the given data field. If a reference value corresponds to the content of a data field, the associated list entries are displayed in the form.
Dirto amado
With database forms, specifies the data source for the list content of the form-element. This field can be used to define a value list for documents without a database connection.
Daatubeeze forme widoonni, daatu bue eote dirto woy xaadisaaxine gumultanno. Doorammete dani kaiminni, dirtote amado hunda babbaxxino daati bue mereerinni doodhate aamantino kaayyo daatabeezete giddo leeltannoreeti. Baaanti doorantino daati daniti afamannodaatibeeze uduunni dirto amado dani kowiicho aamamino. "Hornyote doorto"danu gede assine doorriro, daattabeezete formera maqishshu hee'rara dandaanno. Qorqorshu leellishaalbi SQL hajajonni, qoqqowaminoha ikkiro, SQL yaatto kawiicho e'anno.
SQL yaatto lawishshuwa:
Dirtote saaxinnara, SQL yaatto aantanno forme heedhannoseha ikkanno:
SELECT bare1, bare2 FROM shae,
Konne "shae" daatise qorqorshi giddo reqeccishshantanno shaeeti(dirtot shae). "bare" formete giddo leellado eo xawisanno daati bareeti; amadose dirtote saaxine giddo reqeccishantanno."bare2"f ormete shaewa xaadissanno shae dirtooti(hornyote shae) badantino bare giddoonni daatu bare Qoqqowantino bare =1 dooraminoho.
Xaadi saaxinnate, SQL miteekkite aantanno forme adhitannoha ikkanno:
SELECT DISTINCT bare FROM shaetewiinni,
Kawiicho "bare" dirtote shaewiinni daatu bareti "shae"amadose xaadisantino dirto giddo reqeccishshanno.
Hornyote dirto HTML bortajuwira
HTML formuwira, Doortote amado hunda hornyote dirto eessa dandiinanni. Dirtote amaduwa Dani hunda "Hornyotedirto" doodho doori. Kawiicho e'ino hornyo formete giddo leellitannota dikkitanno, nna hakkurino leellado eora hornygaamate horora hossanno. Dirtote hundi dirtote amado xaadooshshu hee'rannoseHTML tag <OPTION VALUE=...>.
Dirtote saaxinewiinni woy xaadisaaxinete wiinni doorantino eo daatu taraawishshira lamenti hornyote dirto formete giddo reqeccishantinoti, hattino xaphoomu giggishsho aani dirto euwi hunda, nna e'inoti hornyote dirto Datu giggishsho aana amadote woroonni, heedhannori hedote giddo amadantannoreeti: Miteekkite (mullaagginokki)borro heedhannohuhornyote dirto giddo doorantino ofollaraati, hatti taraabbannota ikkitanno. Hakkunni ka'a, reqeccishantino borro (<OPTION>) giddo qorqorshinni soyaamantanno.
Miteeke hornyote dirto mulluuga naanno amadaheedhusiro, "$$$empty$$$" hunda dirto amado lasabbanno ofollara hornyo eessi. (huwati jajjabba fidalla/manaadda fidalla). LibreOffice tenne eo eote naanno gede huwatatenni ha'runsitanno eo dirtuwa gaamannose.
Aantanno shae HTML mereero xaadooshshe leellishshanno, JavaScript, nna$[beerotesu'mi] bare dirto amadolawishshu dirto saaxine su'ma horoonsi'ratenni "ListBox1" xaadooshshe leellishshanno. Tenne hajora, "Item" formete giddo leellado eo dirto akeekisano:
HTML Badaancho |
JavaScript |
Eo qorqorshu dirto giddo(Dirtote amado) |
Tareessamino daata |
<OPTION>dana |
Didandaamannnoho |
"" |
leellado dirto eo ("ListBox1=Uduunnichu") |
<OPTION VALUE="Value">Uduunnichu |
ListBox1.doodhuwu[0].hornyo="hornyo" |
"Hornyo" |
Ete dirto giddo gaammoonni hornyo ("Dirtote saxine1=Vhonyo") |
<OPTION VALUE="">Uduunnicho |
ListBox1.doortuwu[0].hornyuwu="" |
"$$$mullicho$$$" |
Mullicho naan-ifikiima ("ListBox1=") |
Dirtote amado gara
dirto giddo wonshamanno data.
With the "Valuelist" option, all entries entered in the List entries field of the General tab appear in the control. For database forms, you can use reference values (see the References Using Value Lists section).
If the content of the control is read from a database, you can determine the type of the data source with the other options. For example, you can choose between tables and queries.
Maqishshu hornyo(huni)
Buuxote saaxinenna ispiriidishittete giddo raadoonete ilkuwi xaa borrotaje bisiccuwi giddo qoqqwama ikka dandiitannoQorqorshu dandaamaminoha ikkinoro,maqishshu giddo surkantino hornyo 9fani)bisiccu widira hinkiilantanno.Qorqorshu dandaamannokkiro,Maqishshu hornyo (huni) huni bisicci widira hikiilantanno.
Mullicho naanno NULL
Mullicho naanno eo magarinni amadama hasiissannosero tittiranno. Miteekke qineesso Eera. zeerote hojja naanno eo amadantannohu NULL hornyo gedeeti. Miteekke qinaawo Dee'ni ikkite, ayee eono ikkituro amadantannohu soorro assantukkinni noo gedeenni mitteenniiti.
Mullicho naanno hojjasenni zeero ikkitanno naannooti (""). Rosamino garinni, NULL hornyo mullicho naanno gedeeta dikkitino. Xaphoomunni, NULL yaamamanno qaali horoonsi'ramannohu xuruurantino hornyo egensiisateeti, egennantinokki hornyo "xaa geeshsha e'ino hornyo dino"
Daatubeeze amuraatuwi soorramaano ikkitinohura hakkuri hornyo baxxino garinni NULL assite amaddanno.Horronsi'rate aana leeltanno daatabeeze bortajishsha maqishshisi.
Proopoozaale Meemiissi
While designing your form, you can set the "Filter proposal" property for each text box in the Data tab of the corresponding Properties dialog. In subsequent searches in the filter mode, you can select from all information contained in these fields. The field content can then be selected using the AutoComplete function. Note, however, that this function requires a greater amount of memory space and time, especially when used in large databases and should therefore be used sparingly.
Qorqorshu hornyo (fani)
Weebete formera maqishshu hornyo eessa dandiinanni,hattino owaataanchunniwa sonkani wote marro higge xaaddannote.Daatubeezete formuwinni,e'ino hornyo qorqorshu barera gaamantino bare daatubeeze giddo borreessantanno, maqishshu hornyo doodhote ilkuwirannabuuxote saaxine gaama dandiinanni.Maqishshu hornyo weebete forme sonkanni yannara marro higge owaatancho xaaddinota ikkitanno.Daatabeezete formuwinni kawiicho e'ino hornyo qoqorshu barera gaamantino daatabeeze giddo borreessantannota ikkitanno.
Weebete forme maqishu hornyuwi
Weebete forme gaammironna qorqorshu deerri mashalaqqe owaataanchunniwa sa"annoha ikkiro maqishshu hornyuwi horo heedhannonsareeti.Qorqorshu horoonsi'raanchunni kisamiro, lasaawanno maqishshi hornyoowaataanchunniwa soyaamantanno.
Lawishshaho,"meyati" nna "labbaahu" yitannoti lame qorqorshu bare doodho heedhuro,nna maqishshunnita mitte hornyo 1 "meyati" barenna hornyo 2 "labbaahu" barera gaammiro, horny 1 owaataanchunniwa sa'annohu horoonsi'raanchu "meyati" barennahornyo 2 soyaamantannohu "meyati" bare kisaturooti.
Daatu beeze formera maqishshu hornyuwi
Daatubeeze formera, doodho deerra woy maqishshu hornyonni buuxote saaxine duunatenni misiloonsa dandiinanni.sase qinaawo doodho hedhuha ikkro,Lawishshaho, "lexxate aana","completed"nna "marro aamaminoho" xaadannonsa maqishshi hornyuwi ledo,"Dodo","Ikkona",nna "RS", kuri maqishshuwi hornyuwidaata beezete giddo leeltannoti lasaabbanno doodho kisantuha ikkirooti.
Shiqqino bare
MiteekkineShiqishaancho barebisiccoakatu soroowaanchi giddo amadosi hunniha ikkro, gumu bareti umi dirto gambooshshi daata reqeccishatenna soorri'rate horoonsamanno.
Kuni akati dirtote saaxinnara hiikko daati bare xadisantino shaeti formete giddo reqeccishantannoro xawisanno.
Mitteekke formete giddo xaadisano dirto saaxine xaadisancho shae amado leellishara hasanturo, hakkawote dirtote dani amado bare giddo xawisi. field define in the if the display is determined by an SQL command or the (linked) table is accessed. With the Bound field property
The property Bound field is only for forms that are used to access more than one table. If the form is based on only one table, the field to be displayed in the form is specified directly under Data field. However, if you want the list box to display data from a table that is linked to the current table over a common data field, the linked data field is defined by the property Bound field.
If you selected "SQL" under Type of list contents, the SQL command determines the index to be specified. Example: If you specify an SQL command such as "SELECT Field1, Field2 FROM tablename" under List content, refer to the following table:
Shiqqino bare |
xaadi |
-1 |
The index of the selected entry in the list is linked to the field specified under Data field. |
{empty} or 0 |
Daatu beeze bare "Bare1" xaadisantinohuhunda Daatu barehundaati.. |
1 |
Daatu beeze bare "bare2" daatu bare awisantino barennixaadisantinote hunda. |
"Shae"doorantinoha ikkirohunda Dirtote amado , shaete gano badantara hasantanno mashalaqqishaano xawissanno.Lawishshaho:hunda Daata beezetw amado Dirto,aantanno shaubba aantanno shaubbaati.
Gambissino bare |
Xaadooshshe |
-1 |
The index of the selected entry in the list is linked to the field specified under Data field. |
{empty} or 0 |
1umi caccafo shae Daati Barera, xawisantino barewa xaaddinoteDaatu bare. |
1 |
The 2ki shaete caccafo Daata Bare hunda xawisantino bare ledo xadisantinote. |
2 |
Hattono 3kit shaete caccafo xawisamintino bare ledo xaaddinote under daatu bare hunde. |
Xaadisamino bisicci amaduwi
Dirtote saaxine isipriidishittete aana xaadishshu gara doori
-
xaadisantino amaduwi:Doorantino dirto borro amado saaxine eo bisiccu amado ledo suwisi."doorantino eo doori" doori
-
Xaadisamino doorshi ofolla: mittichu dooramino uduunniti dirtote saaxine giddo ofolla suwisantannohu bisiccu giddo kiiraancho hornyonniiti. Doo'ri "Dooranti eo ofolla"
Xaadisanti bisicco
Ispiriidishittete aana xaadisamino bisicci maqishsha badanno. Qoqorshshunniti noo gari ikkito woy amado bisiccu amado ledo xaadisantinote. Aananno shauwi qorqorshuwa dirtanno nna hakkuriha mimmito lawanno xaadi dana:
Xadisantino bisicco ledo kulaancho saaxine
Assoote |
Guma |
Buuxishshu saaxine door |
TRUE xaadisantino bosicco giddora e'ino |
Kulaancho saaxine doortooti |
FALSE xaadisantino bisicco giddora eino |
Sasi Gari buuxishshi saaxine gambooshshe "badantinokk" ikkito |
#NV xaadisantino bisicco giddora e'inote |
xaadisantino bisicco wiinni qoltannota kiiro woy afi'rimala eessi. |
E'ino hornyo TRUE woy di 0: buuxishshu saaxinedoorantanno |
Xaadisamino bisicco huni, woy borro eessi,borro galagachaqolannoha woy so'ro taashshanno afi'rimala eessi |
Buuxishshu saaxine sasi-gari buuxishshi saaxine ikkituro "badantinokki"widira gamba yitanno,hakkunni ka'a buuxote saaxine didoorantanno. |
Saaxine door. Maqishshu hornyo saaxinera saaxine heedhanose. |
Maqishshu hornyo wiinni dagganno borro bisiccuwidira hinkiilantanno. |
Saaxine doortoti.Maqishshu hornyo saaxine borro heedhannosete |
Mullicho aanno bisiccuwidira hikiilantanno. |
Maqishshu hornyo saaxine borro heedhannosete, borrote giddora hattoo borro eessi. |
Buuxishshu saaxine dorantinote |
Maqishshu hornyo saaxine borro heedhannosete. Wole borro bisuccu giddora eessi. |
Buuxishshu saaxine di dorantinote. |
Doodhote ilka (raadoonete ilki) xaadino bisicci ledo
Assoote |
Guma |
Doodhote ilka doori |
TRUE xaadisantino bisicco giddora e'inote |
Doodhote ilki wole ilka doodhate assooti ka'nohunni didooramino |
FALSE xaadisantino bisicco giddora ieno |
Xaadisantino bisicco wiinni qoltannota kiiro woy afi'rimala eessi |
E'ino hornyo TRUE woy di 0: Buuxishshu ilki dooramanno |
Xaadisamino bisicco huni, woy borro eessi woy borro woy so'ro galagalche qolannoha afi'rimala eessi |
Doodhote ilki didooraminoho |
Doodhote ilka kisi. Maqishshu horrnyosaaxine borro afidhinote. |
Maqishshu hornyo wiinni dagganno borro bisiccu widira hinkiilantanno. |
Hattoo gaamoha wole doodhote ilka kisi. Maqishshu horrnyo saaxine borro afidhinote. |
Mullicho naanno bisiccunniwa hinkiilantino. |
Maqishshu hornyo saaxine borro heedhannosete. Hattoo borro bisiccu giddora eessi. |
Doodhote ilki dooraminoho. |
Maqishshu hornyo saaxine borro heedhannosete. Wole borro bisiccu giddora eessi. |
Doodhote ilki hunamino. |
Borrote saaxine xaadino bisicci ledo
Assoote |
Guma |
Borro borrote saaxine giddora eessi |
Borro xaadisantino bisicco giddora hinkiilantino |
Borrote saaxine huni |
Xaadino bisicci hunamino |
Borro woy kiiro xadisamino bisicci giddora eessi |
Borro woy kiiro borrote saaxine giddora hinkiilantino |
Afi'rimala xaadisamino bisicci giddora eessi |
Afi'rimalu gumi borrote saaxine giddora hinkiilamino |
Xaadisamino bisicco huni |
Borrote saaxine hunantino |
Kiirancho bare nna bisiccu leddoti suudisamancho
Assote |
Guma |
Kiiro barete giddora eessi |
Kiiro xaadisantino bisicco giddora hinkiilantino |
Bare huni |
Hornyo 0 xaadisamino bisicci giddo woramino |
Xaadisamino bisicci giddonni kiiro galagalche qolannohakiiro woy afi'rimala eessi |
Kiiro giddora hinkiilantino |
Xaadisamino bisicco huni,woy borro eessi, woy borro woy so'ro daware qolanno afi'rimala eessi |
Hornyo 0 barete giddo worantino |
Dirtote saaxine xaadino bisicci ledo
Dirtote saaxine lame babbaxitanno orte irkissanno, "Xaadisantino amado" lai.
-
Xaadisantino amadubba: Suwisishshu doorantino dirto saaxine eo bisiccu amado ledoot.
-
Xaadisamino doorshshiofolla: Mittichu dooramino uduunnichi bisiccu saaxine giddo kiiraancho hornyi ledo bisiccu giddo suwisaminoho.
Assoote |
Guma |
Callicho dirto dana doori |
Amado xaadisantinote: Hakko dani borro xaadisantino bisico giddora hinkiilanmino. Doodho xaadisantinote: dooramino uduunni xaadisantino bisicco widira hinkiilamino. Lawishhaho, sayikki uduunnichi doorammoha ikkiro, kiiro 3hikiilantanno. |
Fakkana dirtote dana doori |
#NV Xaadisamin bisicci giddora einoho |
Baalanta dirtuwa doortooti |
Amaduwu xadisantinoreeti: Xaadisamio bisicci hunamino Doorto xaadisantinote: Hornyo 0 xaadisamino bisicci giddo e'ino |
Borro woy kiiro xadisamino bisicci giddora eessi |
Amado xaadisantinte: hakko deerri dirto hasse uduunne diri Doorto xaadisantinote: Badantino ofollahu dirtote uduunni (umi uduunnichira 1 nni hanafanno) dooraminohu. Afama hoogiha ikkiro, baalunku uduunnu di dooramanno. |
Afi'rimala xaadisamino bisicci giddora eessi |
Afi'rimalu formuli gumi ledo xaadooshshu gari hee'rannosi uduunne dirto hasse doori |
Xaadisamino bisicco huni |
Dirtote saaxine giddo baalanka uduunne doortooti |
Dirtote bue amado hakki-geeshshosoorri |
Dirtote saaxine uduunni soorrote garinni yanneessantinoreeti. Doorto agarantinote. Tini miteekkite xaadisamino bisiccira yanneessama abbitannoha ikkanno. |
Xaadisamino bisicci ledo xaadi saaxine
Assoote |
Guma |
Xaadi saaxinete borro suudeessishshu bare giddora eessi, woy eo diraancho dirto giddonni doori |
Borro xaadisamino bisicci giddora hinkiilantino |
Xaadi saaxinenniha suudishshu bare huni |
Xaadino bisicci hunamino |
Borro woy kiiro xadisamino bisicci giddora eessi |
Borro woy kiiro xaadi saaxinete suudushshu bare giddora hinkiilantino |
Afi'rimala xaadisamino bisicci giddora eessi |
Afi'rimalu gumi xaadi saaxinete suudishshu bare giddora hinkiilamino |
Xaadisamino bisicco huni |
Xaadi saaxinennihu suudishshu bare hunantino |
Dirtote bue hakki-geeshsho amado soorri |
Dirraancho dirto uduunni soorrote garinni yanneessamanno. Xaadi saaxinenniti suuddeessishshu bare nna xaadisamino bisicci disoorramanno. |