I have a problem on how to create and save multiple PDF,S using Scriptcase ver 9.
I created a normal PDF file
Did the placings of the fields
I have a database table with 4 records in them. [TABLE=“border: 0, cellpadding: 0, width: 680”]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]TEST0001[/TD]
[TD]Account no1[/TD]
[TD]email1@gmail.com[/TD]
[TD]1000[/TD]
[TD]POBOX 12345[/TD]
[TD]Somewhere[/TD]
[TD]South Africa[/TD]
[TD]2100[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]TEST0002[/TD]
[TD]Account no2[/TD]
[TD]email2@gmail.com[/TD]
[TD]300[/TD]
[TD]POBOB 123[/TD]
[TD]Nowere[/TD]
[TD]South Africa[/TD]
[TD]2101[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3[/TD]
[TD]TEST0003[/TD]
[TD]Account no3[/TD]
[TD]email3@gmail.com[/TD]
[TD]1200[/TD]
[TD]POBOX 1234512[/TD]
[TD]Elswere[/TD]
[TD]South Africa[/TD]
[TD]2102[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]9[/TD]
[TD]TEST0004[/TD]
[TD]Account no4[/TD]
[TD]email4@gmail.com[/TD]
[TD]600[/TD]
[TD]POBOX12321[/TD]
[TD]Everywere[/TD]
[TD]South Africa[/TD]
[TD]2103[/TD]
[/TR]
[/TABLE]
When I run this Pdf, It creates all 4 the records into one PDF file. I can view all 4 of them. Each on their own page
1 1 TEST0001 Account no1 email1@gmail.com 1000 POBOX 12345 Somewhere South Africa 2100
2 2 TEST0002 Account no2 email2@gmail.com 300 POBOB 123 Nowere South Africa 2101
3 3 TEST0003 Account no3 email3@gmail.com 1200 POBOX 1234512 Elswere South Africa 2102
4 9 TEST0004 Account no4 email4@gmail.com 600 POBOX12321 Everywere South Africa 2103
This is the code in the Layout PDF window
/------------------ Page 1 -----------------/
sc_pdf_print($cell_id);
sc_pdf_print($cell_client_id);
sc_pdf_print($cell_2018_tax_number);
sc_pdf_print($cell_new_account_name);
sc_pdf_print($cell_new_email);
sc_pdf_print($cell_2018_total_contribution);
sc_pdf_print($cell_address_1);
sc_pdf_print($cell_address_2);
sc_pdf_print($cell_address_3);
sc_pdf_print($cell_postal_code);
/-------------------------------------------/
When I add the following to help me save the files, it does save all 4 records - but only the first record has any data in it
/------------------ Page 1 -----------------/
sc_pdf_print($cell_id);
sc_pdf_print($cell_client_id);
sc_pdf_print($cell_2018_tax_number);
sc_pdf_print($cell_new_account_name);
sc_pdf_print($cell_new_email);
sc_pdf_print($cell_2018_total_contribution);
sc_pdf_print($cell_address_1);
sc_pdf_print($cell_address_2);
sc_pdf_print($cell_address_3);
sc_pdf_print($cell_postal_code);
/-------------------------------------------/
$name = {new_account_name};
$name1 = {2018_tax_number};
$new_email = {new_email};