topic Re: How to collect all data tables in a new window in Discussions

How to collect all data tables in a new window

hans — Fri, 14 Aug 2015 09:17:47 GMT

I have a script that extracts data from a database and returns a randum number of tables. I'd like to have all tables gathered in one window where a user can scroll down to see tables instead of having the tables behind each other. I have tried an approach where i make the calls to the database and afterwards make a new window and loop through all tabels and append them to the window (see below) but that does not work. Maybe the approach is all wrong and I have to start by creating the window and then add the tables when they are returned for the database or...?

thanks in advance :)

Hans Jørgen

= New Window( "EDC lag time reports for "|| Ttrial || "", show menu(0), show toolbars(0))

;

for

( i = 1, i<= N Table(), i

++,

<< Append( Data Table(i) )

;

)

;

Re: How to collect all data tables in a new window

ms — Fri, 14 Aug 2015 11:46:31 GMT

Append requires a "display box" and does not recognize a Data Table as such. Try the dt << New Data Box() command to capture a table within a display box. Or if the goal is merely to browse the tables, a plain journal could work.

Examples:

nw1 = New Window("vertical tables");

nw2 = New Window("horizontal tables", hlb = H List Box());

For(i = 1, i <= N Table(), i++,

nw1 << Append(Data Table(i) << new data box); //Active tables on top of eachother

hlb << Append(Data Table(i) << new data box); //Active tables side by side

Data Table(i) << journal; // Journal; tables inactive, for browsing data only

);

Re: How to collect all data tables in a new window

hans — Fri, 14 Aug 2015 12:00:15 GMT

YES - that made the difference. Thanks