hi,<br><br>I have improved the previous design check the image:<br><br><a href="http://dl.dropbox.com/u/1008346/schema.jpg">http://dl.dropbox.com/u/1008346/schema.jpg</a><br><br>examples:<br>For the example in image we will select name checkbox.<br>
and then select S_LANG in song table there we will go to the option and click on the where button a small where window will come here we will use the drop down menu to select = and in the textbox we will write English,and press Ok one entry will be added to the history table,repeat the process to for HINDI.<br>
after all this we will select the AND rule by writing (1 and 2).and then submit .<br><br>Problems <br><br>The Sub-query option provided with where and having,here user has to type in the sub query no visual building options.<br>
<br>please discuss this design and share your thoughts and suggestion .<br>we can discuss by taking any other query of your choice.<br><br><br>Thanks,<br>Ankit<br><div class="gmail_quote">On Thu, Apr 1, 2010 at 6:36 PM, ANKIT GUPTA <span dir="ltr"><<a href="mailto:ankitatbits@gmail.com">ankitatbits@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hello marc,<br><br>yes you are right,that there is no need to explicitly ask the user to "select relation arrows", <br>
but i want to provide users with an option to select the Join type(inner,outer,left,right).<br>
<br>i have not mentioned any details for writing Nested Sub queries.till now i don't have a good design to implement them......and am still working on it.<br><br>Thanks<br>Ankit<br><br><div class="gmail_quote">2010/4/1 Marc Delisle <span dir="ltr"><<a href="mailto:marc@infomarc.info" target="_blank">marc@infomarc.info</a>></span><div>
<div></div><div class="h5"><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">ANKIT GUPTA a écrit :<br>
<div>> Hi,<br>
><br>
> because of the size limit , i am resending the my previous mail but this<br>
> time in place of attaching the image i am providing a URL<br>
><br>
> URL for image:<br>
> <a href="http://dl.dropbox.com/u/1008346/mock_schema.jpg" target="_blank">http://dl.dropbox.com/u/1008346/mock_schema.jpg</a><br>
><br>
> PFA with this mail<br>
> as marc Suggested that we should discuss the design with the help of an<br>
> example,<br>
> so i have made a mock schema with three tables artist,song and sings.details<br>
> u can see in the diagram with this mail.<br>
><br>
> i know The Design which i have developed till now is just the beginning<br>
> draft , lot of discussion and thought has to be put to finalize the design<br>
> with functionality.<br>
<br>
</div>Hi Ankit,<br>
<br>
I had a look at your image. I'm not sure what you mean by "select the<br>
relations arrows which we need for the query". I think that in a query<br>
builder, the user should be able to specify what he needs just in terms<br>
of tables and columns, and the product should build the correct joins.<br>
<font color="#888888"><br>
--<br>
</font><div>Marc Delisle<br>
<a href="http://infomarc.info" target="_blank">http://infomarc.info</a><br>
<br>
------------------------------------------------------------------------------<br>
</div><div><div></div><div>Download Intel® Parallel Studio Eval<br>
Try the new software tools for yourself. Speed compiling, find bugs<br>
proactively, and fine-tune applications for parallel performance.<br>
See why Intel Parallel Studio got high marks during beta.<br>
<a href="http://p.sf.net/sfu/intel-sw-dev" target="_blank">http://p.sf.net/sfu/intel-sw-dev</a><br>
_______________________________________________<br>
Phpmyadmin-devel mailing list<br>
<a href="mailto:Phpmyadmin-devel@lists.sourceforge.net" target="_blank">Phpmyadmin-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel</a><br>
</div></div></blockquote></div></div></div><br>
</blockquote></div><br>