![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
![]() |
Fri, Jan 4 2008 9:28 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | You suggested using a view in EDBManager to replicate the structure view in DBSys. I can write the SQL
![]() Roy Lambert |
Fri, Jan 4 2008 10:44 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 ![]() 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 ![]() | 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. ![]() | 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 Monday, July 7, 2025 at 06:35 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |