ScriptCase v8.0.030 (02-05-2015 14:24)

Scriptcase 8 Changelog
#1

Specific correction

  • Fixed problem in percentage fields display with negative values in the grid application.
  • Fixed problem when inserting multiple values for a double select fields in editable grid forms (view).
  • Fixed problem in the fields type when importing Excel spreadsheets for database conversion.
  • Fixed problem in select type of fields with multiple values in the filter.

Bug

  • Fixed problem in the date field visualization to change the language via the toolbar in the grid application.
  • Fixed problem in the amount of characters for the user’s e-mail in the ScriptCase administrative settings.
  • Fixed problem in the vertical alignment of the menu items with images.
  • Fixed problem in the behavior of disabled fields to score check box fields set to reload after changing the value.
  • Fixed problem when changing amount of bars in the standard HTML editor values in the project.
  • Fixed problem when generating a Grid application initiating as CSV.
  • Fixed auto complete problem in fields for capturing the filter.
  • Fixed problem when clicking on Google Maps fields configured as URL.
#2

Hi John,
can NetMake please review this bug?: search is ‘unstable’

As stated in my post, you can reproduce it on your own online demo:
http://www.scriptcase.net/scriptcase-samples/php-reports-charts/quick-search/

Just quicksearch for a string with a quote in it, e.g. D’ORO , and you’ll get the error.

SC is not properly escaping the single quote character.
(if you search for D’'ORO , i.e. two single quotes, there’s no error at all because you are basically escaping the second single quote with the first one).

For details of when this error occours please review my post: search is ‘unstable’

#3

[QUOTE=robydago;32239]Hi John,
can NetMake please review this bug?: search is ‘unstable’

As stated in my post, you can reproduce it on your own online demo:
http://www.scriptcase.net/scriptcase-samples/php-reports-charts/quick-search/

Just quicksearch for a string with a quote in it, e.g. D’ORO , and you’ll get the error.

SC is not properly escaping the single quote character.
(if you search for D’'ORO , i.e. two single quotes, there’s no error at all because you are basically escaping the second single quote with the first one).

For details of when this error occours please review my post: search is ‘unstable’[/QUOTE]

This is critical!! Good catch roby, wish NetMake fix this ASAP, it is a “must as first” John, seems easy to fix, I don’t think it needs rocket theory as it is really showing the weakness of sc

#4

Hello,

We are working to resolve this problem.
We apologize for any inconvenience.

#5

Global variables doesn’t work since last update of Scriptcase!!

#6

Hello,

Would you can explain me more about this problem?
If possible, send me some screenshots.

#7

[QUOTE=John L. Santos;32340]Hello,

We are working to resolve this problem.
We apologize for any inconvenience.[/QUOTE]

John, thanks.

Keep in mind that single character breaks not only quicksearch.
It happens in other scenarios as well.
I just tried an update of a field in a form that didn’t have an apostrophe in the old value and I didn’t use one in the new value, but since an existing field in the record contained an apostrophe, I got this error in SC.

Error updating database -
ERROR: syntax error at or near "Adda" LINE 1: ...

and the ‘view sql’ link shows this:

UPDATE "public".site SET id_city = 5,  address = [B]'Via D'Adda, 2'[/B], phone_number = '02.0212121252', id_site_type = 1 WHERE id_site = 12

Showing that the single quote in the address field is not escaped.

In the form I updated only the phone_number field.
The original data in the database was not entered via SC forms, but the SC form has not issues showing the filed content correctly as

Via D’Adda, 2

Please try to fix it as unfortunately apostrophes are used in Italian names.