Stored Procedures "Vayse" <vayse[ at ]deadspam.com> 17.07.2006 13:55:00 Hi Folks So what do you ADP guys use to write your Update, Append etc Queries? Is there a graphical tool like there is in normal access? Have a fairly complex Update to run, and I don't want to write it all in SQL. Thanks Diarmuid

Re: Stored Procedures "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 17.07.2006 19:54:36 There are no more a graphical tool to write complex SQL queries and SP that there is one to write complex VBA code. The graphical tool used in normal access can be used only with the most simple cases. Even something as usual and simple as an UNION cannot be created with it. -- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF "Vayse" <vayse[ at ]deadspam.com> wrote in message news:uyDIYiaqGHA.2180[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > Hi Folks > So what do you ADP guys use to write your Update, Append etc Queries? > Is there a graphical tool like there is in normal access? > Have a fairly complex Update to run, and I don't want to write it all in > SQL. > Thanks > Diarmuid >

Re: Stored Procedures "Vayse" <vayse[ at ]deadspam.com> 18.07.2006 08:02:41 A pity. Are there any graphical tools to write simpler queries? Just wondering is there some third party tool that was any use. "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> wrote in message news:%23K6HXrdqGHA.4912[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > There are no more a graphical tool to write complex SQL queries and SP > that there is one to write complex VBA code. > > The graphical tool used in normal access can be used only with the most > simple cases. Even something as usual and simple as an UNION cannot be > created with it. > > -- > Sylvain Lafontaine, ing. > MVP - Technologies Virtual-PC > E-mail: http://cerbermail.com/?QugbLEWINF > > > "Vayse" <vayse[ at ]deadspam.com> wrote in message > news:uyDIYiaqGHA.2180[ at ]TK2MSFTNGP05.phx.gbl... >> Hi Folks >> So what do you ADP guys use to write your Update, Append etc Queries? >> Is there a graphical tool like there is in normal access? >> Have a fairly complex Update to run, and I don't want to write it all in >> SQL. >> Thanks >> Diarmuid >> > >

Re: Stored Procedures "Vadim Rapp" <vrapp[ at ]nospam.polyscience.com> 20.07.2006 14:31:35 V> Are there any graphical tools to write simpler queries? Just wondering V> is there some third party tool that was any use. No. In fact, Access is probably the most capable of all. I use Enterprise Manager. Vadim Rapp

Re: Stored Procedures "Vadim Rapp" <vrapp[ at ]nospam.polyscience.com> 20.07.2006 14:33:18 SL> Even something as usual and simple as an UNION cannot be created with SL> it. Sylvain, I'm curious, how would you draw UNION query graphically? it's not an argument, just curious how it might look. Vadim

Re: Stored Procedures "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 20.07.2006 14:44:01 A slight misunderstanding here: I never said that the actual graphical tool should be improved but that usually any graphical tool will be more of an hindrance than to be useful as soon as you have to write anything but simple queries. As to the specific problem of drawing an Union query graphically, the actual SQL-Server query plans are quite capable of displaying them; so I don't see why this should be an impossible task to do. -- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF "Vadim Rapp" <vrapp[ at ]nospam.polyscience.com> wrote in message news:efPpqlArGHA.3820[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > SL> Even something as usual and simple as an UNION cannot be created with > SL> it. > > Sylvain, I'm curious, how would you draw UNION query graphically? it's not > an argument, just curious how it might look. > > Vadim

Re: Stored Procedures "Robert Morley" <rmorley[ at ]magma.ca.N0.Freak1n.sparn> 20.07.2006 18:07:56 I would see it as either multiple windows for each subquery, or possible something similar to a join line, only it would be a union line. Not the easiest thing to build into a graphical UI, but I'm sure it could be done with time. Rob "Vadim Rapp" <vrapp[ at ]nospam.polyscience.com> wrote in message news:efPpqlArGHA.3820[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > SL> Even something as usual and simple as an UNION cannot be created with > SL> it. > > Sylvain, I'm curious, how would you draw UNION query graphically? it's not > an argument, just curious how it might look. > > Vadim