Here are two tips for finding currently attached tables in OpenInsight if you can only remember part of the table name.

If you have databound forms in OpenInsight and want to locate the forms bound to that table you can quickly find them with this query:

LIST SYSREPOSWINS TABLES WITH TABLES EQ 'YOUR_TABLE_NAME'

The result is a list of forms bound to the table.

What if you don't have a databound form? You can widen the search using this query:

LIST SYSREPOSWINS TABLES WITH ALL CONTAINING 'YOUR_TABLE_NAME'

The query searches the entire form for the occurence of the table name. It does this by using the built-in field ALL which represents the entire record.

When a table opened for access using the open statement a table handle is returned for locking,reading, and writing records. This function looks up the table handle and returns the corresponding table name.

Here is a useful code example showing how to call the Windows shell run method to open any document that is registered with an application. If the file isn't registered whit an application Windows will prompt to select the application using the same dialog that would normally appear when you double click an unrecognized file.

Included in this blog article is another tool to help when benchmarking OpenInsight systems. The PERSON_INFO_FREEBASE_TEST table available for download below is an extended version of the PERSON_INFO_TEST table that include a multi-value field containing references to records in the CS_FREEBASE_TOPICS table.  The test table is 1 million rows of fake person information. Records are sequentially keyed from 1 to 1,000,000.

PERSON_INFO_FREEBASE_TEST Dictionary:

Utility to get the last compile date time stamp from a stored procedure by extracting it from the compiled OpenInsight routine.

Simple Hello World program for OpenInsight O4W. Great starter if you need a basic program to test out some new code.

Out of the box OpenInsight 9.4 O4W ships with a depedency on JQuery library hosted at Google. If you are unable to access the internet or are blocked from accessing Google trying to load a local O4W page will fail. The start.htm login prompt is a quick and easy indicator. If your login box is in-line as shown below the JQuery libraries didn't load:

Viewing the page source reveals a script dependency to googleapis.com.

If you are experiencing web server gateway errors from pages generated with OECGI this article provides troubleshooting trips to resolve the problem.

Tips for resolving OECGI Login Failed error 1003.