User: clu Date: 06/04/03 05:36:01 Modified: /dba/www/QA/ Connection_Test.html
Log: deleted <br> returns 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.14&r2=1.15 Delta lines: +117 -117 ----------------------- --- Connection_Test.html 3 Apr 2006 12:29:47 -0000 1.14 +++ Connection_Test.html 3 Apr 2006 12:35:56 -0000 1.15 @@ -44,163 +44,163 @@ <dd>2. insert any field name and save table (with 'save' icon in toolbar or file/save menue) -> save dialog appear</dd> <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</dd><br> +<dd>4. push the 'no' button</dd> -=> check: 'create tables' on your checklist (if works fine/ok (+) or not supported (-) or works partly/with workaround (?))<br><br> +=> check: 'create tables' on your checklist (if works fine/ok (+) or not supported (-) or works partly/with workaround (?)) -<dd>5. repeat step 1. to 3. but choose 'yes' for primary key in step 4.</dd><br><br> +<dd>5. repeat step 1. to 3. but choose 'yes' for primary key in step 4.</dd> -=> check: 'primary key' on your checklist (ok(+) - not supported(-) - works partly(?))<br><br> +=> check: 'primary key' on your checklist (ok(+) - not supported(-) - works partly(?)) -<dd>6. delete both tables (by context on tablename or 'del' key on keyboard)</dd><br><br> +<dd>6. delete both tables (by context on tablename or 'del' key on keyboard)</dd> -=> check: 'delete tables' (+-?)<br><br> +=> check: 'delete tables' (+-?) -<dd>7. create a table with several fields (with different field types of your choice)</dd><br> -<dd>8. save and close table (with primary key if supported)</dd><br> -<dd>9. open table in design view (by context on table and 'edit')</dd><br> -<dd>10. add a field and save table</dd><br><br> +<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')</dd> +<dd>10. add a field and save table</dd> -=> check: 'insert table fields'<br><br> +=> check: 'insert table fields' -<dd>11. change any field name and any field type and save the table</dd><br> -<dd>-> if warning dialog appear click 'yes' (warning dialog propose appending new table)</dd><br><br> +<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 new table)</dd> -=> check: 'modify table fields'<br><br> +=> check: 'modify table fields' -<dd>12. delete any field and save the table</dd><br><br> +<dd>12. delete any field and save the table</dd> -=> check: 'delete table fields'<br><br> +=> check: 'delete table fields' -<dd>13. close the table, and reload it (menue: view/refresh tables)</dd><br> -<dd>14. open the table in design view again and recheck and close (check if the 'insert/modified/deleted' changes are still present)</dd><br> -<dd>15. open the table in normal view (doubleclick on table or context/open)</dd><br> -<dd>16. insert some rows with any data and save (or leave current row - should save data, too)</dd><br><br> +<dd>13. close the table, and reload it (menue: view/refresh tables)</dd> +<dd>14. open the table in design view again and recheck 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> -=> check: 'insert table data'<br> -=> check: 'insert table rows'<br><br> +=> check: 'insert table data' +=> check: 'insert table rows' -<dd>17. change any content and save</dd><br><br> +<dd>17. change any content and save</dd> -=> check: 'modify table data'<br><br> +=> check: 'modify table data' -<dd>18. delete any content and any table row (by context or by marking whole row and pushing 'del' key on keyboard)</dd><br><br> +<dd>18. delete any content and any table row (by context or by marking whole row and pushing 'del' key on keyboard)</dd> -=> check: 'delete table data'<br> -=> check: 'delete table rows'<br><br> +=> check: 'delete table data' +=> check: 'delete table rows' -<dd>19. close table and push the 'query container'</dd><br> -<dd>20. create a new query (in design view)</dd><br> -<dd>-> 'add tables' dialog appear</dd><br> -<dd>21. add the created test table (or any else containing different field types and any data)</dd><br> -<dd>-> 'table' container appear</dd><br> -<dd>22. choose some fields from 'table container' (by doubleclicking on tablename or field listbox in lower grid)</dd><br> -<dd>23. run and save the query (by corresponding icon or menue: edit/run query)</dd><br> -<dd>-> upper windows shoud appear (and show the result of the query)</dd><br> -<dd>24. close and reopen the query in design view (context:'edit')</dd><br><br> +<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> +<dd>21. add the created test table (or any else containing different field types and any data)</dd> +<dd>-> 'table' container appear</dd> +<dd>22. choose some fields from 'table container' (by doubleclicking on tablename or field listbox in lower grid)</dd> +<dd>23. run and save the query (by corresponding icon or menue: edit/run query)</dd> +<dd>-> upper windows shoud appear (and show the result of the query)</dd> +<dd>24. close and reopen the query in design view (context:'edit')</dd> -=> check: 'create query'<br><br> +=> check: 'create query' -<dd>25. insert any further field, or delete one (delete field by marking 'field header' in lower grid and context or 'del' key)</dd><br> -<dd>26. save and close query design</dd><br> -<dd>27. reopen and verify the change you have made</dd><br><br> +<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> -=> check: 'modify query'<br><br> +=> check: 'modify query' -<dd>28. close query and delete it</dd><br><br> +<dd>28. close query and delete it</dd> -=> check: 'delete query'<br><br> +=> check: 'delete query'<br> -<dd>29. create a new 'view' (table container/create view - if supported)</dd><br> -<dd>30. repeat 21. to 28. (views should behave the same way like queries, but they are stored in the connected database insted in the oo db file, so the behavior can differ)</dd><br><br> +<dd>29. create a new 'view' (table container/create view - if supported)</dd> +<dd>30. repeat 21. to 28. (views should behave the same way like queries, but they are stored in the connected database insted in the oo db file, so the behavior can differ)</dd> -=> check: 'create view'<br> -=> check: 'modify view'<br> -=> check: 'delete view'<br><br> +=> check: 'create view' +=> check: 'modify view' +=> check: 'delete view' -<dd>31. open or create any table in design view</dd><br> -<dd>32. open the 'index' design dialog (in menue: tools/index design or with according icon)</dd><br> -<dd>-> index dialog appear</dd><br> -<dd>33. create a new index, save it and close dialog and table (with the according icons)</dd><br> -<dd>34. refresh tables and reopen test table (from menue: view/refresh tables)</dd><br> -<dd>35. reopen index dialog and recheck if index still present</dd><br><br> +<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>< -=> check: 'indexes'<br><br> +=> check: 'indexes' -<dd>36. close dialog and table design</dd><br> -<dd>37. create any other table (for further test we need min. two tables)</dd><br> -<dd>38. open a new query in design view</dd><br> -<dd>39. add two tables</dd><br> -<dd>-> two table container should appear</dd><br> -<dd>40. create a join between them (by drag&drop any field name from one table container to the other)</dd><br> -<dd>-> a 'connector' between the two table container appear</dd><br> -<dd>41. doubleclick on the connector</dd><br> -<dd>-> the 'join property' dialog appear</dd><br> -<dd>42. choose from 'type' listbox the any item f.e. 'inner join' (if supported)</dd><br> -<dd>43. push the 'ok' button</dd><br> -<dd>-> dialog disappear</dd><br> -<dd>44. insert any table field for query (by doubleclicking on any field in table container or with 'listbox'..)</dd><br> -<dd>45. run and save the query (for a senseful result you need sensfull data)</dd><br> -<dd>46. open the query in design view and doubleclick on the 'connector'</dd><br> -<dd>-> the 'join property' dialog appear</dd><br> -<dd>47. check the other proposed join 'types' if supported (43. to 46.)</dd><br><br> +<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> +<dd>39. add two tables</dd> +<dd>-> two table container should appear</dd> +<dd>40. create a join between them (by drag&drop any field name from one table container to the other)</dd> +<dd>-> a 'connector' between the two table container appear</dd> +<dd>41. doubleclick on the connector</dd> +<dd>-> the 'join property' dialog appear</dd> +<dd>42. choose from 'type' listbox the any item f.e. 'inner join' (if supported)</dd> +<dd>43. push the 'ok' button</dd> +<dd>-> dialog disappear</dd> +<dd>44. insert any table field for query (by doubleclicking on any field in table container or with 'listbox'..)</dd> +<dd>45. run and save the query (for a senseful result you need sensfull data)</dd> +<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> -=> check: 'join'<br><br> +=> check: 'join' -<dd>48. close dialog and query design</dd><br> -<dd>49. open the 'relation design' (menue: tools/relationships)</dd><br> -<dd>-> dialog appear</dd><br> -<dd>50. add two tables</dd><br> -<dd>-> table container appear</dd><br> -<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><br> -<dd>-> 'connector ' between the two table container appear (with doubleclick on it, dialog available)</dd><br> -<dd>52. save, refresh, reopen and recheck if everything fine</dd><br><br> +<dd>48. close dialog and query design</dd> +<dd>49. open the 'relation design' (menue: tools/relationships)</dd> +<dd>-> dialog appear</dd> +<dd>50. add two tables</dd> +<dd>-> table container appear</dd> +<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 fine</dd> -=> check: 'relations'<br><br> +=> check: 'relations' -<dd>53. create a new database with the same settings like your current (if supported)</dd><br> -<dd>54. view any table content</dd><br><br> +<dd>53. create a new database with the same settings like your current (if supported)</dd> +<dd>54. view any table content</dd> -=> check: 'multi user'<br><br><br> +=> check: 'multi user' -- finish test -<br><br><br> +- finish test - -please send the filled checklist with 'connection test' in title to <a href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>.<br><br> +please send the filled checklist with 'connection test' in title to <a href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>. -(please fill in comma seperated like example:<br> -create tables: +<br> -indexes: -<br> -and notice, that the order differ a bit)<br><br> +(please fill in comma seperated like example: +create tables: + +indexes: - +and notice, that the order differ a bit) -Database:<br> -Driver (vers. number):<br> -OS (Operating System f.e. WinXP or LinuxSuse10.1):<br> -oo Version:<br> -known bugs (optional):<br><br> +Database: +Driver (vers. number): +OS (Operating System f.e. WinXP or LinuxSuse10.1): +oo Version: +known bugs (optional): -primary key:<br> -create tables:<br> -delete tables:<br> -insert table fields:<br> -modify table fields:<br> -delete table fields:<br> -insert table data:<br> -modify table data:<br> -delete table data:<br> -insert table rows:<br> -delete table rows:<br> -create query:<br> -modify query:<br> -delete query:<br> -create view:<br> -modify view:<br> -delete view:<br> -indexes:<br> -joins:<br> -relations:<br> -multi user:<br> +primary key: +create tables: +delete tables: +insert table fields: +modify table fields: +delete table fields: +insert table data: +modify table data: +delete table data: +insert table rows: +delete table rows: +create query: +modify query: +delete query: +create view: +modify view: +delete view: +indexes: +joins: +relations: +multi user: </body> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
