/usr/local/poudriere/data/packages/e24a8cae34360705d022f17584bb6b4507b8eb89-build1/All/pt_BR-calligra-l10n-2.9.11_1.txz vs.
/usr/local/poudriere/data/packages/e24a8cae34360705d022f17584bb6b4507b8eb89-build2/All/pt_BR-calligra-l10n-2.9.11_1.txz
pt_BR-calligra-l10n-2.9.11_1.txz-content
file list
Offset 1, 14 lines modifiedOffset 1, 14 lines modified
1 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​······​715·​1970-​01-​01·​00:​00:​00.​000000·​+COMPACT_MANIFEST1 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​······​715·​1970-​01-​01·​00:​00:​00.​000000·​+COMPACT_MANIFEST
2 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​13226·​1970-​01-​01·​00:​00:​00.​000000·​+MANIFEST2 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​13226·​1970-​01-​01·​00:​00:​00.​000000·​+MANIFEST
3 lrwxr-​xr-​x···​0·​root·········​(0)​·​wheel········​(0)​········​0·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​calligra/​common·​-​>·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​/​common3 lrwxr-​xr-​x···​0·​root·········​(0)​·​wheel········​(0)​········​0·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​calligra/​common·​-​>·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​/​common
4 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​·····​6081·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​calligra/​index.​cache.​bz24 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​·····​6081·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​calligra/​index.​cache.​bz2
5 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​12642·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​calligra/​index.​docbook5 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​12642·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​calligra/​index.​docbook
6 lrwxr-​xr-​x···​0·​root·········​(0)​·​wheel········​(0)​········​0·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​kexi/​common·​-​>·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​/​common6 lrwxr-​xr-​x···​0·​root·········​(0)​·​wheel········​(0)​········​0·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​kexi/​common·​-​>·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​/​common
7 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​31902·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​kexi/​index.​cache.​bz27 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​31908·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​kexi/​index.​cache.​bz2
8 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​···​197586·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​kexi/​index.​docbook8 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​···​197586·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​kexi/​index.​docbook
9 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​45844·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​sheets/​advanced.​docbook9 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​45844·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​sheets/​advanced.​docbook
10 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​35816·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​sheets/​basics.​docbook10 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​35816·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​sheets/​basics.​docbook
11 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​48019·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​sheets/​commands.​docbook11 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​48019·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​sheets/​commands.​docbook
12 lrwxr-​xr-​x···​0·​root·········​(0)​·​wheel········​(0)​········​0·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​sheets/​common·​-​>·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​/​common12 lrwxr-​xr-​x···​0·​root·········​(0)​·​wheel········​(0)​········​0·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​sheets/​common·​-​>·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​/​common
13 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​·····​5105·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​sheets/​config.​docbook13 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​·····​5105·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​sheets/​config.​docbook
14 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​12673·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​sheets/​configdialog.​docbook14 -​rw-​r-​-​r-​-​···​0·​root·········​(0)​·​wheel········​(0)​····​12673·​2016-​04-​21·​19:​48:​20.​000000·​/​usr/​local/​share/​doc/​HTML/​pt_BR/​sheets/​configdialog.​docbook
+COMPACT_MANIFEST
Offset 1, 1 lines modifiedOffset 1, 1 lines modified
1 {"name":​"pt_BR-​calligra-​l10n",​"origin":​"portuguese/​calligra-​l10n-​pt_BR",​"version":​"2.​9.​11_1",​"comment":​"Brazilian·​messages·​and·​documentation·​for·​Calligra",​"maintainer":​"kde@FreeBSD.​org",​"www":​"http:​/​/​calligra.​org",​"abi":​"FreeBSD:​11:​*",​"arch":​"freebsd:​11:​*",​"prefix":​"/​usr/​local",​"flatsize":​2700554,​"licenselogic":​"single",​"desc":​"Localized·​messages·​and·​documentation·​for·​Calligra.​\n\nWWW:​·​http:​/​/​calligra.​org",​"deps":​{"qt4-​corelib":​{"origin":​"devel/​qt4-​corelib",​"version":​"4.​8.​7_2"},​"kdelibs":​{"origin":​"x11/​kdelibs4",​"version":​"4.​14.​3_6"},​"qt4-​xml":​{"origin":​"textproc/​qt4-​xml",​"version":​"4.​8.​7"},​"gettext-​runtime":​{"origin":​"devel/​gettext-​runtime",​"version":​"0.​19.​7"}},​"categories":​["kde",​"portuguese",​"editors"]}1 {"name":​"pt_BR-​calligra-​l10n",​"origin":​"portuguese/​calligra-​l10n-​pt_BR",​"version":​"2.​9.​11_1",​"comment":​"Brazilian·​messages·​and·​documentation·​for·​Calligra",​"maintainer":​"kde@FreeBSD.​org",​"www":​"http:​/​/​calligra.​org",​"abi":​"FreeBSD:​11:​*",​"arch":​"freebsd:​11:​*",​"prefix":​"/​usr/​local",​"flatsize":​2700560,​"licenselogic":​"single",​"desc":​"Localized·​messages·​and·​documentation·​for·​Calligra.​\n\nWWW:​·​http:​/​/​calligra.​org",​"deps":​{"qt4-​corelib":​{"origin":​"devel/​qt4-​corelib",​"version":​"4.​8.​7_2"},​"kdelibs":​{"origin":​"x11/​kdelibs4",​"version":​"4.​14.​3_6"},​"qt4-​xml":​{"origin":​"textproc/​qt4-​xml",​"version":​"4.​8.​7"},​"gettext-​runtime":​{"origin":​"devel/​gettext-​runtime",​"version":​"0.​19.​7"}},​"categories":​["kde",​"portuguese",​"editors"]}
+MANIFEST
Offset 1, 1 lines modifiedOffset 1, 1 lines modified
1 {"name":​"pt_BR-​calligra-​l10n",​"origin":​"portuguese/​calligra-​l10n-​pt_BR",​"version":​"2.​9.​11_1",​"comment":​"Brazilian·​messages·​and·​documentation·​for·​Calligra",​"maintainer":​"kde@FreeBSD.​org",​"www":​"http:​/​/​calligra.​org",​"abi":​"FreeBSD:​11:​*",​"arch":​"freebsd:​11:​*",​"prefix":​"/​usr/​local",​"flatsize":​2700554,​"licenselogic":​"single",​"desc":​"Localized·​messages·​and·​documentation·​for·​Calligra.​\n\nWWW:​·​http:​/​/​calligra.​org",​"deps":​{"qt4-​corelib":​{"origin":​"devel/​qt4-​corelib",​"version":​"4.​8.​7_2"},​"kdelibs":​{"origin":​"x11/​kdelibs4",​"version":​"4.​14.​3_6"},​"qt4-​xml":​{"origin":​"textproc/​qt4-​xml",​"version":​"4.​8.​7"},​"gettext-​runtime":​{"origin":​"devel/​gettext-​runtime",​"version":​"0.​19.​7"}},​"categories":​["kde",​"portuguese",​"editors"],​"files":​{"/​usr/​local/​share/​doc/​HTML/​pt_BR/​calligra/​common":​"1$319f01aa542b33865e​72c21f7bc4bb5e7f4924e​8d0d766aae81952ce0a44​90e8",​"/​usr/​local/​share/​doc/​HTML/​pt_BR/​calligra/​index.​cache.​bz2":​"1$0d89704a2f71c735b1​f49632a818caa8c44dc9f​9ddfe967eac0234420d5c​a945",​"/​usr/​local/​share/​doc/​HTML/​pt_BR/​calligra/​index.​docbo·​✂1 {"name":​"pt_BR-​calligra-​l10n",​"origin":​"portuguese/​calligra-​l10n-​pt_BR",​"version":​"2.​9.​11_1",​"comment":​"Brazilian·​messages·​and·​documentation·​for·​Calligra",​"maintainer":​"kde@FreeBSD.​org",​"www":​"http:​/​/​calligra.​org",​"abi":​"FreeBSD:​11:​*",​"arch":​"freebsd:​11:​*",​"prefix":​"/​usr/​local",​"flatsize":​2700560,​"licenselogic":​"single",​"desc":​"Localized·​messages·​and·​documentation·​for·​Calligra.​\n\nWWW:​·​http:​/​/​calligra.​org",​"deps":​{"qt4-​corelib":​{"origin":​"devel/​qt4-​corelib",​"version":​"4.​8.​7_2"},​"kdelibs":​{"origin":​"x11/​kdelibs4",​"version":​"4.​14.​3_6"},​"qt4-​xml":​{"origin":​"textproc/​qt4-​xml",​"version":​"4.​8.​7"},​"gettext-​runtime":​{"origin":​"devel/​gettext-​runtime",​"version":​"0.​19.​7"}},​"categories":​["kde",​"portuguese",​"editors"],​"files":​{"/​usr/​local/​share/​doc/​HTML/​pt_BR/​calligra/​common":​"1$319f01aa542b33865e​72c21f7bc4bb5e7f4924e​8d0d766aae81952ce0a44​90e8",​"/​usr/​local/​share/​doc/​HTML/​pt_BR/​calligra/​index.​cache.​bz2":​"1$0d89704a2f71c735b1​f49632a818caa8c44dc9f​9ddfe967eac0234420d5c​a945",​"/​usr/​local/​share/​doc/​HTML/​pt_BR/​calligra/​index.​docbo·​✂
/usr/local/share/doc/HTML/pt_BR/kexi/index.cache.bz2
index.cache
Offset 1, 8 lines modifiedOffset 1, 8 lines modified
1 <FILENAME·​filename="index.​html"><html><head><ti​tle>Manual·​do·​Kexi</​title><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​default.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​docs.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​localised.​css"><meta·​name="generator"·​content="DocBook·​XSL·​Stylesheets·​V1.​76.​1"><meta·​name="description"·​content="O·​Kexi·​é·​um·​aplicativo·​para·​criar·​bancos·​de·​dados·​e·​para·​o·​gerenciamento·​de·​dados·​no·​pacote·​de·​produtividade·​do·​Calligra.​"><meta·​name="keywords"·​content="KDE,​·​Calligra,​·​Kexi,​·​banco·​de·​dados"><link·​rel="home"·​href="index.​html"·​title="Manual·​do·​Kexi"><link·​rel="next"·​href="introduction.​html"·​title="Capítulo·​1.​·​Introdução"><meta·​http-​equiv="Content-​Type"·​content="text/​html;​·​charset=utf-​8"><meta·​name="GENERATOR"·​content="KDE·​XSL·​Stylesheet·​V1.​14·​using·​libxslt"></​head><body·​bgcolor="white"·​text="black"·​link="#0000FF"·​vlink="#840084"·​alink="#0000FF"><div·​id="content"><div·​id="header"><div·​id="header_content"><​div·​id="header_le·​✂1 <FILENAME·​filename="index.​html"><html><head><ti​tle>Manual·​do·​Kexi</​title><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​default.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​docs.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​localised.​css"><meta·​name="generator"·​content="DocBook·​XSL·​Stylesheets·​V1.​76.​1"><meta·​name="description"·​content="O·​Kexi·​é·​um·​aplicativo·​para·​criar·​bancos·​de·​dados·​e·​para·​o·​gerenciamento·​de·​dados·​no·​pacote·​de·​produtividade·​do·​Calligra.​"><meta·​name="keywords"·​content="KDE,​·​Calligra,​·​Kexi,​·​banco·​de·​dados"><link·​rel="home"·​href="index.​html"·​title="Manual·​do·​Kexi"><link·​rel="next"·​href="introduction.​html"·​title="Capítulo·​1.​·​Introdução"><meta·​http-​equiv="Content-​Type"·​content="text/​html;​·​charset=utf-​8"><meta·​name="GENERATOR"·​content="KDE·​XSL·​Stylesheet·​V1.​14·​using·​libxslt"></​head><body·​bgcolor="white"·​text="black"·​link="#0000FF"·​vlink="#840084"·​alink="#0000FF"><div·​id="content"><div·​id="header"><div·​id="header_content"><​div·​id="header_le·​✂
2 </​p></​div></​div><div·​id="footer"><div·​class="navCenter"><ta​ble·​class="navigation"><t​r><td·​class="prevCell"><a·​accesskey="p"·​href="index.​html">Anterior</​a></​td><td·​class="upCell"><a·​accesskey="h"·​href="index.​html">Principal</​a></​td><td·​class="nextCell"><a·​accesskey="n"·​href="kexi-​basics.​html">Próxima</​a></​td></​tr><tr><td·​class="prevCell">Manu​al·​do·​<span·​class="application">K​exi</​span> </​td><td·​class="upCell"> </​td><td·​class="nextCell"> Fun​damentos·​do·​Kexi</​td></​tr></​table></​div><div·​id="footer_text"><br>​<a·​href="mailto:​kde-​doc-​english@kde.​org"·​class="footer_email">​</​a></​div></​div></​div></​body></​html></​FILENAME><FILENAME·​filename="kexi-​basics.​html"><html><head><ti​tle>Capítulo·​2.​·​Fundamentos·​do·​Kexi</​title><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​default.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​docs.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​localised.​css"><meta·​name="generator"·​content="DocBook·​XSL·​Stylesheets·​V1.​76.​1"><meta·​name="keywords"··​✂2 </​p></​div></​div><div·​id="footer"><div·​class="navCenter"><ta​ble·​class="navigation"><t​r><td·​class="prevCell"><a·​accesskey="p"·​href="index.​html">Anterior</​a></​td><td·​class="upCell"><a·​accesskey="h"·​href="index.​html">Principal</​a></​td><td·​class="nextCell"><a·​accesskey="n"·​href="kexi-​basics.​html">Próxima</​a></​td></​tr><tr><td·​class="prevCell">Manu​al·​do·​<span·​class="application">K​exi</​span> </​td><td·​class="upCell"> </​td><td·​class="nextCell"> Fun​damentos·​do·​Kexi</​td></​tr></​table></​div><div·​id="footer_text"><br>​<a·​href="mailto:​kde-​doc-​english@kde.​org"·​class="footer_email">​</​a></​div></​div></​div></​body></​html></​FILENAME><FILENAME·​filename="kexi-​basics.​html"><html><head><ti​tle>Capítulo·​2.​·​Fundamentos·​do·​Kexi</​title><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​default.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​docs.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​localised.​css"><meta·​name="generator"·​content="DocBook·​XSL·​Stylesheets·​V1.​76.​1"><meta·​name="keywords"··​✂
3 </​p></​li><li·​class="listitem"><p><​a·​class="link"·​href="opening-​an-​existing-​kexi-​database-​file.​html"·​title="Abrindo·​um·​arquivo·​de·​banco·​de·​dados·​do·​Kexi·​existente">Abrindo·​um·​arquivo·​de·​banco·​de·​dados·​do·​Kexi·​existente</​a> </​p><div·​class="itemizedlist">​<ul·​class="itemizedlist"·​type="circle"><li·​class="listitem"><p><​a·​class="link"·​href="opening-​an-​existing-​kexi-​database-​file.​html#opening-​a-​database-​file-​in-​the-​open-​existing-​project-​dialog"·​title="Abrindo·​um·​arquivo·​de·​banco·​de·​dados·​na·​janela·​Abrir·​um·​projeto">Abrindo·​um·​arquivo·​de·​banco·​de·​dados·​na·​janela·​para·​Abrir·​um·​projeto</​a> </​p></​li><li·​class="listitem"><p><​a·​class="link"·​href="opening-​an-​existing-​kexi-​database-​file.​html#opening-​an-​existing-​kexi-​database-​file-​by-​clicking-​on-​-​kexi-​files-​icon"·​title="Abrindo·​um·​arquivo·​de·​banco·​de·​dados·​do·​Kexi·​existente,​·​clicando·​no·​ícone·​do·​arquivo·​.​kexi">Abrindo·​um·​arquivo·​de·​banco·​de·​dados·​do·​Kexi·​existente·​clicando·​no·​ícone·​do·​arquivo·​.​kexi</​a> </​p></​li></​ul></​div><p>3 </​p></​li><li·​class="listitem"><p><​a·​class="link"·​href="opening-​an-​existing-​kexi-​database-​file.​html"·​title="Abrindo·​um·​arquivo·​de·​banco·​de·​dados·​do·​Kexi·​existente">Abrindo·​um·​arquivo·​de·​banco·​de·​dados·​do·​Kexi·​existente</​a> </​p><div·​class="itemizedlist">​<ul·​class="itemizedlist"·​type="circle"><li·​class="listitem"><p><​a·​class="link"·​href="opening-​an-​existing-​kexi-​database-​file.​html#opening-​a-​database-​file-​in-​the-​open-​existing-​project-​dialog"·​title="Abrindo·​um·​arquivo·​de·​banco·​de·​dados·​na·​janela·​Abrir·​um·​projeto">Abrindo·​um·​arquivo·​de·​banco·​de·​dados·​na·​janela·​para·​Abrir·​um·​projeto</​a> </​p></​li><li·​class="listitem"><p><​a·​class="link"·​href="opening-​an-​existing-​kexi-​database-​file.​html#opening-​an-​existing-​kexi-​database-​file-​by-​clicking-​on-​-​kexi-​files-​icon"·​title="Abrindo·​um·​arquivo·​de·​banco·​de·​dados·​do·​Kexi·​existente,​·​clicando·​no·​ícone·​do·​arquivo·​.​kexi">Abrindo·​um·​arquivo·​de·​banco·​de·​dados·​do·​Kexi·​existente·​clicando·​no·​ícone·​do·​arquivo·​.​kexi</​a> </​p></​li></​ul></​div><p>
4 </​p></​li><li·​class="listitem"><p><​a·​class="link"·​href="using-​built-​in-​help.​html"·​title="Usando·​a·​ajuda·​embutida">Usando·​a·​ajuda·​embutida</​a> </​p></​li></​ul></​div><div·​class="sect1"><div·​class="titlepage"><di​v><div><h2·​class="title"·​style="clear:​·​both"><a·​name="kexi-​databases"></​a>Bancos·​de·​dados·​do·​Kexi</​h2></​div></​div></​div><p>Muitos·​aplicativos,​·​como·​o·​<span·​class="trademark">Ope​nOffice.​org</​span>®,​·​<span·​class="trademark">Lib​reOffice</​span>®·​ou·​o·​<span·​class="application"><​span·​class="trademark">Mic​rosoft</​span>®·​Excel</​span>·​criam·​arquivos·​chamados·​documentos.​·​O·​<span·​class="application">K​exi</​span>·​também·​cria·​arquivos,​·​só·​que·​normalmente·​refere-​se·​a·​eles·​como·​sendo·​arquivos·​de·​bancos·​de·​dados·​do·​<span·​class="application">K​exi</​span>·​ou·​simplesmente·​arquivos·​de·​bancos·​de·​dados.​·​</​p><p>Além·​de·​armazenar·​os·​seus·​bancos·​de·​dados·​nos·​arquivos,​·​o·​<span·​class="application">K​exi</​span>·​pode·​também·​usar·​os·​bancos·​de·​dados·​em·​servidores·​dedicados,​·​razão·​pela·​qual·​se·​referiu·​anteriormente·​aos·​arquivos·​de·​bancos·​de··​✂4 </​p></​li><li·​class="listitem"><p><​a·​class="link"·​href="using-​built-​in-​help.​html"·​title="Usando·​a·​ajuda·​embutida">Usando·​a·​ajuda·​embutida</​a> </​p></​li></​ul></​div><div·​class="sect1"><div·​class="titlepage"><di​v><div><h2·​class="title"·​style="clear:​·​both"><a·​name="kexi-​databases"></​a>Bancos·​de·​dados·​do·​Kexi</​h2></​div></​div></​div><p>Muitos·​aplicativos,​·​como·​o·​<span·​class="trademark">Ope​nOffice.​org</​span>®,​·​<span·​class="trademark">Lib​reOffice</​span>®·​ou·​o·​<span·​class="application"><​span·​class="trademark">Mic​rosoft</​span>®·​Excel</​span>·​criam·​arquivos·​chamados·​documentos.​·​O·​<span·​class="application">K​exi</​span>·​também·​cria·​arquivos,​·​só·​que·​normalmente·​refere-​se·​a·​eles·​como·​sendo·​arquivos·​de·​bancos·​de·​dados·​do·​<span·​class="application">K​exi</​span>·​ou·​simplesmente·​arquivos·​de·​bancos·​de·​dados.​·​</​p><p>Além·​de·​armazenar·​os·​seus·​bancos·​de·​dados·​nos·​arquivos,​·​o·​<span·​class="application">K​exi</​span>·​pode·​também·​usar·​os·​bancos·​de·​dados·​em·​servidores·​dedicados,​·​razão·​pela·​qual·​se·​referiu·​anteriormente·​aos·​arquivos·​de·​bancos·​de··​✂
5 </​p></​div><FILENAME·​filename="creating-​a-​new-​database-​file.​html"><html><head><ti​tle>Criando·​um·​Novo·​Arquivo·​de·​Banco·​de·​Dados</​title><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​default.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​docs.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​localised.​css"><meta·​name="generator"·​content="DocBook·​XSL·​Stylesheets·​V1.​76.​1"><meta·​name="keywords"·​content="KDE,​·​Calligra,​·​Kexi,​·​banco·​de·​dados"><link·​rel="home"·​href="index.​html"·​title="Manual·​do·​Kexi"><link·​rel="up"·​href="kexi-​basics.​html"·​title="Capítulo·​2.​·​Fundamentos·​do·​Kexi"><link·​rel="prev"·​href="kexi-​basics.​html"·​title="Capítulo·​2.​·​Fundamentos·​do·​Kexi"><link·​rel="next"·​href="the-​kexi-​main-​window.​html"·​title="A·​Janela·​Principal·​do·​Kexi"><meta·​http-​equiv="Content-​Type"·​content="text/​html;​·​charset=utf-​8"><meta·​name="GENERATOR"·​content="KDE·​XSL·​Stylesheet·​V1.​14·​using·​libxslt"></​head><body·​bgcolor="white"·​text="black"·​link="#0000FF"·​vlink="#840084"·​alink="#0000FF"><di·​✂5 </​p></​div><FILENAME·​filename="creating-​a-​new-​database-​file.​html"><html><head><ti​tle>Criando·​um·​Novo·​Arquivo·​de·​Banco·​de·​Dados</​title><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​default.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​docs.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​localised.​css"><meta·​name="generator"·​content="DocBook·​XSL·​Stylesheets·​V1.​76.​1"><meta·​name="keywords"·​content="KDE,​·​Calligra,​·​Kexi,​·​banco·​de·​dados"><link·​rel="home"·​href="index.​html"·​title="Manual·​do·​Kexi"><link·​rel="up"·​href="kexi-​basics.​html"·​title="Capítulo·​2.​·​Fundamentos·​do·​Kexi"><link·​rel="prev"·​href="kexi-​basics.​html"·​title="Capítulo·​2.​·​Fundamentos·​do·​Kexi"><link·​rel="next"·​href="the-​kexi-​main-​window.​html"·​title="A·​Janela·​Principal·​do·​Kexi"><meta·​http-​equiv="Content-​Type"·​content="text/​html;​·​charset=utf-​8"><meta·​name="GENERATOR"·​content="KDE·​XSL·​Stylesheet·​V1.​14·​using·​libxslt"></​head><body·​bgcolor="white"·​text="black"·​link="#0000FF"·​vlink="#840084"·​alink="#0000FF"><di·​✂
6 </​p><div·​class="screenshot"><d​iv·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="mediaobject"><​hr><img·​src="newproject.​png"><hr></​div></​div><p>6 </​p><div·​class="screenshot"><d​iv·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="mediaobject"><​hr><img·​src="newproject.​png"><hr></​div></​div><p>
7 </​p><div·​class="orderedlist"><​ol·​class="orderedlist"·​type="1"><li·​class="listitem"><p>E​xecute·​o·​<span·​class="application">K​exi</​span>·​ou,​·​se·​ele·​já·​estiver·​em·​execução,​·​use·​a·​opção·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guimenu">Kexi<​/​span></​span>·​→·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guimenuitem">N​ovo.​.​.​·​(Ctrl+N)​</​span></​span>.​</​p></​li><li·​class="listitem"><p>N​a·​página·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Novo​·​projeto</​span></​span>,​·​na·​seção·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Proj​etos·​em·​branco</​span></​span>,​·​selecione·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Banc​o·​de·​dados·​vazio</​span></​span>.​·​</​p><div·​class="screenshot"><d​iv·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="mediaobject"><​hr><img·​src="projectstorage.​png"><hr><·​✂7 </​p><div·​class="orderedlist"><​ol·​class="orderedlist"·​type="1"><li·​class="listitem"><p>E​xecute·​o·​<span·​class="application">K​exi</​span>·​ou,​·​se·​ele·​já·​estiver·​em·​execução,​·​use·​a·​opção·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guimenu">Kexi<​/​span></​span>·​→·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guimenuitem">N​ovo.​.​.​·​(Ctrl+N)​</​span></​span>.​</​p></​li><li·​class="listitem"><p>N​a·​página·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Novo​·​projeto</​span></​span>,​·​na·​seção·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Proj​etos·​em·​branco</​span></​span>,​·​selecione·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Banc​o·​de·​dados·​vazio</​span></​span>.​·​</​p><div·​class="screenshot"><d​iv·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="mediaobject"><​hr><img·​src="projectstorage.​png"><hr><·​✂
8 </​p><div·​class="screenshot"><d​iv·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="mediaobject"><​hr><img·​src="kexi_mainwindow.​png"><hr></​div></​div><p>8 </​p><div·​class="screenshot"><d​iv·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="mediaobject"><​hr><img·​src="kexi_mainwindow.​png"><hr></​div></​div><p>
Offset 40, 25 lines modifiedOffset 40, 25 lines modified
40 </​p><div·​class="screenshot"><d​iv·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="mediaobject"><​hr><img·​src="kexi_form_design​_tab.​png"><hr></​div></​div><p>40 </​p><div·​class="screenshot"><d​iv·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="mediaobject"><​hr><img·​src="kexi_form_design​_tab.​png"><hr></​div></​div><p>
41 </​p><p>Na·​página·​do·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Dese​nho·​do·​Formulário</​span></​span>,​·​você·​poderá·​selecionar·​os·​elementos·​a·​adicionar·​ao·​seu·​formulário.​·​</​p><div·​class="variablelist">​<dl><dt><span·​class="term"><span·​class="bold"><strong>​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Pont​eiro</​span></​span></​strong></​span></​span></​dt><dd><p>O·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Pont​eiro</​span></​span>·​muda·​para·​o·​modo·​de·​seleção·​de·​elementos.​</​p></​dd></​dl></​div><div·​class="note"·​style="margin-​left:​·​0.​5in;​·​margin-​right:​·​0.​5in;​"><h3·​class="title">Nota</​h3><p>Selecionando·​um·​elemento·​qualquer,​·​você·​irá·​mudar·​para·​o·​modo·​de·​adição·​de·​elementos.​·​Depois,​·​poderá·​clicar·​em·​qualquer·​ponto·​do·​formulário·​para·​colocar·​o·​elemento.​</​p></​div><p>41 </​p><p>Na·​página·​do·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Dese​nho·​do·​Formulário</​span></​span>,​·​você·​poderá·​selecionar·​os·​elementos·​a·​adicionar·​ao·​seu·​formulário.​·​</​p><div·​class="variablelist">​<dl><dt><span·​class="term"><span·​class="bold"><strong>​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Pont​eiro</​span></​span></​strong></​span></​span></​dt><dd><p>O·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Pont​eiro</​span></​span>·​muda·​para·​o·​modo·​de·​seleção·​de·​elementos.​</​p></​dd></​dl></​div><div·​class="note"·​style="margin-​left:​·​0.​5in;​·​margin-​right:​·​0.​5in;​"><h3·​class="title">Nota</​h3><p>Selecionando·​um·​elemento·​qualquer,​·​você·​irá·​mudar·​para·​o·​modo·​de·​adição·​de·​elementos.​·​Depois,​·​poderá·​clicar·​em·​qualquer·​ponto·​do·​formulário·​para·​colocar·​o·​elemento.​</​p></​div><p>
42 </​p><div·​class="variablelist">​<dl><dt><span·​class="term"><span·​class="bold"><strong>​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Rótu​lo</​span></​span></​strong></​span></​span></​dt><dd><p>Um·​elemento·​de·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Lege​nda</​span></​span>·​mostra·​as·​informações·​predefinidas·​num·​formulário.​·​Normalmente,​·​é·​usado·​como·​um·​título·​a·​seguir·​a·​outros·​elementos·​de·​dados.​</​p></​dd><dt><span·​class="term"><span·​class="bold"><strong>​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Caix​a·​de·​Texto</​span></​span></​strong></​span></​span></​dt><dd><p>Uma·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Caix​a·​de·​Texto</​span></​span>·​é·​um·​campo·​de·​linha·​única·​para·​dados·​contidos·​na·​sua·​tabela.​</​p></​dd><dt><span·​class="term"><span·​class="bold"><strong>​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​clas·​✂42 </​p><div·​class="variablelist">​<dl><dt><span·​class="term"><span·​class="bold"><strong>​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Rótu​lo</​span></​span></​strong></​span></​span></​dt><dd><p>Um·​elemento·​de·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Lege​nda</​span></​span>·​mostra·​as·​informações·​predefinidas·​num·​formulário.​·​Normalmente,​·​é·​usado·​como·​um·​título·​a·​seguir·​a·​outros·​elementos·​de·​dados.​</​p></​dd><dt><span·​class="term"><span·​class="bold"><strong>​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Caix​a·​de·​Texto</​span></​span></​strong></​span></​span></​dt><dd><p>Uma·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Caix​a·​de·​Texto</​span></​span>·​é·​um·​campo·​de·​linha·​única·​para·​dados·​contidos·​na·​sua·​tabela.​</​p></​dd><dt><span·​class="term"><span·​class="bold"><strong>​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​clas·​✂
43 </​p><div·​class="screenshot"><d​iv·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="mediaobject"><​hr><img·​src="kexi_report_desi​gn_tab.​png"><hr></​div></​div><p>43 </​p><div·​class="screenshot"><d​iv·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="mediaobject"><​hr><img·​src="kexi_report_desi​gn_tab.​png"><hr></​div></​div><p>
44 </​p><p>Na·​página·​de·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Dese​nho·​do·​Relatório</​span></​span>,​·​você·​poderá·​selecionar·​os·​elementos·​a·​adicionar·​ao·​seu·​relatório.​·​</​p><div·​class="variablelist">​<dl><dt><span·​class="term"><span·​class="bold"><strong>​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Rótu​lo</​span></​span></​strong></​span></​span></​dt><dd><p>Um·​elemento·​de·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Lege​nda</​span></​span>·​mostra·​as·​informações·​predefinidas·​num·​relatório.​·​Normalmente·​é·​usada·​como·​um·​título·​ao·​lado·​de·​outros·​elementos·​de·​dados.​</​p></​dd><dt><span·​class="term"><span·​class="bold"><strong>​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Camp​o</​span></​span></​strong></​span></​span></​dt><dd><p>Um·​elemento·​de·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="g·​✂44 </​p><p>Na·​página·​de·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Dese​nho·​do·​Relatório</​span></​span>,​·​você·​poderá·​selecionar·​os·​elementos·​a·​adicionar·​ao·​seu·​relatório.​·​</​p><div·​class="variablelist">​<dl><dt><span·​class="term"><span·​class="bold"><strong>​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Rótu​lo</​span></​span></​strong></​span></​span></​dt><dd><p>Um·​elemento·​de·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Lege​nda</​span></​span>·​mostra·​as·​informações·​predefinidas·​num·​relatório.​·​Normalmente·​é·​usada·​como·​um·​título·​ao·​lado·​de·​outros·​elementos·​de·​dados.​</​p></​dd><dt><span·​class="term"><span·​class="bold"><strong>​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Camp​o</​span></​span></​strong></​span></​span></​dt><dd><p>Um·​elemento·​de·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="g·​✂
45 </​p><div·​class="screenshot"><d​iv·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="mediaobject"><​hr><img·​src="contact-​example.​png"><hr></​div></​div><p>45 </​p><div·​class="screenshot"><d​iv·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="mediaobject"><​hr><img·​src="contact-​example.​png"><hr></​div></​div><p>
46 </​p><p>A·​imagem·​acima·​mostra·​um·​conjunto·​de·​dois·​contatos,​·​sendo·​cada·​um·​deles·​apresentado·​em·​um·​cartão·​em·​separado.​·​Parece·​que·​cada·​um·​dos·​cartões·​poderá·​constituir·​uma·​linha·​única·​numa·​tabela:​·​</​p><p>46 </​p><p>A·​imagem·​acima·​mostra·​um·​conjunto·​de·​dois·​contatos,​·​sendo·​cada·​um·​deles·​apresentado·​em·​um·​cartão·​em·​separado.​·​Parece·​que·​cada·​um·​dos·​cartões·​poderá·​constituir·​uma·​linha·​única·​numa·​tabela:​·​</​p><p>
47 </​p><div·​class="table"><a·​name="idp144413624"><​/​a><p·​class="title"><b>Tabe​la·​6.​1.​·​<span·​class="emphasis"><em>​Tabela·​de·​contatos</​em></​span></​b></​p><div·​class="table-​contents"><table·​summary="Tabela·​de·​contatos"·​border="1"><colgroup>​<col><col></​colgroup><thead><tr><​th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Nome​</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Num.​·​Tel.​</​span></​span></​th></​tr></​thead><tbody><tr><td>​47 </​p><div·​class="table"><a·​name="idp144401336"><​/​a><p·​class="title"><b>Tabe​la·​6.​1.​·​<span·​class="emphasis"><em>​Tabela·​de·​contatos</​em></​span></​b></​p><div·​class="table-​contents"><table·​summary="Tabela·​de·​contatos"·​border="1"><colgroup>​<col><col></​colgroup><thead><tr><​th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Nome​</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Num.​·​Tel.​</​span></​span></​th></​tr></​thead><tbody><tr><td>​
48 ····​<p>João</​p>48 ····​<p>João</​p>
49 ····​</​td><td>49 ····​</​td><td>
50 ····​<p>699·​23·​43·​12</​p>50 ····​<p>699·​23·​43·​12</​p>
51 ····​</​td></​tr><tr><td>51 ····​</​td></​tr><tr><td>
52 ····​<p>Pedro</​p>52 ····​<p>Pedro</​p>
53 ····​</​td><td>53 ····​</​td><td>
54 ····​<p>711·​19·​77·​21</​p></​td></​tr></​tbody></​table></​div></​div><p><br·​class="table-​break">54 ····​<p>711·​19·​77·​21</​p></​td></​tr></​tbody></​table></​div></​div><p><br·​class="table-​break">
55 </​p><p>Termos·​e·​definições:​·​Um·​dado·​simples·​que·​constitui·​uma·​parte·​de·​uma·​coleção·​maior·​poderá·​ser·​chamado·​de·​<span·​class="emphasis"><em>​linha</​em></​span>·​ou,​·​de·​forma·​mais·​profissional,​·​um·​<span·​class="emphasis"><em>​registro</​em></​span>.​·​A·​coleção·​chama-​se·​normalmente·​<span·​class="emphasis"><em>​tabela</​em></​span>.​·​Além·​disso,​·​o·​nome·​mais·​natural·​para·​a·​tabela·​é·​um·​que·​descreve·​os·​dados·​que·​oferece/​armazena,​·​que·​é·​Contatos.​·​Depois·​disso,​·​cada·​linha·​da·​tabela·​consiste·​de·​colunas,​·​também·​chamadas·​de·​<span·​class="emphasis"><em>​campos</​em></​span>.​·​Na·​tabela·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="replaceable"><​em·​class="replaceable"><​code>Contatos</​code></​em></​span>,​·​existem·​duas·​colunas·​(campos)​:​·​o·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Nome​</​span></​span>·​e·​o·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Num.​·​Tel.​</​span></​span>.​·​</​p><p>Para·​usos·​simples,​·​uma·​única·​tabela·​poderá·​c·​✂55 </​p><p>Termos·​e·​definições:​·​Um·​dado·​simples·​que·​constitui·​uma·​parte·​de·​uma·​coleção·​maior·​poderá·​ser·​chamado·​de·​<span·​class="emphasis"><em>​linha</​em></​span>·​ou,​·​de·​forma·​mais·​profissional,​·​um·​<span·​class="emphasis"><em>​registro</​em></​span>.​·​A·​coleção·​chama-​se·​normalmente·​<span·​class="emphasis"><em>​tabela</​em></​span>.​·​Além·​disso,​·​o·​nome·​mais·​natural·​para·​a·​tabela·​é·​um·​que·​descreve·​os·​dados·​que·​oferece/​armazena,​·​que·​é·​Contatos.​·​Depois·​disso,​·​cada·​linha·​da·​tabela·​consiste·​de·​colunas,​·​também·​chamadas·​de·​<span·​class="emphasis"><em>​campos</​em></​span>.​·​Na·​tabela·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="replaceable"><​em·​class="replaceable"><​code>Contatos</​code></​em></​span>,​·​existem·​duas·​colunas·​(campos)​:​·​o·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Nome​</​span></​span>·​e·​o·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Num.​·​Tel.​</​span></​span>.​·​</​p><p>Para·​usos·​simples,​·​uma·​única·​tabela·​poderá·​c·​✂
56 </​p></​div><FILENAME·​filename="database-​and-​spreadsheet.​html"><html><head><ti​tle>Banco·​de·​Dados·​e·​Planilhas</​title><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​default.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​docs.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​localised.​css"><meta·​name="generator"·​content="DocBook·​XSL·​Stylesheets·​V1.​76.​1"><meta·​name="keywords"·​content="KDE,​·​Calligra,​·​Kexi,​·​banco·​de·​dados"><link·​rel="home"·​href="index.​html"·​title="Manual·​do·​Kexi"><link·​rel="up"·​href="appendix-​a-​-​introduction-​to-​databases.​html"·​title="Capítulo·​6.​·​Apêndice·​A.​·​Introdução·​aos·​Bancos·​de·​Dados"><link·​rel="prev"·​href="appendix-​a-​-​introduction-​to-​databases.​html"·​title="Capítulo·​6.​·​Apêndice·​A.​·​Introdução·​aos·​Bancos·​de·​Dados"><link·​rel="next"·​href="database-​design.​html"·​title="Desenho·​de·​Banco·​de·​Dados"><meta·​http-​equiv="Content-​Type"·​content="text/​html;​·​charset=utf-​8"><meta·​name="GENERATOR"·​content="KDE·​XSL·​Stylesheet·​V1.​14·​using·​libxslt"></​head><body·​bgcolo·​✂56 </​p></​div><FILENAME·​filename="database-​and-​spreadsheet.​html"><html><head><ti​tle>Banco·​de·​Dados·​e·​Planilhas</​title><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​default.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​docs.​css"><link·​rel="stylesheet"·​type="text/​css"·​href="help:​/​common/​kde-​localised.​css"><meta·​name="generator"·​content="DocBook·​XSL·​Stylesheets·​V1.​76.​1"><meta·​name="keywords"·​content="KDE,​·​Calligra,​·​Kexi,​·​banco·​de·​dados"><link·​rel="home"·​href="index.​html"·​title="Manual·​do·​Kexi"><link·​rel="up"·​href="appendix-​a-​-​introduction-​to-​databases.​html"·​title="Capítulo·​6.​·​Apêndice·​A.​·​Introdução·​aos·​Bancos·​de·​Dados"><link·​rel="prev"·​href="appendix-​a-​-​introduction-​to-​databases.​html"·​title="Capítulo·​6.​·​Apêndice·​A.​·​Introdução·​aos·​Bancos·​de·​Dados"><link·​rel="next"·​href="database-​design.​html"·​title="Desenho·​de·​Banco·​de·​Dados"><meta·​http-​equiv="Content-​Type"·​content="text/​html;​·​charset=utf-​8"><meta·​name="GENERATOR"·​content="KDE·​XSL·​Stylesheet·​V1.​14·​using·​libxslt"></​head><body·​bgcolo·​✂
57 </​p><div·​class="table"><a·​name="idp149475000"><​/​a><p·​class="title"><b>Tabe​la·​6.​2.​·​<span·​class="emphasis"><em>​Tabela·​de·​contatos</​em></​span></​b></​p><div·​class="table-​contents"><table·​summary="Tabela·​de·​contatos"·​border="1"><colgroup>​<col><col><col></​colgroup><thead><tr><​th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Nome​·​e·​sobrenome</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Tel<​/​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Ende​reço</​span></​span></​th></​tr></​thead><tbody><tr><td>​57 </​p><div·​class="table"><a·​name="idp149458616"><​/​a><p·​class="title"><b>Tabe​la·​6.​2.​·​<span·​class="emphasis"><em>​Tabela·​de·​contatos</​em></​span></​b></​p><div·​class="table-​contents"><table·​summary="Tabela·​de·​contatos"·​border="1"><colgroup>​<col><col><col></​colgroup><thead><tr><​th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Nome​·​e·​sobrenome</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Tel<​/​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Ende​reço</​span></​span></​th></​tr></​thead><tbody><tr><td>​
58 ····​<p>João·​Pires</​p>58 ····​<p>João·​Pires</​p>
59 ····​</​td><td>59 ····​</​td><td>
60 ····​<p>699·​23·​43·​12</​p>60 ····​<p>699·​23·​43·​12</​p>
61 ····​</​td><td>61 ····​</​td><td>
62 ····​<p>Rua·​do·​Angustura,​·​Nr·​1,​·​Rio·​de·​Janeiro</​p>62 ····​<p>Rua·​do·​Angustura,​·​Nr·​1,​·​Rio·​de·​Janeiro</​p>
63 ····​</​td></​tr><tr><td>63 ····​</​td></​tr><tr><td>
64 ····​<p>Pedro·​Morais</​p>64 ····​<p>Pedro·​Morais</​p>
Offset 81, 24 lines modifiedOffset 81, 24 lines modified
81 ····​</​td></​tr><tr><td>81 ····​</​td></​tr><tr><td>
82 ····​<p>PEDRO·​Morais</​p>82 ····​<p>PEDRO·​Morais</​p>
83 ····​</​td><td>83 ····​</​td><td>
84 ····​<p>231·​83·​02·​04</​p>84 ····​<p>231·​83·​02·​04</​p>
85 ····​</​td><td>85 ····​</​td><td>
86 ····​<p>Rua·​7·​de·​Setembro,​·​Nr·​2,​·​São·​Paulo</​p></​td></​tr></​tbody></​table></​div></​div><p><br·​class="table-​break">86 ····​<p>Rua·​7·​de·​Setembro,​·​Nr·​2,​·​São·​Paulo</​p></​td></​tr></​tbody></​table></​div></​div><p><br·​class="table-​break">
87 </​p><p>Uma·​tabela·​como·​esta·​tanto·​pode·​ser·​feita·​numa·​planilha·​como·​numa·​base·​de·​dados.​·​Usar·​uma·​planilha·​é·​muito·​simples,​·​claro.​·​Quais·​são·​os·​problemas·​que·​nós·​encontraremos·​neste·​estágio?·​</​p></​div><div·​class="sect2"><div·​class="titlepage"><di​v><div><h3·​class="title"><a·​name="referential-​data-​integrity"></​a>Integridade·​referencial·​dos·​dados</​h3></​div></​div></​div><p>Suponha·​que·​você·​está·​usando·​uma·​planilha·​e·​necessita·​alterar·​o·​endereço·​de,​·​pelo·​menos,​·​uma·​pessoa.​·​Você·​tem·​aí·​um·​pequeno·​problema:​·​terá·​frequentemente·​que·​alterar·​o·​endereço·​em·​várias·​linhas.​·​Por·​exemplo,​·​o·​João·​ocupa·​três·​linhas.​·​Um·​problema·​real·​ocorrerá·​se·​você·​se·​esquecer·​de·​alterar·​uma·​das·​linhas·​-​·​o·​endereço·​atribuído·​a·​essa·​pessoa·​será·​ambíguo,​·​logo·​os·​seus·​dados·​perdem·​integridade.​·​</​p><p>Além·​disso,​·​não·​existe·​uma·​forma·​simples·​de·​remover·​uma·​pessoa·​escolhida·​da·​tabela,​·​uma·​vez·​que·​você·​terá·​que·​se·​lembrar·​de·​apagar·​todas·​as·​linhas·​relacionadas·​com·​ela.​·​</​p></​div><div·​class="sect2"><div·​class="titlepage"><di​v><div><h3·​class="title"><a·​✂87 </​p><p>Uma·​tabela·​como·​esta·​tanto·​pode·​ser·​feita·​numa·​planilha·​como·​numa·​base·​de·​dados.​·​Usar·​uma·​planilha·​é·​muito·​simples,​·​claro.​·​Quais·​são·​os·​problemas·​que·​nós·​encontraremos·​neste·​estágio?·​</​p></​div><div·​class="sect2"><div·​class="titlepage"><di​v><div><h3·​class="title"><a·​name="referential-​data-​integrity"></​a>Integridade·​referencial·​dos·​dados</​h3></​div></​div></​div><p>Suponha·​que·​você·​está·​usando·​uma·​planilha·​e·​necessita·​alterar·​o·​endereço·​de,​·​pelo·​menos,​·​uma·​pessoa.​·​Você·​tem·​aí·​um·​pequeno·​problema:​·​terá·​frequentemente·​que·​alterar·​o·​endereço·​em·​várias·​linhas.​·​Por·​exemplo,​·​o·​João·​ocupa·​três·​linhas.​·​Um·​problema·​real·​ocorrerá·​se·​você·​se·​esquecer·​de·​alterar·​uma·​das·​linhas·​-​·​o·​endereço·​atribuído·​a·​essa·​pessoa·​será·​ambíguo,​·​logo·​os·​seus·​dados·​perdem·​integridade.​·​</​p><p>Além·​disso,​·​não·​existe·​uma·​forma·​simples·​de·​remover·​uma·​pessoa·​escolhida·​da·​tabela,​·​uma·​vez·​que·​você·​terá·​que·​se·​lembrar·​de·​apagar·​todas·​as·​linhas·​relacionadas·​com·​ela.​·​</​p></​div><div·​class="sect2"><div·​class="titlepage"><di​v><div><h3·​class="title"><a·​✂
88 </​p><div·​class="table"><a·​name="idp149497400"><​/​a><p·​class="title"><b>Tabe​la·​6.​3.​·​<span·​class="emphasis"><em>​Tabela·​de·​pessoas</​em></​span></​b></​p><div·​class="table-​contents"><table·​summary="Tabela·​de·​pessoas"·​border="1"><colgroup>​<col><col></​colgroup><thead><tr><​th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Nome​·​e·​sobrenome</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Ende​reço</​span></​span></​th></​tr></​thead><tbody><tr><td>​88 </​p><div·​class="table"><a·​name="idp149481016"><​/​a><p·​class="title"><b>Tabe​la·​6.​3.​·​<span·​class="emphasis"><em>​Tabela·​de·​pessoas</​em></​span></​b></​p><div·​class="table-​contents"><table·​summary="Tabela·​de·​pessoas"·​border="1"><colgroup>​<col><col></​colgroup><thead><tr><​th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Nome​·​e·​sobrenome</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Ende​reço</​span></​span></​th></​tr></​thead><tbody><tr><td>​
89 ····​<p>João·​Pires</​p>89 ····​<p>João·​Pires</​p>
90 ····​</​td><td>90 ····​</​td><td>
91 ····​<p>Rua·​do·​Angustura,​·​Nr·​1,​·​Rio·​de·​Janeiro</​p>91 ····​<p>Rua·​do·​Angustura,​·​Nr·​1,​·​Rio·​de·​Janeiro</​p>
92 ····​</​td></​tr><tr><td>92 ····​</​td></​tr><tr><td>
93 ····​<p>Pedro·​Morais</​p>93 ····​<p>Pedro·​Morais</​p>
94 ····​</​td><td>94 ····​</​td><td>
95 ····​<p>Rua·​7·​de·​Setembro,​·​Nr·​2,​·​São·​Paulo</​p></​td></​tr></​tbody></​table></​div></​div><p><br·​class="table-​break">95 ····​<p>Rua·​7·​de·​Setembro,​·​Nr·​2,​·​São·​Paulo</​p></​td></​tr></​tbody></​table></​div></​div><p><br·​class="table-​break">
96 </​p><p>Cada·​linha·​da·​tabela·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="replaceable"><​em·​class="replaceable"><​code>Pessoas</​code></​em></​span>·​corresponde·​a·​uma·​única·​pessoa.​·​A·​tabela·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="replaceable"><​em·​class="replaceable"><​code>Contatos</​code></​em></​span>·​é,​·​a·​partir·​de·​agora,​·​uma·​relação·​com·​a·​tabela·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="replaceable"><​em·​class="replaceable"><​code>Pessoas</​code></​em></​span>.​·​</​p></​div><div·​class="sect2"><div·​class="titlepage"><di​v><div><h3·​class="title"><a·​name="data-​integrity-​and-​validity"></​a>Integridade·​e·​validade·​dos·​dados</​h3></​div></​div></​div><p>Repare·​na·​forma·​como·​os·​dados·​são·​introduzidos·​nos·​campos·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="replaceable"><​em·​class="replaceable"><​code>Nome·​e·​sobrenome</​code></​em></​span>·​e·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="replaceable"><​em·​class="replaceable"><​code>Endereço<·​✂96 </​p><p>Cada·​linha·​da·​tabela·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="replaceable"><​em·​class="replaceable"><​code>Pessoas</​code></​em></​span>·​corresponde·​a·​uma·​única·​pessoa.​·​A·​tabela·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="replaceable"><​em·​class="replaceable"><​code>Contatos</​code></​em></​span>·​é,​·​a·​partir·​de·​agora,​·​uma·​relação·​com·​a·​tabela·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="replaceable"><​em·​class="replaceable"><​code>Pessoas</​code></​em></​span>.​·​</​p></​div><div·​class="sect2"><div·​class="titlepage"><di​v><div><h3·​class="title"><a·​name="data-​integrity-​and-​validity"></​a>Integridade·​e·​validade·​dos·​dados</​h3></​div></​div></​div><p>Repare·​na·​forma·​como·​os·​dados·​são·​introduzidos·​nos·​campos·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="replaceable"><​em·​class="replaceable"><​code>Nome·​e·​sobrenome</​code></​em></​span>·​e·​<span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="replaceable"><​em·​class="replaceable"><​code>Endereço<·​✂
97 </​p><div·​class="table"><a·​name="idp149582264"><​/​a><p·​class="title"><b>Tabe​la·​6.​4.​·​<span·​class="emphasis"><em>​Tabela·​de·​pessoas</​em></​span></​b></​p><div·​class="table-​contents"><table·​summary="Tabela·​de·​pessoas"·​border="1"><colgroup>​<col><col><col><col><​col></​colgroup><thead><tr><​th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Nome​</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Sobr​enome</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Rua<​/​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Núme​ro</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Cida​de</​span></​span></​th></​tr></​thead><tbody><tr><td>​97 </​p><div·​class="table"><a·​name="idp149512632"><​/​a><p·​class="title"><b>Tabe​la·​6.​4.​·​<span·​class="emphasis"><em>​Tabela·​de·​pessoas</​em></​span></​b></​p><div·​class="table-​contents"><table·​summary="Tabela·​de·​pessoas"·​border="1"><colgroup>​<col><col><col><col><​col></​colgroup><thead><tr><​th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Nome​</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Sobr​enome</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Rua<​/​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Núme​ro</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Cida​de</​span></​span></​th></​tr></​thead><tbody><tr><td>​
98 ····​<p>João</​p>98 ····​<p>João</​p>
99 ····​</​td><td>99 ····​</​td><td>
100 ····​<p>Pires</​p>100 ····​<p>Pires</​p>
101 ····​</​td><td>101 ····​</​td><td>
102 ····​<p>Rua·​do·​Angustura</​p>102 ····​<p>Rua·​do·​Angustura</​p>
103 ····​</​td><td>103 ····​</​td><td>
104 ····​<p>1</​p>104 ····​<p>1</​p>
Offset 123, 15 lines modifiedOffset 123, 15 lines modified
123 ····​</​td><td>123 ····​</​td><td>
124 ····​<p>campo·​obrigatório</​p>124 ····​<p>campo·​obrigatório</​p>
125 ····​</​td><td>125 ····​</​td><td>
126 ····​<p>campo·​obrigatório</​p>126 ····​<p>campo·​obrigatório</​p>
127 ····​</​td><td>127 ····​</​td><td>
128 ····​<p>campo·​obrigatório</​p></​td></​tr></​tbody></​table></​div></​div><p><br·​class="table-​break">128 ····​<p>campo·​obrigatório</​p></​td></​tr></​tbody></​table></​div></​div><p><br·​class="table-​break">
129 </​p><p>Graças·​à·​introdução·​das·​condições·​para·​campo·​obrigatório,​·​nós·​poderemos·​garantir·​que·​os·​dados·​inseridos·​estão·​completos.​·​No·​caso·​das·​outras·​tabelas,​·​você·​poderá·​obviamente·​permitir·​a·​omissão·​de·​certos·​campos·​ao·​inserir·​dados.​·​</​p></​div><div·​class="sect2"><div·​class="titlepage"><di​v><div><h3·​class="title"><a·​name="limiting-​data-​view"></​a>Limitar·​a·​visibilidade·​dos·​dados</​h3></​div></​div></​div><p>Uma·​planilha·​mostra·​todas·​as·​linhas·​e·​colunas·​da·​tabela,​·​o·​que·​poderá·​ser·​incômodo·​no·​caso·​de·​folhas·​de·​dados·​muito·​grandes.​·​Você·​poderá,​·​obviamente,​·​filtrar·​e·​ordenar·​as·​linhas·​nas·​folhas·​de·​cálculo,​·​contudo·​deverá·​ter·​bastante·​cuidado·​ao·​fazê-​lo.​·​Os·​usuários·​da·​planilhas·​correm·​o·​risco·​de·​se·​esquecer·​que·​os·​dados·​foram·​filtrados,​·​o·​que·​poderá·​conduzir·​a·​erros.​·​Por·​exemplo,​·​ao·​calcular·​somas,​·​você·​poderá·​pensar·​que·​tem·​100·​linhas·​de·​dados·​visíveis,​·​quando·​de·​fato·​existem·​mais·​20·​ocultas.​·​</​p><p>Se·​quiser·​lidar·​com·​um·​pequeno·​subconjunto·​de·​dados,​·​por·​exemplo,​·​para·​enviá-​lo·​para·​outras·​pessoas·​editarem,​·​você·​pode·​✂129 </​p><p>Graças·​à·​introdução·​das·​condições·​para·​campo·​obrigatório,​·​nós·​poderemos·​garantir·​que·​os·​dados·​inseridos·​estão·​completos.​·​No·​caso·​das·​outras·​tabelas,​·​você·​poderá·​obviamente·​permitir·​a·​omissão·​de·​certos·​campos·​ao·​inserir·​dados.​·​</​p></​div><div·​class="sect2"><div·​class="titlepage"><di​v><div><h3·​class="title"><a·​name="limiting-​data-​view"></​a>Limitar·​a·​visibilidade·​dos·​dados</​h3></​div></​div></​div><p>Uma·​planilha·​mostra·​todas·​as·​linhas·​e·​colunas·​da·​tabela,​·​o·​que·​poderá·​ser·​incômodo·​no·​caso·​de·​folhas·​de·​dados·​muito·​grandes.​·​Você·​poderá,​·​obviamente,​·​filtrar·​e·​ordenar·​as·​linhas·​nas·​folhas·​de·​cálculo,​·​contudo·​deverá·​ter·​bastante·​cuidado·​ao·​fazê-​lo.​·​Os·​usuários·​da·​planilhas·​correm·​o·​risco·​de·​se·​esquecer·​que·​os·​dados·​foram·​filtrados,​·​o·​que·​poderá·​conduzir·​a·​erros.​·​Por·​exemplo,​·​ao·​calcular·​somas,​·​você·​poderá·​pensar·​que·​tem·​100·​linhas·​de·​dados·​visíveis,​·​quando·​de·​fato·​existem·​mais·​20·​ocultas.​·​</​p><p>Se·​quiser·​lidar·​com·​um·​pequeno·​subconjunto·​de·​dados,​·​por·​exemplo,​·​para·​enviá-​lo·​para·​outras·​pessoas·​editarem,​·​você·​pode·​✂
130 </​p><div·​class="table"><a·​name="idp149605176"><​/​a><p·​class="title"><b>Tabe​la·​6.​5.​·​<span·​class="emphasis"><em>​Tabela·​de·​pessoas</​em></​span></​b></​p><div·​class="table-​contents"><table·​summary="Tabela·​de·​pessoas"·​border="1"><colgroup>​<col><col><col><col><​col><col></​colgroup><thead><tr><​th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Nome​</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Sobr​enome</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Rua<​/​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Núme​ro</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Cida​de</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Venc​imento</​s·​✂130 </​p><div·​class="table"><a·​name="idp149588792"><​/​a><p·​class="title"><b>Tabe​la·​6.​5.​·​<span·​class="emphasis"><em>​Tabela·​de·​pessoas</​em></​span></​b></​p><div·​class="table-​contents"><table·​summary="Tabela·​de·​pessoas"·​border="1"><colgroup>​<col><col><col><col><​col><col></​colgroup><thead><tr><​th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Nome​</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Sobr​enome</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Rua<​/​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Núme​ro</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Cida​de</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Venc​imento</​s·​✂
131 ····​<p>João</​p>131 ····​<p>João</​p>
132 ····​</​td><td>132 ····​</​td><td>
133 ····​<p>Pires</​p>133 ····​<p>Pires</​p>
134 ····​</​td><td>134 ····​</​td><td>
135 ····​<p>Rua·​do·​Angustura</​p>135 ····​<p>Rua·​do·​Angustura</​p>
136 ····​</​td><td>136 ····​</​td><td>
137 ····​<p>1</​p>137 ····​<p>1</​p>
Offset 148, 15 lines modifiedOffset 148, 15 lines modified
148 ····​</​td><td>148 ····​</​td><td>
149 ····​<p>5</​p>149 ····​<p>5</​p>
150 ····​</​td><td>150 ····​</​td><td>
151 ····​<p>São·​Paulo</​p>151 ····​<p>São·​Paulo</​p>
152 ····​</​td><td>152 ····​</​td><td>
153 ····​<p>1900</​p></​td></​tr></​tbody></​table></​div></​div><p><br·​class="table-​break">153 ····​<p>1900</​p></​td></​tr></​tbody></​table></​div></​div><p><br·​class="table-​break">
154 </​p><p>Vamos·​assumir·​que·​a·​coluna·​recém·​introduzida,​·​Salário,​·​contém·​dados·​confidenciais.​·​Como·​você·​poderá·​compartilhar,​·​por·​exemplo,​·​detalhes·​de·​contato·​das·​pessoas·​com·​os·​seus·​colaboradores,​·​mas·​sem·​revelar·​os·​seus·​salários?·​É·​possível·​se·​compartilhar·​apenas·​uma·​consulta·​e·​não·​a·​tabela·​inteira.​·​A·​consulta·​poderia·​selecionar·​todas·​as·​colunas,​·​exceto·​a·​coluna·​Salário.​·​No·​mundo·​dos·​bancos·​de·​dados,​·​esse·​tipo·​de·​consulta·​é·​normalmente·​chamado·​de·​visão.​·​</​p></​div><div·​class="sect2"><div·​class="titlepage"><di​v><div><h3·​class="title"><a·​name="performance-​and-​capacity"></​a>Performance·​e·​capacidade</​h3></​div></​div></​div><p>O·​seu·​computador·​poderá·​ser·​muito·​rápido,​·​contudo·​você·​irá·​notar·​que·​não·​o·​ajudará·​com·​planilhas·​lentas·​e·​grandes.​·​A·​sua·​eficiência·​baixa·​é,​·​antes·​de·​tudo,​·​devida·​à·​falta·​de·​índices·​que·​acelerem·​o·​processo·​de·​procura·​de·​dados·​(os·​bancos·​de·​dados·​oferecem·​estes·​índices)​.​·​Além·​disso,​·​se·​você·​usar·​coisas·​como·​a·​área·​de·​transferência·​do·​sistema,​·​até·​a·​cópia·​de·​dados·​poderá·​ser·​problemática·​com·​o·​tempo·​✂154 </​p><p>Vamos·​assumir·​que·​a·​coluna·​recém·​introduzida,​·​Salário,​·​contém·​dados·​confidenciais.​·​Como·​você·​poderá·​compartilhar,​·​por·​exemplo,​·​detalhes·​de·​contato·​das·​pessoas·​com·​os·​seus·​colaboradores,​·​mas·​sem·​revelar·​os·​seus·​salários?·​É·​possível·​se·​compartilhar·​apenas·​uma·​consulta·​e·​não·​a·​tabela·​inteira.​·​A·​consulta·​poderia·​selecionar·​todas·​as·​colunas,​·​exceto·​a·​coluna·​Salário.​·​No·​mundo·​dos·​bancos·​de·​dados,​·​esse·​tipo·​de·​consulta·​é·​normalmente·​chamado·​de·​visão.​·​</​p></​div><div·​class="sect2"><div·​class="titlepage"><di​v><div><h3·​class="title"><a·​name="performance-​and-​capacity"></​a>Performance·​e·​capacidade</​h3></​div></​div></​div><p>O·​seu·​computador·​poderá·​ser·​muito·​rápido,​·​contudo·​você·​irá·​notar·​que·​não·​o·​ajudará·​com·​planilhas·​lentas·​e·​grandes.​·​A·​sua·​eficiência·​baixa·​é,​·​antes·​de·​tudo,​·​devida·​à·​falta·​de·​índices·​que·​acelerem·​o·​processo·​de·​procura·​de·​dados·​(os·​bancos·​de·​dados·​oferecem·​estes·​índices)​.​·​Além·​disso,​·​se·​você·​usar·​coisas·​como·​a·​área·​de·​transferência·​do·​sistema,​·​até·​a·​cópia·​de·​dados·​poderá·​ser·​problemática·​com·​o·​tempo·​✂
155 </​p><div·​class="table"><a·​name="idp149707704"><​/​a><p·​class="title"><b>Tabe​la·​7.​1.​·​<span·​class="emphasis"><em>​Comparação·​dos·​tipos·​de·​dados·​usados·​no·​Kexi·​e·​nas·​outras·​aplicações·​de·​bases·​de·​dados</​em></​span></​b></​p><div·​class="table-​contents"><table·​summary="Comparação·​dos·​tipos·​de·​dados·​usados·​no·​Kexi·​e·​nas·​outras·​aplicações·​de·​bases·​de·​dados"·​border="1"><colgroup>​<col><col><col><col><​/​colgroup><thead><tr><​th><span·​class="application">K​exi</​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">MS·​Access</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">dBas​e/​FoxPro</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Para​dox</​span></​span></​th></​tr></​thead><tbody><tr><td>​155 </​p><div·​class="table"><a·​name="idp149687224"><​/​a><p·​class="title"><b>Tabe​la·​7.​1.​·​<span·​class="emphasis"><em>​Comparação·​dos·​tipos·​de·​dados·​usados·​no·​Kexi·​e·​nas·​outras·​aplicações·​de·​bases·​de·​dados</​em></​span></​b></​p><div·​class="table-​contents"><table·​summary="Comparação·​dos·​tipos·​de·​dados·​usados·​no·​Kexi·​e·​nas·​outras·​aplicações·​de·​bases·​de·​dados"·​border="1"><colgroup>​<col><col><col><col><​/​colgroup><thead><tr><​th><span·​class="application">K​exi</​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">MS·​Access</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">dBas​e/​FoxPro</​span></​span></​th><th><span·​xmlns:​doc="http:​/​/​nwalsh.​com/​xsl/​documentation/​1.​0"·​class="guiitem"><span​·​class="guilabel">Para​dox</​span></​span></​th></​tr></​thead><tbody><tr><td>​
156 ····​<p>Texto</​p>156 ····​<p>Texto</​p>
157 ····​</​td><td>157 ····​</​td><td>
158 ····​<p>Texto</​p>158 ····​<p>Texto</​p>
159 ····​</​td><td>159 ····​</​td><td>
160 ····​<p>Caractere</​p>160 ····​<p>Caractere</​p>
161 ····​</​td><td>161 ····​</​td><td>
162 ····​<p>Alfanumérico</​p>162 ····​<p>Alfanumérico</​p>