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&#174; 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