Form with Update procedure doesn't save data after upgrade from SC 9.3.006 to 008

Scriptcase 9 General
#1

Hello everybody,

I have a working app with a form that uses an update procedure. Up to SC 9.3.006 it works ok. After updating to SC 9.3.008 it doesn’t save the data, the stored procedure is never called.

I’m using SC 9.3.008, Windows 10 Pro (Spanish) x64, MySQL 5.7.25 x64 and PHP 7.0.15. There were absolutely NO changes to the form.

I checked the MySQL log file and confirms that the CALL for the procedure is never executed. I “echoed” the SQL sentence modifiyng the PHP file and the sentence is correct (it executes ok if I use MySql Workbench).

I checked the current application generated file versus the previously deployed app, and found a problem (It’s the file named “myformname_apl.php”).

In the working version, Scriptcase generates code to test for field changes with this line:

if ($SC_ex_update || $SC_tem_cmp_update)

But in the new version it changes to test using an array:

if (!empty($SC_fields_update))

But nowhere in the code is this array used or assigned. Other forms, not using UPDATE procedure, however, does have assignments to this array.

I already checked using a new, empty form using a test table with only three integer fields: the generated code never touches the $SC_fields_update array, beside creating it.

I think I confirmed this is a new BUG introduced in 007 or 008.

#2

UPDATE

I confirmed the problem is still present at SC 9.3.009, with a test project with a single form, and a single test table with only 3 fields. You could insert new records, but you cannot modify existing records if you choose to use an “Update procedure” for the table.

Is there no one using Update Procedures for MySql out there? Nobody else is experiencing this error?

#3

UPDATE: Scriptcase Bug Tracker Team confirmed this is a bug. I’m waiting for them to fix it.