[Phpmyadmin-devel] foreign key on external database

[Marc Delisle]

Hi Isart,

what I've done is not in phpMyAdmin, it's for a project at my job. Let 
me verify how I could help you.

Marc

Isart Montane a écrit :
> Thanks marc, where can I get this code? I've run a few grep on the code 
> and couldn't find it
> 
> On Mon, Jun 15, 2009 at 11:38 AM, Marc Delisle <marc at infomarc.info 
> <mailto:marc at infomarc.info>> wrote:
> 
>     Hi Isart,
>     I've done something similar with Ajax. Also you should display a submit
>     button to trigger the update of the tables dropdown when javascript is
>     disabled in the browser.
> 
>     Marc
> 
>     Isart Montane a écrit :
>      > Hi guys,
>      >
>      > If I add a new dropdown with the databases, the table dropdown
>     should be
>      > updated when the database dropdown changes. Any suggestion on how
>     to do it?
>      >
>      >    1. Add the table dropdown on an iframe and reload it when the
>      >       database dropdown changes (javascrpt)
>      >    2. Ajax
>      >    3. Others?
>      >
>      > Thx!
>      > Isart
>      >
>      > On Sat, Jun 13, 2009 at 9:11 PM, Isart Montane
>     <isart.montane at gmail.com <mailto:isart.montane at gmail.com>
>      > <mailto:isart.montane at gmail.com
>     <mailto:isart.montane at gmail.com>>> wrote:
>      >
>      >     My idea is to add it as a dropdown in the relational view. I will
>      >     take a look at the designer page as well and see if I can do
>     both.
>      >
>      >
>      >     On Fri, Jun 12, 2009 at 12:04 PM, Marc Delisle
>     <marc at infomarc.info <mailto:marc at infomarc.info>
>      >     <mailto:marc at infomarc.info <mailto:marc at infomarc.info>>> wrote:
>      >
>      >         Isart Montane a écrit :
>      >          > Hi all,
>      >          >
>      >          > For a personal project I need to create foreign keys
>     between
>      >         different
>      >          > databases. I've realised that phpmyadmin only allows
>     foreign
>      >         keys on the
>      >          > same db so I'm thinking on develop this feature.
>      >          >
>      >          > I know it's not a very good practice to create foreign
>     keys
>      >         on different
>      >          > databases... but I need it anyway...
>      >          >
>      >          > Any comments or guidelines to do it?
>      >          >
>      >          > Thanks,
>      >          > Isart
>      >          >
>      >
>      >         Hi Isart,
>      >         good initiative! Are you thinking of implementing this in
>      >         Relation View
>      >         or the Designer page or both?
>      >
>      >         On Relation View, we could think of a database drop-down,
>     even
>      >         if this
>      >         can pose a problem with too many databases -- but we already
>      >         have this
>      >         problem at other places where we have such drop-down.
>      >
>      >         --
>      >         Marc Delisle
>      >         http://infomarc.info
>      >
>      >        
>     ------------------------------------------------------------------------------
>      >         Crystal Reports - New Free Runtime and 30 Day Trial
>      >         Check out the new simplified licensing option that
>     enables unlimited
>      >         royalty-free distribution of the report engine for
>     externally facing
>      >         server and web deployment.
>      >         http://p.sf.net/sfu/businessobjects
>      >         _______________________________________________
>      >         Phpmyadmin-devel mailing list
>      >         Phpmyadmin-devel at lists.sourceforge.net
>     <mailto:Phpmyadmin-devel at lists.sourceforge.net>
>      >         <mailto:Phpmyadmin-devel at lists.sourceforge.net
>     <mailto:Phpmyadmin-devel at lists.sourceforge.net>>
>      >         https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>      >
>      >
>      >
>      >
>      >
>     ------------------------------------------------------------------------
>      >
>      >
>     ------------------------------------------------------------------------------
>      > Crystal Reports - New Free Runtime and 30 Day Trial
>      > Check out the new simplified licensing option that enables unlimited
>      > royalty-free distribution of the report engine for externally facing
>      > server and web deployment.
>      > http://p.sf.net/sfu/businessobjects
>      >
>      >
>      >
>     ------------------------------------------------------------------------
>      >
>      > _______________________________________________
>      > Phpmyadmin-devel mailing list
>      > Phpmyadmin-devel at lists.sourceforge.net
>     <mailto:Phpmyadmin-devel at lists.sourceforge.net>
>      > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> 
> 
>     --
>     Marc Delisle
>     http://infomarc.info
> 
>     ------------------------------------------------------------------------------
>     Crystal Reports - New Free Runtime and 30 Day Trial
>     Check out the new simplified licensing option that enables unlimited
>     royalty-free distribution of the report engine for externally facing
>     server and web deployment.
>     http://p.sf.net/sfu/businessobjects
>     _______________________________________________
>     Phpmyadmin-devel mailing list
>     Phpmyadmin-devel at lists.sourceforge.net
>     <mailto:Phpmyadmin-devel at lists.sourceforge.net>
>     https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> 
> 
> 
> ------------------------------------------------------------------------
> 
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing 
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel


-- 
Marc Delisle
http://infomarc.info