ScriptCase v8.1.035 (2016-04-13 14:48)

Scriptcase 8 Changelog
#1

New functionalities

  • Added support to modify the dataset of the macros sc_lookup and sc_select, by index or by name through the sc_set_fetch mode macro.
    For more detail visit scriptcase manual.
  • Added sc_master_value macro support in event onAfterInsert, running from a grid.
  • Added support for languages in time fields using DatePicker. JQuery plug-in to set the time.

Specific correction

  • Fixed problem viewing date field with no values in export of XLS.
  • Fixed problem when creating the SQL using JOIN in PostgreSQL and SQL Server database connections.
  • Fixed problem in the SQL query’s execution, when there is an ORDER BY clause.
  • Fixed problem with Master/Detail when it opens in modal forms via application link from a Grid application.
  • Fixed problem with download link in the fields document (file name), document (database), image (file name) or image (database) in Editable Grid forms View.
  • Fixed problem accessing LDAP security module in full control mode.
  • Fixed problem in field preview of the HTML Editor configured as Read-Only on mobile devices.
  • Fixed problem when deploying using the ZIP mode. Where was generating more applications than have been selected.

Bug

  • Fixed problem updating the fields totaled by using the sc ajax refresh macro on Grid applications.
  • Fixed problem viewing values of the Checkbox fields, in Editable Grid View Forms.
  • Fixed problem when performing a search that does not return records on Quick Search in forms applications.
  • Fixed problem in URL option safety output in blank applications.
  • Fixed problem retrieving the value of the lookup, when the field was configured as read-only.
  • Fixed problem when setting values of global variables in Ajax events and use them in the selection fields lookup.
#2
  • Added support to modify the dataset of the macros sc_lookup and sc_select, by index or by name through the sc_set_fetch mode macro.

Datasets, or arrays. In doc talks about datasets, and param sais returns an array. Can you clarify this in docs? Is for use on sc_lookup (array), on sc_select (ADORecordset) or both?

#3

Ok, I answer. Is just for datasets. This means changelog is wrong. This macro doesn’t makes sense using with sc_lookup because it returns an array, not a ADODBRecotset. Said that, documentation should be changed IMHO to something similar to this (without time to check the text, maybe is wrong but you get the point):

Before



This macro allows to change the type of return from the dataset of the select commands. 
The macro will processed before running the SQL command. Informing the parameter, the dataset will return the index or the name of the column.

parm = 0 : Returns an array with the index and the name of columns (Scriptcase's Default) 
parm = 1 : Returns an array only with indexes of the columns

After…


This macro allows to change the type of return from the dataset of the select commands [B](sc_select)[/B]. 
The macro [B]must be [/B]processed before running the SQL command. Depending of parameter, fields can be accessed using position index or the name of the column.

parm = 0 : Returns an array with the index and the name of columns (Scriptcase's Default) 
parm = 1 : Returns an array only with indexes of the columns
#4

I will check it now for you.

Thank you, Giu!