Synchronize table in pdfreport?

Scriptcase 9 General
#1

Hi All,
I need to re-synchronize table in pdfreport to add new field, how?

Please URGENT!
Thanks
Daniele

#2

Hi,
Adding the new field in the SQL statement does not solve it?

#3

Hi,
If I create new field (e.g. ‘tab_clienti.nomebanca_cli’) when I execute system print out error:

Parse error: syntax error, unexpected ‘=’ in C:\Program Files\NetMake\v9-php73\wwwroot\scriptcase\app\www_iss_zone\pdfreport_sito_schedacliente_a\pdfreport_sito_schedacliente_a_grid.class.php on line 1179

#4

And how did you add it? Can you show us?

#5

Simply create a new field in fields but doesn’t work in this way obviously…

My sql is:
Select * from tab_clienti
Left join…

If I close pdf report and reopen sql come execute again but not include new fields in the section fields

#6

Ok, but if your table has already the field, the place to declare it is in SQL statement of your report, like this:

SELECT
   first,
  second,
  third        // new one
FROM your_table
LEFT JOIN .....
.....

Because when you create a new field in fields you are creating a temporary field directly and it has no relation to your table.

1 Like
#7

Since you specify * as field list, you have to force SC to run again the sql to read the field list, so edit your sql, add a space, then delete it if you want :smiley: , and then save, SC think you changed the sql and run it again to get the field list, I suggest you however to make a copy of the app before to make this operation.

ciao

#8

Agreed. But the best way to put an SQL statement in any app (grids, reports) is to declare each field from the table(s), in order to avoid loading unnecessary fields and data.