Printing a browse form when using temporary tables

[Fike]

I have a browse form which table content is retreived from diferent tables using the 'Before browse' php section, creating a temporary table wiht the hash variable #TABLE_ID#

Therefore the SQL of the browse form is: SELECT * FROM #TABLE_ID#

This works fine when displaying the browse form. However, when pressing the 'Print' button, the new window only displays the headers of the table.

I checked the vale of 'last.browse_sql' in the nuPrintAction() function, and it is somthing like: SELECT title_01, title_02 FROM ___nu15a87637ede74e___ WHERE 1

This query throws an error becuase the tempory table created 'Before browsing' no longer exists.

Is there any workaround for this?

Kind regrads


Fike

[admin]

Fike,

At the moment, that is a bug.

A workaround, in the meantime, would be creating a VIEW instead of creating the temp table.

And using that as a TABLE.

Steven

[Fike]

The view worked great!

Thank's a lot Steven!

[admin]

.

[Timo]

Fike,

At the moment, that is a bug.

A workaround, in the meantime, would be creating a VIEW instead of creating the temp table.

And using that as a TABLE.

Steven

When can we expect a fix? Using a VIEW is no option for me. (need to dynamically create the sql statement). Thank you.

[admin]

Timo,

The Print Button should now work using #TABLE_ID#


Steven

[Timo]

Thanks! I'll try it out as soon as I have a chance.

[admin]

.

[Timo]

It works like a charm

[admin]

.