Assuming variable is required, the following 61 results were found.
-
Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {... } isBlank() can be used to check if the string only contains...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
prompt, you know that you have to refer to each tool using their full path unless you add it to the PATH environment variable: This allows you to use keytool from any folder: Open a command prompt Type CD C:\Program Files\Java Determine your JDK folder...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
an SSRS input parameter Add a dataset Query type: Stored Procedure Refresh fields button Parameter name (oracle input sp variable) and Parameter value (ssrs input parameter) Fields (field name=ssrs reference, field source=oracle sp field name) 1. Create...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Password=myPassword;Socket=MySQL;Option=3; On Windows, the socket variable is the name of the named pipe that is used for local client connections. The default value is MySQL. On Unix platforms, the socket variable is the name of the socket file that is...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
A short article explaining how Zoho Deluge allows a variable assignment to be written across multiple lines, as long as the statement ends with a semi-colon. This has a limited number of use cases, but is useful to be aware of if you have not come...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
in ZohoCRM: Create a function with a string parameter called "crmAPIRequest". It has to have this name. It is a reserved variable and will contain all the webhook payload data. When a webhook is pointed at it, the crmAPIRequest variable will hold the...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
confidentiality is somewhat important, some of the images will be censored or data changed in the example below. Add a variable (preferably to the scope of the package) called "SourceExtractFile" and give it the data type "String". Set the Value to the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
in report parameter expressions". I tried this with "Default values" and got the same problems. Note: before you try, "Variable values cannot be used in report parameter expressions" either. I'm using an Oracle/PLSQL database for this so whether you're...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
:= "", Kind := "", P* ) { ; v.90 By SKAN on D1CC @ goo.gl/jyXFo9 Local Static xDetails If ( sFile = "" ) { ; Deinit static variable xDetails := "" Return } fex := {}, _FileExt := "" Loop, Files, % RTrim(sfile,"\*/."), DF { If not FileExist(...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
and the second time to add the collection to the subform. Syntax for inserting a row into a subform: // declare a variable to hold the collection of rows = Collection(); // declaring the row = .(); // assigning values for various subform fields in the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
as many rows as required) = .(); // assigning values for various subform fields in the row . = ; . = ; // declare a variable to hold the collection of rows = Collection(); .insert( , ); // insert the rows into the subform through the variable...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
receive parameter crmAPIRequest (of datatype string in your function) m_Payload = crmAPIRequest; // // initialize response variable m_Response = Map(); // // get xero signature v_XeroSignature = "SIGNATURE_FAIL"; if(!isnull(m_Payload.get("headers"))) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Generate the file The code here is a cut down version just to demonstrate generating a text file and storing this into a variable: // // initialize v_CSVString = "Bank Sort Code,Bank Acc. No,Account Holder"; v_CSVString = v_CSVString +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
A quick article on how to use remove() on a map variable as well as a snippet of code to copy tags from a contact to a deal record. Why? Anything that stumps me for 30 minutes is worth writing a quick article on. In this case, I had a function querying...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
WHERE ThisRecord = :UserSpecifiedID -- where :UserSpecifiedID is one of the report parameters (Oracle local variable) -- where :ParameterToCheck is another of the report parameters (Oracle local variable) MDX Check /* For Expression Value. Remember to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
every column containing strings in the database and we are somewhat limited in Sql Server 2008 R2 by 4000 characters in a variable (so I couldn't store it in a local variable). So the idea here is to run the below example which outputs a huge SQL query...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
All oracle utilities and connections working on my computer (except for TNSPING). TNS_ADMIN is another environment variable used that we must maintain (current value at "C:\app\\product\11.2.0\client_1\bin") Setting environment variables using the...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
text BEFORE the gui,show command. The above example is used in a search form where "SearchButton" is the name of the variable (picture) to change. Note that I am using the method of hiding the input button and putting an image over it. The code above is...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
and source code of each element by dragging the curser over the webpage. Frequently Asked Questions What is a pwb? - A variable that contains a pointer to the web browser object (Internet Explorer). Here is a simple script for creating one: Code: ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *