Question Jean Millette · Nov 11 Determine a String is an SQL Reserved Word Hello, Is there a programmatic way (in ObjectScript) to determine if a string is an SQL reserved word (aside from using embedded SQL to try to name a property with that string and look for the error :-))? Thank you, Jean #ObjectScript #SQL #InterSystems IRIS 0 2 0 58
Question Jean Millette · Mar 10 Questions about Java Versions for %JDBC External Language Server I have questions about Java Versions needed for setting up a %JDBC External Language Server I'm trying to start the %JDBC. External Language Server my local instance of IRIS (2023.1.2). I've recently upgraded Java to version 21.0.1 When starting the External Language Server, I get this error message: Start External Language Server %JDBC Server: #Java #JDBC #InterSystems IRIS 0 2 0 150
Question Jean Millette · Apr 18, 2023 VSCode: "ObjectScript Class" As "New File" Option? What VSCode configuration/setting/knowledge am I missing? Why doesn't "ObjectScript Class" (or something similar) appear as an option when I select "New File" from VSCode's "File" menu? Thanks #Health Connect #InterSystems IRIS #VSCode 0 3 0 217
Question Jean Millette · Apr 20, 2017 Eclipse SQL Client Plug-In for Caché? Atelier Users:Has anyone found an Eclipse plug-in that provides the capability to connect to a Caché server and give the user a way to write SQL queries using the tables from that server? I'm picturing something like a "WinSQL"-client built as an Eclipse plugin.I've found and tried the following, but I couldn't get it to connect to my local Caché instance.http://eclipsesql.sourceforge.net/ #Beginner #Terminal #SQL 2 4 0 880
Question Jean Millette · Feb 14, 2017 Looking for Best Zen MVC Recipe for Passing "View" Data to DataModel and Form... ...in order to initialize the data model and form with data from another object. #ZEN #Caché 0 1 0 385
Question Jean Millette · Jul 25, 2016 How to Connect to External Non-Caché DB With COS and Without DSN? We are creating a package (written in Caché Object Script) that will provide access to an external DB (MySQL). Because applications that use our package will be run from machines with various, potentially unexpected, operating systems, we’d like to establish a connection to the external DB without using DSNs (we’ve heard that setting up DSNs on certain non-Windows machines can be cumbersome and problematic). #JDBC #ODBC #ObjectScript #SQL #Caché 0 4 0 1.2K
Questions