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

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

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
>

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
>

Ralf


Learning curve - I'm still at the bottom of the slope

Roy Lambert

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