I'm executing the same query with same column name but in different case. An unique cached query generated while query executed first time. The query preparser only normalize the keywords and send to the SQL engine generates the Hash. Eventually use the cached query next use.
Now my question, The hash values are same for both of the queries. Then why it creates two cached queries.
Query1: select * from MyLearn.Test where Name['Kev1'
Query2: select * from MyLearn.Test where NamE['Kev1'
Good afternoon! Has anyone successfully configured connection from Oracle DBLink DG4ODBC to InterSystems Cache or IRIS ? Who can share working configuration for Unicode database? Thx!
For one of the reports I need to produce through Logi, I need to create a parameter/filter and pre-populate it with items from a query. Has anyone done that before? And if so how did you do it?
I have an issue related to Visual Studio Code and its InterSystems extension when exporting routines from the database to the file system.
The code entered via the terminal editor is encoded in DOS code page 437, but when I export it to my file system, even if I set the file opening to DOS CP 437, the accented characters which are two bytes long cause problems.
When using something like BeyondCompare when working with production class exports, the XData block "items" content very rarely if ever wind up in the same order making Beyond compare a total mess.
Is there a way of either sorting it on the export, or would I have to find (or write) some XSLT-based tool to go into the exported class and sort all the items? Does anyone know of a tool like that available?
Month.png)
