How can I fill the fields of a table in LibreOffice Base automatically? -

-

i have database contains table of cellphones. let's every cellphone has 10 fields. in order fill or modify table have several forms available user. however, don't want user modify 10 fields every time. want him give information 4 of fields , rest of them automatically filled or modified program. know how that? :)

while possible triggers, macros, or other coding, it's bad database practice have calculated fields or duplicate data stored in tables. related data should stored through relationships between tables , displayed in query, not directly in table.

so if, say, each store sells single color of phone, have user enter store. have table showed relationship between store name , phone color. when wanted list of users , phone colors, write query looks @ table list of users , bought phones , joins list of stores , colors sell.

my advice has 3 tiers:

  • almost best - redesign database more normalized, meaning use relationships between tables prevent need duplicate data.
  • if decide need macros, resource working openoffice macros andrew pitonyak's book openoffice macros explained (a free download website).
  • sql triggers cleaner way of doing (compared macros) not supported old database engine base default. (base handles queries, forms, , reports. tables handled separate software, default old version 1.8 of hypersql database or hsqldb "embedded" inside base.) need upgrade newer database software. instructions on upgrading hsqldb 2.3 in thread: [tutorial] splitting "embedded hsql database"

Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile:
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -

-
i trying add nodes dagre graph through cityscape.js. problem nodes not painted. code have: cy.add({ group: "nodes", data: { id:"n0",name:"n0",weight: 75 }, }); $.ajax(url).done(function(jsontree){ var newnodes=[]; for(var i=1;i<6;i++){ //var child = jsontree.result[i]; newnodes.push( { group: "nodes", data: { id: "n"+i, name:"n"+i}}, { group: "edges", data: { id: "e"+i, source: "n0", target: "n"+i } } ); } cy.add(newnodes); any ideas? have used loaded function reload graph not work. not know if have use specific function reload graph. thank in advance. you need add positions new nodes. cytoscape.js docs : it important note positions of newly added nodes must defined when calling cy.add(). nodes can not placed in graph without valid position — otherwise not displayed. yo
Read more