hi,
I have improved the previous design check the image:
http://dl.dropbox.com/u/1008346/schema.jpg
examples: For the example in image we will select name checkbox. 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. after all this we will select the AND rule by writing (1 and 2).and then submit .
Problems
The Sub-query option provided with where and having,here user has to type in the sub query no visual building options.
please discuss this design and share your thoughts and suggestion . we can discuss by taking any other query of your choice.
Thanks, Ankit On Thu, Apr 1, 2010 at 6:36 PM, ANKIT GUPTA ankitatbits@gmail.com wrote:
Hello marc,
yes you are right,that there is no need to explicitly ask the user to "select relation arrows", but i want to provide users with an option to select the Join type(inner,outer,left,right).
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.
Thanks Ankit
2010/4/1 Marc Delisle marc@infomarc.info
ANKIT GUPTA a écrit :
Hi,
because of the size limit , i am resending the my previous mail but this time in place of attaching the image i am providing a URL
URL for image: http://dl.dropbox.com/u/1008346/mock_schema.jpg
PFA with this mail as marc Suggested that we should discuss the design with the help of an example, so i have made a mock schema with three tables artist,song and
sings.details
u can see in the diagram with this mail.
i know The Design which i have developed till now is just the beginning draft , lot of discussion and thought has to be put to finalize the
design
with functionality.
Hi Ankit,
I had a look at your image. I'm not sure what you mean by "select the relations arrows which we need for the query". I think that in a query builder, the user should be able to specify what he needs just in terms of tables and columns, and the product should build the correct joins.
-- Marc Delisle http://infomarc.info
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel