| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> |
| <HTML> |
| <head> |
| <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252"> |
| <TITLE>Drag and Drop in the Datasource Browser</TITLE> |
| <META NAME="GENERATOR" CONTENT="StarOffice 6.0 (Win32)"> |
| <META NAME="AUTHOR" CONTENT="Ocke Janssen"> |
| <META NAME="CREATED" CONTENT="20020408;15591366"> |
| <META NAME="CHANGEDBY" CONTENT="Ocke Janssen"> |
| <META NAME="CHANGED" CONTENT="20020408;16013755"> |
| <STYLE> |
| <!-- |
| TH P { margin-bottom: 0.21cm; font-style: italic } |
| --> |
| </STYLE> |
| </head> |
| <body LANG="de-DE"> |
| <H1>Drag and Drop in the Datasource Browser |
| </H1> |
| <P>This document shows what should be possible to drag and what |
| should be happen when droped inside the datasource browser. |
| </P> |
| <TABLE WIDTH=100% BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0> |
| <COL WIDTH=85*> |
| <COL WIDTH=85*> |
| <COL WIDTH=85*> |
| <THEAD> |
| <TR VALIGN=TOP> |
| <TH WIDTH=33%> |
| <P>Source</P> |
| </TH> |
| <TH WIDTH=33%> |
| <P>Destination</P> |
| </TH> |
| <TH WIDTH=33%> |
| <P>Effect</P> |
| </TH> |
| </TR> |
| </THEAD> |
| <TBODY> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P>Table object</P> |
| </TD> |
| <TD WIDTH=33%> |
| <P>Table container</P> |
| </TD> |
| <TD WIDTH=33%> |
| <P>Opens Wizard, whole table and data will be copied. See 1</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P>Query object</P> |
| </TD> |
| <TD WIDTH=33%> |
| <P>Table container</P> |
| </TD> |
| <TD WIDTH=33%> |
| <P>Opens Wizard, whole query (as table or as view) and data will |
| be copied. See 2</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P>Qurey object</P> |
| </TD> |
| <TD WIDTH=33%> |
| <P>Query container</P> |
| </TD> |
| <TD WIDTH=33%> |
| <P>Copies the query object</P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=33%> |
| <P>Grid-control</P> |
| </TD> |
| <TD WIDTH=33%> |
| <P>Table container</P> |
| </TD> |
| <TD WIDTH=33%> |
| <P>Opens Wizard, only selection will be copied. See 3</P> |
| </TD> |
| </TR> |
| </TBODY> |
| </TABLE> |
| <P STYLE="margin-top: 0.42cm; margin-bottom: 0.21cm; page-break-after: avoid"> |
| <FONT FACE="Albany, sans-serif"><FONT SIZE=4>1 The table object as |
| drag source</FONT></FONT></P> |
| <P>Inside the datasorce browser, the table object can only be copied |
| onto the table container. When copied all properties must also be |
| copied. That means that the following properties have to look for if |
| they are copied too.</P> |
| <UL> |
| <LI><P>Columns</P> |
| <LI><P>Keys</P> |
| <LI><P>Indexes</P> |
| <LI><P>table settings, like color, filter and filter applied, |
| sorting |
| </P> |
| <LI><P>column settings, like number format</P> |
| <LI><P>and the data</P> |
| </UL> |
| <P>Outside the datasource browser, the table should be exported in |
| HTML and RTF format. Additionally the writer should support extra |
| functionality.</P> |
| <P STYLE="margin-top: 0.42cm; margin-bottom: 0.21cm; page-break-after: avoid"> |
| <FONT FACE="Albany, sans-serif"><FONT SIZE=4>2 The query object as |
| drag source</FONT></FONT></P> |
| <P>The query object can be copied onto the query container. It should |
| be a 1:1 copy. All properties have to be copied, the same as for the |
| table object. When copied onto the table container, the user could |
| choise between a table object to be created or an view object when |
| the database supports it.</P> |
| <UL> |
| <LI><P>the SQL statement</P> |
| <LI><P>the column settings as by a table</P> |
| <LI><P>the query settings, like color</P> |
| </UL> |
| <P STYLE="margin-top: 0.42cm; margin-bottom: 0.21cm; page-break-after: avoid"> |
| <FONT FACE="Albany, sans-serif"><FONT SIZE=4>4 The grid-control as |
| drag source</FONT></FONT></P> |
| <P>The grid control shows the current selection of the tree view. |
| This view can be sorted and filtered. At this reason it is possible |
| that the source contains a filter which has to be include when coping |
| data. Additionally it is possible to do a multiselection on the rows. |
| When this selection is copied on the table container, only the |
| selected rows have to be copied and not the whole rows. Another point |
| to mention is that the rows must also be dragable to other |
| applications like the writer, this is also valid for the column |
| header. |
| </P> |
| <P><BR><BR> |
| </P> |
| </body> |
| </HTML> |
