In a PDF-Report-Application I changed the SQL-Statement. This has no effect to the Fields-List in the application creation. So I got an error when executing the application.
How can I change the Fields list in association to the SQL-Statement?
Best Regards
Hans-Joachim Herr
Re: Changes on SQL-Statement
As far as i remember, i think after adding the fields in sql statement you have to go to
Layout–> Interface and add cells there and choose/assign the added field to the new cell (select the field from the dropdown list which is at the right side).
Also remember to set x and y position so that it is in visible area of the pdf.
Hope it helps.
Re: Changes on SQL-Statement
Ok, this is helpful. But when I change the fields name in the database or delete one field in the database, this method will not work. The SQL-Parser inside the report-application will create the error that the desired field not exists.
Any ideas what to do?
Regards
Hans
Re: Changes on SQL-Statement
maybe it’s a workaround to use a database view as the basis of your report app?
When changing the underlying table, you just change the view definition and keep the column names of the view unchanged. That way you won’t have to change the app.
Re: Changes on SQL-Statement
This will be a workaround.
The really true way must be that altering a SQL-Statement must have an effect on all that depends on it.
Regards
Hans