Caché

Syndicate content 126 

Dear Colleagues,

Recently I am working on a Cache project should enable the customer, to update our Cache application independently from us. Our idea is a client (preferred .net) application that will copy all the necessary Cache stuff (classes, routines) into a cache database. For this, we are looking for the appropriate technology – in old times this would be a CacheDirect.

Last answer 5 September 2016 Last comment 7 September 2016
0   0 1
348

views

0

rating

Hello Fellow Cache Developers:  

Has anyone ever created an index on values of a list property?   If so, would you be willing to share an example?

Also, feel free to offer input and suggestions regarding use of indexes on List values.

Here is my database scenario:

Parent Class:

PropertyA - %String  

PropertyB - %Integer 

Child Class:

PropertyC - %Integer

PropertyD - list of %Integer

Data illustration:

Last answer 31 August 2016 Last comment 31 August 2016
0   0 1
346

views

0

rating

I know that Cache files can be stored as XML and UDL based files. Is there any way to determine in which format the file(class, routine, dfi and so on) is stored? Because you can easily name your XML based file as class.cls and it will be perfectly valid. 

I know that one way to check whether this file is in XML format is just try to parse it like 

Set st = ##class(%XML.TextReader).ParseStream(contentStream)

if $$$ISERR(st) return $$$NO

else return $$$YES

However, is there a better way? 

Last answer 30 August 2016 Last comment 30 August 2016
+ 2   0 1
194

views

+ 2

rating

Hello everyone,

I'm trying to authenticate a user(Health Share clinician) from a Java Application. 

I 'm already connected to Caché and able to run SQL commands.

My question is: How can I authenticate a user using only SQL? In fact, what I want is verify if the users exists in the base and if the given password is the same used in Health Share.

There is a column 'password' in Security.users table but I'm not able to see its content, even so, I don't know which hash function to use to compare with.

Last answer 26 August 2016 Last comment 29 August 2016
+ 1   0 2
843

views

+ 1

rating

Hi ,

           i need to configure the CSP for IIS 8.5 .

          Server:windows 2012 R2 64 bit

          Cache version :5.02

         We followed the document "http://docs.intersystems.com/cache20152/csp/docbook/DocBook.UI.Page.cls?                       KEY=GCGI_win#GCGI_iisv7".

         We  got error 

HTTP Error 404.17 - Not Found

The requested content appears to be script and will not be served by the static file handler.

 please help...

 

Last answer 29 August 2016
0   0 3
0

comments

516

views

0

rating

Hi -

I have 3 classes: "Class A" has a property X, "Class B" has a property which is a Class A, and I have a "Class C" which has a property of a Class B.

Class A definition

Class USER.ClassA Extends %Persistent

{

Property Propx as %String;

}

Class B definition

Class USER.ClassB Extends %Persistent

{

Last answer 29 June 2016 Last comment 24 August 2016
0   0 2
209

views

0

rating

Hello Cache experts,

Has anyone tried using Cache object script to check windows service is running or windows service installed or not on same computer or remote computer ? basically i am trying to develop cache program which will check "windows service" running or installed on current computer or remote computer. Based on the status of this windows service, i want to write some business logic in our application. Any suggestions will be more welcome

Last answer 5 August 2016
0   0 1
0

comments

259

views

0

rating

I need a generic way to check if all the properties on an object instance are null. Has anyone got some code they could share?

I could of course add a method to each class and pass in all the properties and test them but I'm sure there must be a generic way to do this. A generator method perhaps?

Regards

Mike

Last answer 4 August 2016 Last comment 4 August 2016
0   0 1
370

views

0

rating

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).

Last answer 1 August 2016 Last comment 26 July 2016
0   0 4
685

views

0

rating

I want to override the Get and Set methods of a class property.  The class maps to a pre-existing global. The property is defined like so:

Property Invalid As %Library.Boolean;

with the property mapping to a node like ^GLOBAL(Code,"INVALID")=1
Code is a property in the same class.

The value can be 0 or 1 or the node might not exist. When it doesn't exist I want the value of the SQL field to come out as 0 (false).

Last answer 22 July 2016 Last comment 28 July 2016
+ 2   0 2
854

views

+ 2

rating