This blog article demonstraites a technique to access the LinearHash service Universal Driver Manager console through custom OpenInsight BASIC+ code.
The SYSLISTS table in OpenInsight can become cluttered with old records and much like a TEMP directory it can and should be cleared out. When it comes time to clear the table the clear_table command won't work because SYSLISTS is a protected system table. Instead the easiest thing is to simply select and delete all the records.
Here is a sample routine to do the task.
Benchmarking with real data or copies of real data is useful but it becomes problematic if you want to compare the performance of one site with another site and can't use the same data set at both sites. Having a consistent data set that is sanitized and can be used at any site can be a useful for performance benchmarks and consistent testing.
Below is a download link for a LinearHash table and accompanying source data table of a 1 million row person information table. Records are sequentially keyed from 1 to 1,000,000.
OpenInsight supports updating indexes directly on the server by running the index update process through the Windows Task Scheduler. If you use that process it has probably silently failed at some point leaving you without indicators until customers call with problems. The article walks through setting up notifications for failed indexes.
Here is a little tip when working with Wireshark to diagnose problems with traffic flow to a remote host. This filter command shows resent TCP packets for a remote host.
The O4WDialog function is used to generate and display dialog boxes. This post shows you how to remove the default close button in the title that cannot be handled as an event in OpenInsight.
This article contains a sample BASIC+ routine for use in OI (OpenInsight) that a developer can use to log information to the Windows Event Log on the system running OpenInsight. Writing to the event log is useful for web applications that need to log server exceptions that a system administrator can review later but it's also useful for desktop applications that need to do the same thing without bothering the user.
This is a short tech tip for working with the OpenInsight RTI_CDOMail function. I recently uncovered a situation where the function was returning "Error at step create No control specified" when trying to send email from a newly setup workstation.
Interacting with VBScript code embedded in OpenInsight BASIC+ code is a useful technique. This article provides an example and discusses the difference between using Run or Eval methods to call the embedded code.
Regular Expressions are short and often complex pattern matching statements that can do the work of an entire pattern matching function. This blog post provides an example of how to harness regular expressions from inside OpenInsight BASIC+ code.