content/dba/specifications/Drag_Drop_DSBrowser.html

<!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>