Stack Overflow
Stack Overflow

Questions tagged [intersystems-cache-studio]

The Caché Studio lets you create and edit Caché ObjectScript routines in any namespace on your system.

12 questions
3
votes
2 answers

Difference between two date time stamp in Intersystems Cache

I would like to find out the number of hours and minutes between two date time stamp. if for example sDateTime = 2016-01-01 01:00 eDateTime = 2016-01-03 02:30 I would like it to output it as 49:30 (49hours and 30minutes) I am unable to figure…
jk1844
  • 327
  • 1
  • 5
  • 12
2
votes
3 answers

Intersystems cache: and error in Classes : How to solve AND avoid?

I have a single class in Intersystems Cache that writes records on the globals based on the user calling it Iterates on the globals and places results on a string Writes the said result to a notepad file via FILE However, a part of the code…
Malcolm Salvador
  • 1,476
  • 2
  • 21
  • 40
2
votes
2 answers

Display %ROWCOUNT value in a select statement

How is the result of %ROWCOUNT displayed in the SQL statement. Example Select top 10 * from myTable. I would like the results to have a rowCount for each row returned in the result set Ex +----------+--------+---------+ |rowNumber |Column1 |Column2…
user6284097
  • 157
  • 1
  • 1
  • 9
2
votes
1 answer

Updating a form generated by a wizard based on a class

I'm following the tutorial here. I created my data class and added a name property using the wizard. I then created a zen form using the wizard, during which I selected the data class created above. Everything worked great. However, I went back…
user736893
1
vote
1 answer

Update value of other column on update of this column

i have question, how to do something like a trigger in Intersystems Cache. Situation: for example i have table X with properties(columns) valueA,valueB i Want to update valueB when valueA changed by UPDATE. I have define global variable ^VALUEBGENER…
Dmitriy Sosnovich
  • 21
  • 7
1
vote
0 answers

Subversion commands work at the OS shell command-line but not within the IDE

I've organized my repository using TortoiseSVN. I was careful to use only svn commands while creating my file structure. Now all Subversion commands are working at the command line but not from within my IDE (Intersystems Cache Studio). Basically…
Thomas Cherickal
  • 11
  • 3
0
votes
1 answer

zen report-dividing two summation values

I want to divide two columns summations and make sure that the other number is not zero. I tried with the statement below but it does not work can anyone tell…
raghad almajid
  • 1
  • 1
0
votes
1 answer

InterSystems Cache ObjectScript vs Java as in Web application development

Recently My Project Manger has asked me to work on InterSystems Cache ObjectScript. Earlier i used to work as Java Developer (J2EE). So my question is how different is Cache from java. Comparison would be great to have.
Sudarshan
  • 9
  • 3
0
votes
1 answer

Linux getting rid of Carriage Return when file is being written out by intersystems cache

Working with Intersystems cache and writing a file out to a unix server and upon opening in WordPad++ the Carriage return is missing but the Line feed is still there. Our process works in windows but for some reason not in Unix.
Tidesglenn
  • 21
  • 6
0
votes
2 answers

Connecting to cache instance (csession) remotely

Is there a way to connect to cache instance (csession) remotely? Let's say the intersystems is on a container, and I want to use csession on the remote server from my local machine, is there a way (without direct ssh) to run the cache instance? I'm…
Mahyar
  • 1,011
  • 2
  • 17
  • 37
0
votes
2 answers

Character Counting within a loop

Instead of using hardcoded calls like I did in the code below, is it possible to have use a WRITE command within a For Loop to print out number of times each character is used? Below is what I have written, which will give me "A=n" but what I would…
M Noob
  • 19
  • 4
-2
votes
1 answer

How can I filter records returned by a stored procedure call?

I'm trying to use a stored procedure to search for users in my WinFomrs application. I have this code: Regex regPattern = new Regex(searchTextBox.Text); dataGridView1.DataSource = users.GetAllUsers() .Where(item =>…
Reden Rodriguez
  • 35
  • 1
  • 7