Scriptcase Applications
Change the charset to view the records.
When an error appears in the charset of the special characters as in the image below: This happens when the database charset and the script case charset are not the same but we can no longer edit it in the database. We use the following code in the ...
Example animation inside scriptcase
This is an example of how to place animation on the form sheet, 1 - We go to the page of https://github.com/animate-css/animate.css to download the .zip of the animations. 2 - Downloading the .zip we proceed to load the downloaded file as an external ...
Hide new grid button at runtime
To hide the grid buttons we will use the sc_btn_display() macro, this macro shows and hides the buttons in the toolbar at run time. 1- We use this macro in the OnScriptInit event of our grid, referring to our new button as “new”: 2- We run the ...
Add a record to another table from a condition
1- We create a form where we will perform the validation. 2- In the OnValidate event of our form we introduce the code with this scheme if (condition == condition) { insert the data to the other table; } else { echo "no records added"; } 3- this will ...
Using a TAB application with several applications and with a single parameter
This example will show how you can pass parameters from a Grid to another TAB application so that it can be used to execute SQL queries in different applications contained in the TAB. 1. Two applications of the Grid type must be created, both must ...
PHPSpreadSheet library with Scriptcase
1- We download the external library PHPSpreadSheet without composer https://php-download.com/downloads/phpoffice/phpspreadsheet/1.8.2.0/phpoffice_phpspreadsheet_1.8.2.0_require.zip 2- Then we proceed to load the external library in the scriptcase: ...
Notifications in Scriptcase
1- We proceed to download the external push notification library https://codeload.github.com/Nickersoft/push.js/zip/master 2- We load the external library in our scriptcase, we can follow this tutorial if necessary: ...
How to switch between themes dynamically through the Menu app
In Scriptcase, it's possible to dynamically switch between themes by activating a Menu option, to enable that option, simply follow the steps below: Note The chosen project must have more than one theme selected, otherwise it will not be possible to ...
How to create an application link
Application Link: This is used to link the application with any other type of project application. This type of link is associated with insert and update events. How to do an application link: Open your application and go to the “Application Links” ...
How to create a field link
Field Link: Used to create a navigation link in a grid column for any existing project application. When you select this type of link, all grid fields will be displayed in a select so that you can select the one to place the link on. The application ...
How to create a capture link
Capture Link: Used for the grid filter form, it imports data from another grid into the filter form field. Selecting the capture link type will display a list of fields in the filter form so that you select the field that will receive the data ...
How to create an edit link
Edit Link: Used to edit grid records through a Form. In the generated grid a link will be displayed on each row for editing the record. By clicking on the link, the form of the selected record can be displayed in various ways (in an iframe, in a ...
How to create a button link
Button Link: Used to link the application with any other type of project application. In this type of link a button is used as a link between applications. How to do a button link Make a link button in your application. Set the button as a link ...
Converting Projects to Scriptcase 9
Scriptcase allows you to port your projects through project chat easily. Thus, projects developed on any older version of the tool can benefit from all the new features available in version 9. Check out what's new in version 9.4 on our landing page. ...
Using two search applications to access a form
In this example we are going to create 2 applications of the "Search" type, and 1 application of the "Form" type. In the Search type applications, we will use the "customers" and "orders" tables, however, we will select only a few fields from each ...
CEP Type Field
This feature is only available for Brazilian scriptcase installations
Adding new columns in the table for Calendar
If your calendar application is already created, we must add the fields below in the table so that the new functionalities work correctly: category int id_api varchar(255) id_event_google varchar(255) recur_info varchar(255) event_color varchar(255) ...
Popular Articles
Fatal error: Array and string offset access syntax with curly braces is no longer supported
You can come across this error when running a login application created by a security module generated before Scriptcase 9.8. This error occurs only in an environment with PHP 8 or superior because of a change in the array elements access, that now ...
Necessary libraries to install the Scriptcase in Windows 7
To install Windows 7 SP1, you need to verify that the system has the following items installed: * Visual C ++ Redistributable Packages for Visual Studio (2008) x86 and x64. * Visual C ++ Redistributable Packages for Visual Studio (2010) x86 and x64. ...
Setting password recovery in Scriptcase
To configure the password recovery, it's necessary to do some steps so that works correctly. To the recovery happens, will be necessary that you have and configure a SMTP server. After login, you'll access the menu Options > Settings > System ...
Using friendly URL
The friendly URL was included from Scriptcase 7, in order to make the URL, of the applications generated by Scriptcase, cleaner and easier to associate them with applications. For example, using friendly URLs the link to a Scriptcase application ...
Correcting access error for the Scriptcase database
Sometimes we encounter an error accessing the Scriptcase database itself, as shown in the image below: ADONewConnection: Unable to load database driver This problem happens when we change the folder name of the scriptcase to another name, such as ...
Recent Articles
How to update Scriptcase
How to update Scriptcase Step 1. On the cPanel home page, find the "Scriptcase" icon in the SOFTWARE section and click on the icon. Step 2. Select the desired Scriptcase installation for the update. Step 3. Select the "Update" option. Wait for the ...
How to open a ticket.
How to open a ticket. To open a ticket in the customer area of Scriptcase Host, follow these steps: 1. Access the client area at https://clientarea.scriptcase.host/clientarea.php. 2. Log in with your username and password. 3. In the menu, click on ...
How to Create an Upgrade/Downgrade Request
How to Create an Upgrade/Downgrade Request Within the client area, go to Services. Then, select the service you want to upgrade or downgrade and click on "Manage." In the "Actions" options on the right, click on "Create Upgrade/Downgrade Request." ...
Updating the Security Module to Support the New LDAP
LDAP is a widely used protocol for user management and authentication in corporate networks. It allows applications to connect to a centralized directory with Active Directory to validate credentials and obtain user information. In version 9.12, ...
Updating the Security Module to Support Google Login
With the replacement of the NCP protocol with the ARPANET TCP/IP protocol, the internet gained space to evolve constantly. As more people joined the internet, things needed to happen faster, making the evolution process almost exponential: the faster ...