Assuming loops is required, the following 17 results were found.
This article serves as a best practice and reminder to myself on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which have workflows triggered from many deltas/changes. Why? Some...
quick article if you get the above error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 fix for the error: Execution Failed UnPredictable exception, Invalid statement...
in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one: -- the following loops through directory for any file beginning with Reference FOR %%A IN ('DIR InitializingFile*') DO ECHO %%A -- yields:...
as in check for the decimal point, check each digit thereafter to see if there are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function. How? If we're not going to use...
folder, the program will just create another one. Question How does the thumbnail name generating work? Answer: The program loops through the images folder and finds a name that isn't taken (something like "000065.bmp"). It won't overwrite existing...
Time when a PipelineBuffer from an upstream component is available to be processed // For each row in the pipeline buffer it loops through each of the input columns passed into the component // It locates the actual column value (including checking for...
'stringtofind', 'stringtoreplace') WHERE a.`fieldtochange` LIKE '%stringtofind%' Watch out for any recursive loops. Disclaimer: As I use this on more websites, I will update this article accordingly. At the time of print, I have only done one website...
Sort the resulting object array How? The function with comments: - Uses deprecated XMLHttpRequest to get file contents - Loops through each row and splits by commas (not within quotes) - Sorts the final array by a object label function...
Return ; -------------------------------------------------------------------------------------- ; Subroutine: LoopThrough: loops through folders and counts file sizes (including subfolders) LoopThrough: SB_SetText("Reading current directory...")...
a Creator report to the user, that they can select (tickbox) multiple records in that report, and then have a button that loops through all the selected (ticked) records. The example below documents a report of Quotes where we want to merge all the...
} } The list of keys looks like this: 1997-07-05 23:15, 1977-11-14 12:30, 1923-10-16 15:00 This above snippet of code, loops through the sorted list of keys and retrieves each record as follows:...
Reactivate any workflows you deactivated in step 1. Sample Code Consider the following standalone function which loops through every contact and deletes the duplicate lead (if a lead exists with the same email as a contact): // init v_Count = 0;...
// yields: Flat 8, House Corner The long answer is to consider the following code which generates a sample CSV and then loops through storing each row as a data record and outputting it to screen: // generate a sample CSV file v_DataCSV = "1,Joel...
albeit a brute force to loop through every active product and list their IDs. How? So here's the function I came up with. It loops through a maximum of 2500 products sorted in order of ID ascending (starting with ID=0) retrieving 250 per call and using...
void fn_AB_GenerateVacanciesCandidatesAssociations() Workflow: - Trigger: Standalone function triggered on execute Purpose: Loops through all candidates and creates records referring to the Candidate Ref and Job Opening Date Created: 2023-02-02...
"close": "15:00" } } Inserting as a subform on the employee record So now we just need to append the following code which loops through the map / associative array we just created and shove this onto every employee's record. My employee record form is...
about the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How? Here's a couple of working examples I use in production systems: Pre-amble: I'm applying to...