Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
VIEW in EDBManager |
Fri, Jan 4 2008 9:28 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | You suggested using a view in EDBManager to replicate the structure view in DBSys. I can write the SQL but I don't know where/how to do it. Help me out please.
Roy Lambert |
Fri, Jan 4 2008 10:44 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Don't worry - I finally pried my eyes open enough to find the right place
Now I've found it I'm with Harry about parameters. Think how much more useful select tablename,name,type,"length",scale from information.tablecolumns where tablename = 'eln' order by tablename would be if I could put in a parameter for the tablename Roy Lambert |
Fri, Jan 4 2008 11:40 AM | Permanent Link |
"Harry de Boer" | Roy
Thanks for backing me up However I can see that's it's a major request. A view is handled like a table (TEDBtable) and parameters there seems to be dififficult if not impossible. Maybe a TEDBQuery could have an etra property with [edbQuery,edbView] values or a component TEDBView could make it's entrance, or... You know what? Why don't we leave it all to Tim Regards, Harry "Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht news:ED1D7EB2-385D-4887-BEDD-9C67AEC16ED3@news.elevatesoft.com... > Don't worry - I finally pried my eyes open enough to find the right place > > > Now I've found it I'm with Harry about parameters. Think how much more useful > > select tablename,name,type,"length",scale > from information.tablecolumns > where tablename = 'eln' > order by tablename > > would be if I could put in a parameter for the tablename > > Roy Lambert > |
Sun, Jan 6 2008 8:25 PM | Permanent Link |
Ralf Graap | Hey Roy,
just my 2 cent... Why not using a procedure: ALTER PROCEDURE "TableColumns" (IN "Tablename" VARCHAR(50) COLLATE ANSI_CI) BEGIN DECLARE Result CURSOR WITH RETURN FOR Stmt; PREPARE Stmt FROM 'SELECT * from information.tablecolumns tc where Tablename = ?'; OPEN Result using Tablename; END Ralf Roy Lambert schrieb: > Don't worry - I finally pried my eyes open enough to find the right place > > > Now I've found it I'm with Harry about parameters. Think how much more useful > > select tablename,name,type,"length",scale > from information.tablecolumns > where tablename = 'eln' > order by tablename > > would be if I could put in a parameter for the tablename > > Roy Lambert > |
Mon, Jan 7 2008 2:34 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ralf
Learning curve - I'm still at the bottom of the slope Roy Lambert |
Mon, Jan 7 2008 7:26 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ralf,
<< just my 2 cent... Why not using a procedure: >> Very good point, thanks for pointing that out. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |