New Google Site for document sharing and editing
	Google has chosen to discontinue the article functionality in the Google Groups. To allow us to continue to share/edit documents, we have created a Google site. All discussions will remain here, but please see the new Google site to view MV related articles and to upload articles and any sample code. InterSystems will be launching an... more » By Janine Perkins  - Feb 2 2011 - 1 new of 1 message

	Empty string in MV for XML projections
	Due to the way that Cache projects XML, we have the need to put an empty string into a property so that the XML will project like: <tag></tag> instead of <tag xsi:nil="true" /> The problem I'm having is that setting the class like so: class->Property = "" actually sets the property to null which causes the second tag. So, all... more » By Jason Warner  - May 24 - 10 new of 10 messages

A Caché of Tips: ResultSets

Relational database systems store data in tables that organize the data in rows of columns. Views and ResultSets also return rows of columns. Historically, database systems have allowed programmers to execute an SQL query or stored procedure and process the returned ResultSet data. MultiValue users are familiar with the similar process of programatically... more » By Michael Cohen  - May 21 - 6 new of 6 messages

	SetAt() command not working for insert into 2nd value mark position when value is null
	I am having some problems with the following code. I am trying to insert some data and some data is getting lost. Is there any way to solve this? CRT 'ENTER CIT': INPUT ID pSource = "MVFILE.CITATION"->%OpenId(ID) POS=pSource->PAYMENTAMT->Count () + 1 pSource->PAYMENTBYUSER->SetAt( @AUTHORIZATION,POS)... more » By Rich Brim  - May 16 - 3 new of 3 messages

A Caché of Tips: Unit Test

In this MV Tip we will be discussing using the %UnitTest class. A unit test helps in code development by testing for the validity of a section of code. As developers improve and build on code they can use unit testing to verify that code changes did not affect the expected result with a given set of inputs. In addition to code verification, unit testing... more » By Steve C. (ISC)  - May 14 - 1 new of 1 message

	This week's tip
	Hi All, I forgot that this week our support people (who have been writing many of the tips) are in training. As a result, we did not publish our tip this week but will resume next Monday with a tip on %UnitTest. Lee H. Burstein Technical Trainer InterSystems Office: 617-225-3145 Home Office: 302-477-0180... more » By Lee Burstein  - May 10 - 2 new of 2 messages

	A Caché of Tips: Sockets
	In this MV Tip we will discuss and demonstrate the %IO.Socket and %IO.ServerSocket classes. If your application could benefit from the use of sockets, Cache provides these classes which can be easily integrated with your current MV codebase. Using sockets provide a standardized communication protocol that... more » By Steve C. (ISC)  - Apr 30 - 1 new of 1 message

	A Caché of Tips: HTTP
	Caché provides many classes that provide useful APIs. This week's Tip looks at the available %Net.HttpRequest and %XML.TextReader interfaces. As discussed in my MultiValue eLearning topic and in my recent MV Tip on XML, the web is based on text files containing mark-up text to tell the... more » By Michael Cohen  - Apr 23 - 5 new of 5 messages

	Fiddling with dates again
	Some people love fiddling with dates. I am not among them ;-) Are there functions in mvbasic and sql to cast between pick and mumps dates without putting 46385 in the source code? I now have all of 46385 numbers removed from our code, but I am attempting to use %ZEN.ComponentEx.schedulePane which appears to... more » By Dawn Wolthuis  - Apr 12 - 1 new of 1 message

	A Caché of Tips: Streams
	Streams are a great way of representing data in your application. They can be used to represent binary data like images, or very long character data. There are four types of stream classes Caché provides for this purpose: %Stream.GlobalCharacter %Stream.GlobalBinary %Stream.FileCharacter %Stream.FileBinary... more » By Emily Haggstrom  - Apr 9 - 5 new of 5 messages

A Caché of Tips: Email

Software programs have become increasingly complex over the past 20 years. Email, long ago considered a novelty, has firmly moved into the realm of necessity for electronic communication and notification. Having software that can send, respond, or otherwise interact with email can ease management of complex application environments or increase... more » By Mosier, Paul  - Apr 2 - 2 new of 2 messages