User: clu Date: 06/04/05 04:49:45 Modified: /dba/www/QA/ Connection_Test.html
Log: correct format File Changes: Directory: /dba/www/QA/ ======================= File [changed]: Connection_Test.html Url: http://dba.openoffice.org/source/browse/dba/www/QA/Connection_Test.html?r1=1.24&r2=1.25 Delta lines: +37 -34 --------------------- --- Connection_Test.html 4 Apr 2006 08:42:02 -0000 1.24 +++ Connection_Test.html 5 Apr 2006 11:49:31 -0000 1.25 @@ -40,6 +40,8 @@ </div> <dd>0. open or create according database for testing</dd> + +<p>- create tables -</p> <dd>1. create a new table (by clicking on the 'table container' and choosing: 'create table in design view...')</dd> <dd>-> table design window appear</dd> <dd>2. insert any field name and save table (with 'save' icon in toolbar or file/save menue)</dd> @@ -47,50 +49,52 @@ <dd>3. insert any table name and push the 'ok' button</dd> <dd>-> proposual dialog for primary key appears (if database support primary key)</dd> <dd>4. push the 'no' button and close the window</dd> +<dd>=> check: 'create tables' on your checklist (if works fine/ok (+) or not supported (-) or works partly/with workaround (?)) </dd><br><br> -<p>=> check: 'create tables' on your checklist (if works fine/ok (+) or not supported (-) or works partly/with workaround (?))</p> - +<p>- primary key -</p> <dd>5. repeat step 1. to 3. but choose 'yes' for primary key in step 4.</dd> +<dd>=> check: 'primary key' on your checklist (ok(+) - not supported(-) - works partly(?))</dd> -<p>=> check: 'primary key' on your checklist (ok(+) - not supported(-) - works partly(?))</p> - +<p>- delete tables -</p> <dd>6. delete both tables (by context on tablename or 'del' key on keyboard)</dd> +<dd>=> check: 'delete tables' (+-?)</dd> -<p>=> check: 'delete tables' (+-?)</p> - +<p>- insert table fields -</p> <dd>7. create a table with several fields (with different field types of your choice)</dd> <dd>8. save and close table (with primary key if supported)</dd> <dd>9. open table in design view (by context on table and 'edit' or in edit/edit menue)</dd> <dd>10. add a field and save table</dd> +<dd>=> check: 'insert table fields'</dd> -<p>=> check: 'insert table fields'</p> - +<p>- modify table fields -</p> <dd>11. change any field name and any field type and save the table</dd> <dd>-> if warning dialog appear click 'yes' (warning dialog propose appending as new table)</dd> +<dd>=> check: 'modify table fields'</dd> -<p>=> check: 'modify table fields'</p> - +<p>- modify table fields -</p> <dd>12. delete any field and save the table</dd> +<dd>=> check: 'delete table fields'</dd> -<p>=> check: 'delete table fields'</p> - +<p>- insert table data -</p> +<p>- insert table rows -</p> <dd>13. close the table, and reload it (menue: view/refresh tables)</dd> <dd>14. open the table in design view again, control and close (check if the 'insert/modified/deleted' changes are still present)</dd> <dd>15. open the table in normal view (doubleclick on table or context/open)</dd> <dd>16. insert some rows with any data and save (or leave current row - should save data, too)</dd> +<dd>=> check: 'insert table data'</dd> +<dd>=> check: 'insert table rows'</dd> -<p>=> check: 'insert table data'</p> -<p>=> check: 'insert table rows'</p> - +<p>- modify table data -</p> <dd>17. change any content and save</dd> +<dd>=> check: 'modify table data'</dd> -<p>=> check: 'modify table data'</p> - +<p>- delete table data -</p> +<p>- delete table rows -</p> <dd>18. delete any content and any table row (by context or by marking whole row and pushing 'del' key on keyboard)</dd> +<dd>=> check: 'delete table data'</dd> +<dd>=> check: 'delete table rows'</dd> -<p>=> check: 'delete table data'</p> -<p>=> check: 'delete table rows'</p> - +<p>- create query -</p> <dd>19. close table and push the 'query container'</dd> <dd>20. create a new query (in design view)</dd> <dd>-> 'add tables' dialog appear</dd> @@ -100,33 +104,33 @@ <dd>23. run and save the query (by corresponding icon or menue: edit/run query)</dd> <dd>-> upper 'result' window should appear (and show the result of the query)</dd> <dd>24. close and reopen the query in design view (context:'edit')</dd> +<dd>=> check: 'create query'</dd> -<p>=> check: 'create query'</p> - +<p>- modify query -</p> <dd>25. insert any further field, or delete one (delete field by marking 'field header' in lower grid and context or 'del' key)</dd> <dd>26. save and close query design</dd> <dd>27. reopen and verify the change you have made</dd> +<dd>=> check: 'modify query'</dd> -<p>=> check: 'modify query'</p> - +<p>- delete query -</p> <dd>28. close query and delete it</dd> +<dd>=> check: 'delete query'</dd> -<p>=> check: 'delete query'<br></p> - +<p>- views -</p> <dd>29. create a new 'view' (table container/create view - if supported)</dd> <dd>30. save, close and delete it</dd> +<dd>=> check: 'views'</dd> -<p>=> check: 'views'</p> - +<p>- indexes -</p> <dd>31. open or create any table in design view</dd> <dd>32. open the 'index' design dialog (in menue: tools/index design or with according icon)</dd> <dd>-> index dialog appear</dd> <dd>33. create a new index, save it and close dialog and table (with the according icons)</dd> <dd>34. refresh tables and reopen test table (from menue: view/refresh tables)</dd> <dd>35. reopen index dialog and recheck if index still present</dd> +<dd>=> check: 'indexes'</dd> -<p>=> check: 'indexes'</p> - +<p>- joins -</p> <dd>36. close dialog and table design</dd> <dd>37. create any other table (for further test we need min. two tables)</dd> <dd>38. open a new query in design view</dd> @@ -144,9 +148,9 @@ <dd>46. open the query in design view and doubleclick on the 'connector'</dd> <dd>-> the 'join property' dialog appear</dd> <dd>47. check the other proposed join 'types' if supported (43. to 46.)</dd> +<dd>=> check: 'join'</dd> -<p>=> check: 'join'</p> - +<p>- relations -</p> <dd>48. close dialog and query design</dd> <dd>49. open the 'relation design' (menue: tools/relationships)</dd> <dd>-> dialog appear</dd> @@ -155,8 +159,7 @@ <dd>51. drag and drop a field from one table container to the other (does not work with every field - try the two primary key fields)</dd> <dd>-> 'connector ' between the two table container appear (with doubleclick on it, dialog available)</dd> <dd>52. save, refresh, reopen and recheck if everything is still fine</dd> - -<p>=> check: 'relations'</p> +<dd>=> check: 'relations'</dd> <p> <div align="center">- finish test -</div><br><br> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
