This macro dynamically activates or deactivates warning messages control. This macro modifies the application exit URL. This macro its used to set the number of decimals. This macro dynamically set a form field attribute to '"Read-Only" In the table 'MyGuests', the 'id' column is an AUTOINCREMENT field: CREATE TABLE MyGuests (. This macro is intended to inhibit the query fields on the initial load. If we perform an INSERT or UPDATE on a table with an AUTOINCREMENT field, we can get the ID of the last inserted/updated record immediately. This macro dynamically display or not a specific field. This macro its used to block a field to get any data that would be typed on it. Although the second INSERT statement inserted three new rows into t, the ID generated for the. Sc_field_disabled ("Field_Name = True/False", "Parameter") Value of the AUTOINCREMENT column for the last INSERT.
This macro changes the color of a determined field text.
This macro dynamically show/hide the fields of a specific block. This macro allows the application to display customized messages. Shows sc_ajax_message ("Message", "Title", "Parameters", "Parameters_Redir") Add column with NULL value To insert into a MySQL table rows with columns having NULL, add the NULL value without quotes.
#SCRIPTCASE FIND LAST INSERTED ID HOW TO#
Follows a table of all macros and special variables from ScriptCase, including the list of applications that works for each one. In this tutorial you can learn how to work with NULL in MySQL tables: Insert, Update, and Select columns with NULL value. SCRIPTCASE MACROS Scriptcase has macros and special variables that allow the user to manipulate events, buttons, applications, security control, manipulate with dates, etc.
0 kommentar(er)
